Posts by Kris Roberts on InterSystems Developer Community

Question

Kris Roberts · Apr 1

Intersystems Reports - Logi Reports (23.2) - Parameters on the report - can they be populated to show choices from another query?

For one of the reports I need to produce through Logi, I need to create a parameter/filter and pre-populate it with items from a query. Has anyone done that before? And if so how did you do it?

Thanks,

Kris

#InterSystems Reports (Logi) #InterSystems IRIS

0 0

0 83

Question

Kris Roberts · Apr 1

InterSystems Reports - Logi Report (23.2) - How to code a stored procedure that will return a result set to be used in a report

A report that I need to create - I need to write a class method that will execute a few queries and save the data to a class and then return the data in a result set that can be used in the Logi report as a Stored procedure.

I can create the class method that is a Stored procedure and do the queries and manipulate the data, however I am having an issue at the end of the method to return the fields back as a result set.

#InterSystems Reports (Logi) #InterSystems IRIS

0 3

0 128

Question

Kris Roberts · Dec 14, 2023

Trying to use %Library.PosixTime to convert a date/time and add/subtract seconds to the PosixTime but then when it goes back to a timestamp doesn't seem to have worked.

#Caché #InterSystems IRIS

0 2

0 224

Question

Kris Roberts · Dec 10, 2023

Converting $H to UTC for a timezone that is not local (Object Script)

Working on a project where we have a web browser that we have to determine a pickup date/time for a pharmacy in a different time zones.

We store the different time zones with their Daylight and Standard offsets.

We have a object script method that figures out the the pickup date/time for a particular pharmacy in their local time zone but the data is being returned in the $H format.

#InterSystems IRIS

0 16

0 375