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 19
Question Ashok Kumar · Apr 20 OpenAPI property mismatch in Spec First approach IRIS documentation Hello Community, #InterSystems IRIS 0 1 0 48
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 138
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 228
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 152
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 85
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 75
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 205
Question Ashok Kumar · Oct 30, 2023 IRISTEMP database size increases leads the production instance down Hello Community IRISTEMP database consumes more disk space and make the production instance down when running Bulk SQL queries (maybe other processes aswell) Is setting up the "Maximum" size it resolves the problem?. Is this setting impacts the performance? What are the approaches to resolve it sample screenshot #Databases #SQL #System Administration #InterSystems IRIS for Health 1 2 2 190
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 134
Question Ashok Kumar · Oct 19, 2023 Block size error on Database creation Hello Community, I got the below error while creating a new database. #Databases #System Administration #InterSystems IRIS 2 7 0 208
Question Ashok Kumar · Oct 17, 2023 FHIR Profile Validation Issues Hello Community, I've created my FHIR patient profile and POST into FHIR endpoint in Intersystems FHIR Server. http:localhost:52773/fhirr4/StructureDefinition I use the profile url into my Patient resource without the meet the profile requirements. http:localhost:52773/fhirr4/Paient The resource is stored successfully in the FHIR Server instead of a FHIR exception. Why the resource doesn't validate with the mentioned profile? #FHIR #Interoperability #InterSystems IRIS for Health 0 8 0 142
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 280
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 194
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 299
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 162
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 128