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 39
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 18
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 110
Question Michael Wood · Jun 17, 2024 CDATA What causes the ![CDATA[ in a string field? #InterSystems IRIS for Health 0 6 0 196
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 104
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 138
Question Michael Wood · Mar 27, 2024 Empty export file Has anyone experienced exporting a deployment file and when deploying it, it is empty? IRIS for UNIX (Red Hat Enterprise Linux for x86-64) 2021.1 (Build 215_0_21129U) Wed Sep 29 2021 10:10:37 EDT [HealthConnect:3.3.0] [HealthConnect:3.3.0] #InterSystems IRIS for Health 0 0 0 63
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 154
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 200
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 210
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 197
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 231
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 125
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 333
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 417
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 231
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 313
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 269
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 195