Question Ashok Kumar · Sep 29, 2023 SQL ObjectSelectMode for Object properties Hello Community, I have couple of question about the DynamicSQL. 1. The %ObjectSelectMode is working perfectly in the DynamicSQL for the object property in direct query. However this is not supported for class query. Is there any way to resolve this / Get the object value for class query result. #Data Model #SQL #InterSystems IRIS #InterSystems IRIS for Health 0 3 0 381
Question Ashok Kumar · Sep 24, 2023 QuickStream issues in FHIR Interoperability production I have created a FHIR endpoint and send the FHIR resource to FHIR Interoperability production class which is HS.FHIRServer.Interop.Service through the the created endpoint(/r4). I can able to see/get the HS.SDA3.QuickStream(It use CacheTemp.HS.Stream temporary global) on the fly(In between the process). I'm unable to get the FHIR resource from the QuickStream once the process completed. Is this HS.SDA3.QuickStream is wiped out from the system once process completed? #FHIR #Interoperability #JSON #InterSystems IRIS for Health 0 1 0 343
Article Ashok Kumar · Aug 31, 2023 2m read Utilize custom datatype class for User-defined DDL table Creation In this article, I am demonstrating how to create a table column(formerly known as properties) with your custom datatype classes by using User defined DDL. Properties are the crucial member of the persistent class definition. Datatypes are essential to define types of values that are stored in a table column. In general, the datatype names of SQL different from Intersystems datatypes, such as VARCHAR = %String. #Databases #Multi-model #Tutorial #HealthShare #InterSystems IRIS #InterSystems IRIS for Health 1 0 0 252
Question Ashok Kumar · Aug 14, 2023 Generate Method for properties Hello All, How do I generate my own method for all properties in my class definition like auto-generated methods PropertyGet(), PropertySet(), PropertyGetStored(). Thanks. #InterSystems IRIS #InterSystems IRIS for Health 2 14 0 403
Article Ashok Kumar · Aug 14, 2023 8m read Working with %JSON.Adaptor In this article, I walk through the %JSON.Adaptor class. #Best Practices #JSON #InterSystems IRIS #InterSystems IRIS for Health 12 2 6 1.1K
Question Ashok Kumar · Aug 11, 2023 Trailing zero are truncated in %Set method of %DynamicObject Hi Community, Whenever I insert a decimal value with trailing zero(ex:12.0000) value in my JSON object dynamically through %Set method. It truncates the trailing zeros. However If I use literal constructors { } It working as expected. So, In my case the JSON will be generated dynamically. I can't go with "Curly Bracket { } " and the JSON schema not string as well.Is there any way to fix this? #JSON #InterSystems IRIS #InterSystems IRIS for Health 0 2 0 264
Question Ashok Kumar · Aug 10, 2023 Construct clone of %execute result of %SQL.Statement class Hi Team, Is there any way to take a clone object of executed query result of %SQL.Statement #InterSystems IRIS #InterSystems IRIS for Health 0 3 0 184