Question Michael Wood · Jan 30 $ZDATETIME($HOROLOG,3) - 3 hours Anyone know how to subtract three hours from $ZDATETIME($HOROLOG,3)? If $ZDATETIME($HOROLOG,3) returns 2025-01-30 10:17:04, I would like $ZDATETIME($HOROLOG,3) - 3 hours to return 2025-01-30 07:17:04 #ObjectScript #InterSystems IRIS for Health 0 7 0 106
Question Michael Wood · Jan 15 Using context variable in code block I need to use a context variable in my code block for the table to query. When I use :content.table, it does not work. When using the literal, it does. How do I get the :context to work? #Business Process (BPL) #SQL #InterSystems IRIS for Health 0 4 0 66
Question Michael Wood · Jan 13 %Source value into a BPL context parameter I have a Service reading a flat file and routing to a Process. Does anyone know how to get the %Source value into a BPL context parameter? #Business Process (BPL) #InterSystems IRIS for Health 0 1 0 40
Question Michael Wood · Jul 29, 2024 Check if DTL variable is an empty object I have a DTL that calls a custom function that returns an object. How do I code the IF statement to check if the object is empty. e.g. IF tObject={} #DTL #InterSystems IRIS for Health 0 3 0 119
Question Michael Wood · Jun 17, 2024 CDATA What causes the ![CDATA[ in a string field? #InterSystems IRIS for Health 0 6 0 219
Question Michael Wood · Jun 14, 2024 Create a unique constraint on an existing table I have a table that is already created and contains data. I need to create a unique constraint that is a combination of two fields. Is there a way to do this in a SQL statement? Also, I would lke to know how to add it in the table class. #ObjectScript #SQL #Caché #InterSystems IRIS for Health 0 1 0 122
Question Michael Wood · Jun 6, 2024 API Response truncating? I have an API that does not have all the data. Like it is truncated. Magic number of characters seems to be 163,280 I do an <assign> context.RawBundle=##class(%DynamicObject).%FromJSON(context.FHIRResponse.Body) The error does not happen when the response is < 163,280 chars. And when < 163,280 chars, it is a complete FHIR Bundle. Have anyone experienced this? If so, what is the resolution? #API #Business Process (BPL) #JSON #InterSystems IRIS for Health #Health Connect 0 2 0 147
Question Michael Wood · Jan 19, 2024 INSERT OR UPDATE only inserts I am trying to do a INSERT OR UPDATE SQL query, but the query always inserts new rows to table. Is it how I defined the table or am I mising something in the query? table defines as, Class AH.AHCOMMON.Tables.HospDepartmentData Extends %Persistent [ Language = objectscript ]{ #SQL #InterSystems IRIS for Health 0 1 0 171
Question Michael Wood · Jan 19, 2024 FHIR payload to FHIR message class I have this response, which is a FHIR location resource in a bundle. I would like to load the entry(0).resource into a context property defined as HS.FHIR.DTL.vR4.Model.Resource.Location so I can use it as a source in a DTL. Any help would be greatly appreciated. Thanks. #Business Process (BPL) #FHIR #InterSystems IRIS for Health 0 4 0 208
Question Michael Wood · Dec 7, 2023 How to check if REST response field not in response I have a message class define. But sometimes the RelatedItems fields is not returned. Parameter %JSONIGNOREINVALIDFIELD As BOOLEAN = 1; Property RequestedTerm As AH.AHLIB.Custom.Symedical.Message.PostRelationResponse.termsRequested; Property RelatedItems As list Of AH.AHLIB.Custom.Symedical.Message.PostRelationResponse.RelatedItems; Respnse normally will return someting like this, #Business Process (BPL) #REST API #InterSystems IRIS 0 2 0 216
Question Michael Wood · Nov 30, 2023 Custom Message Class Property Definition I have a API that is returning on objext with four fields. Two are arrays that are empty. How can I define the message class property to ignore/handle "Messages" and "SharedRelations"? #ObjectScript #InterSystems IRIS for Health 0 3 0 204
Question Michael Wood · Nov 28, 2023 Response not returning to BPL I getting the response back to my method fine, but it is not returning to my BPL. What am I missing to get the response back to the BPL? #ObjectScript #REST API #InterSystems IRIS for Health 0 8 0 247
Question Michael Wood · Nov 28, 2023 Message Property begins with Special Character I am creating a custom message class. How do I define @name and #text fields? this? Property name As %String (%JSONFIELDNAME = "@name"); #ObjectScript #InterSystems IRIS for Health 0 1 0 130
Question Michael Wood · Nov 17, 2023 INSERT OR UPDATE When using INSERT OR UPDATE command, How does the command know if the row exists? #ObjectScript #SQL #InterSystems IRIS for Health 0 3 0 359
Question Michael Wood · Nov 3, 2023 Max size limit for a %Library.DynamicObject variable Is there a size limit to what a %Library.DynamicObject define variable can hold? #InterSystems IRIS for Health 0 5 0 449
Question Michael Wood · Sep 18, 2023 Mapping error I am mapping a field to the FHIR Location resource field address.line. Using message class HS.FHIR.DTL.vR4.Model.Resource.Location The line field is repeating I set field as such, This causes the error, #DTL #FHIR #InterSystems IRIS for Health 0 2 0 238
Question Michael Wood · Aug 31, 2023 replace a carriage return linefeed with a space in DTL? Would this replace a carriage return linefeed with a spacein a DTL? $REPLACE(string,"\X0D0A\",$CHAR(32)) #DTL #InterSystems IRIS for Health 0 1 0 338
Question Michael Wood · Jul 18, 2023 Method to return value of object element I am trying to write a class method to return the value of a object element. Input to method is the object and element. I am not getting a value returned. What am I missing? #ObjectScript #InterSystems IRIS for Health 0 8 0 285
Question Michael Wood · Jun 9, 2023 Find business service in custom service class I am writing a custom business class. I need to use the business service name that will be using the class within a SQL statement. How can I get the business service name that is using the class? #ObjectScript #InterSystems IRIS for Health 0 3 0 200