Question Ashok Kumar · May 13, 2024 SQL LOAD DATA ISSUES Hello Community, I'm trying to load a file by execute this LOAD DATA SQL command in both studio and SQL-SMP I got the below error. #SQL #InterSystems IRIS 0 4 0 107
Question Ashok Kumar · Apr 26, 2024 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 95
Question Ashok Kumar · Apr 20, 2024 OpenAPI property mismatch in Spec First approach IRIS documentation Hello Community, #InterSystems IRIS 0 2 0 117
Question Ashok Kumar · Jan 21, 2024 $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 190
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 330
Question Ashok Kumar · Dec 19, 2023 Grafana connectivity to local IRIS Hello Community, #System Alerting and Monitoring (SAM) #System Administration #InterSystems IRIS #InterSystems IRIS for Health 0 1 0 223
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 122
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 110
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 248
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 253
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 189
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 250
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 205
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 349
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 299
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 231
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 366
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 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 244
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 167