Question Ashok Kumar · Apr 26 SQL Cached Queries understanding Hello Community, I'm executing the same query with same column name but in different case. An unique cached query generated while query executed first time. The query preparser only normalize the keywords and send to the SQL engine generates the Hash. Eventually use the cached query next use. Now my question, The hash values are same for both of the queries. Then why it creates two cached queries. Query1: select * from MyLearn.Test where Name['Kev1' Query2: select * from MyLearn.Test where NamE['Kev1' #SQL #InterSystems IRIS 0 0 0 55
Question Ashok Kumar · Apr 20 OpenAPI property mismatch in Spec First approach IRIS documentation Hello Community, #InterSystems IRIS 0 2 0 68
Question Ashok Kumar · Jan 21 $Storage and Private global Hello Community, The process private global doesn't impact the $storage. But, Why the value has decreases at first time of initialization. #Globals #InterSystems IRIS #InterSystems IRIS for Health 0 4 0 146
Question Ashok Kumar · Dec 21, 2023 Insert ListOfObject via SQL Hello Community, Generally we could insert the stream object through SQL for stream properties and insert the list values for list of %String property. So, Is there any way to achieve this insert for the list of objects property( ex: Property CodeTable As list of Sample.CodeTable) via SQL? #Relational Tables #SQL #InterSystems IRIS #InterSystems IRIS for Health 1 9 0 233
Question Ashok Kumar · Dec 19, 2023 Grafana connectivity to local IRIS Hello Community, #SAM - System Alerting and Monitoring #System Administration #InterSystems IRIS #InterSystems IRIS for Health 0 1 0 158
Question Ashok Kumar · Dec 19, 2023 Is User Defined error will rid out after IRIS upgrade Hello Community,. I've updated the IRIS community form 2023.2 to 2023.3 and I didn't see the User defined(Sample) error messages in ^IRIS.Msg global even I verified in both pointer and data level. I re run the set x=##class(%MessageDictionary).Import("error.xml") After import I could see the pointers and data in ^IRIS.Msg Is the User defined error will reset from the server after IRIS upgrade? #Error Handling #InterSystems IRIS #InterSystems IRIS for Health 0 1 0 86
Question Ashok Kumar · Dec 17, 2023 Remove the validation part in the disp class on spec-first approach by default Hello Community, Is there any way to avoid generating the built in validation inside the classmethod from the .disp class definition. I've added the resource with path parameter as integer in swagger 2.0 open API. The class method(in my case getRandom is the class method) inside .disp handles the integer validation by default. Is there a way to avoid/remove by default. default validations for Integer #REST API #InterSystems IRIS #InterSystems IRIS for Health 0 0 0 78
Question Ashok Kumar · Dec 17, 2023 Error While Extending %JSON.Adaptor in xData MimeType of application/json Hello Community, I've extended the a class %JSON.Adaptor in my class definition and it contains the xData block MimeType of application/json. I got the error while compiling. Why this error occurs and how to resolve it #JSON #InterSystems IRIS 0 8 0 208
Question Ashok Kumar · Oct 22, 2023 JWT enabled Web Application Hello Community, I've enabled the JWT Authentication in my web application. I invoked the /login page to get the JWT and it creates an entry in %SYS.TokenAuth table. Is there any time span for the entries will rid out from the table automatically or It's a manual process? Where can I find the JWT signature private/public key settings screenshot web application #Authentication #REST API #InterSystems IRIS #InterSystems IRIS for Health 0 0 0 139
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 286
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 197
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 173
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 130