Question Ashok Kumar · Jul 20 Index Build uses SetMapSelectability Hello Community, #Databases #Indexing #Performance #SQL #InterSystems IRIS for Health 0 3 0 38
Question Ashok Kumar · Jul 14 Additional Cached Query generation while execution Hello Community, I've seen two cached queries are generated while executing a query. So, Why the additional query is generated and what is the use of it. #SQL #InterSystems IRIS #InterSystems IRIS for Health 0 3 0 46
Question Ashok Kumar · Jul 13 FHIR SQL Builder Access Issues Hello Community, I'm unable see the FHIR SQL builder /csp/fhirsql and /csp/fhirsql/api/ui endpoints in web application to access the FHIR SQL builder. I'm using community edition 2024.1 and it contains the "FHIR SQL Builder". #FHIR #REST API #SQL #HealthShare #InterSystems IRIS for Health #Health Connect 0 8 0 78
Question Ashok Kumar · Jul 4 JWT enabled FHIR Server web app access Hello Community, #FHIR #REST API #Security #InterSystems IRIS for Health 0 0 0 44
Question Ashok Kumar · Jul 3 HL7 message field display in Business Rules Hello Community I'm unable to view the HL7 message field in the Business rules of the latest version of IRIS while tying HL7. syntax ex: HL7.{PID:PatientName().givenname} Latest Rule editor Old Rule editor #Business Rules #Ensemble #InterSystems IRIS for Health 0 3 0 72
Question Ashok Kumar · May 15 FHIR Profile validation Java issues Hello Community, I'm trying to execute the FHIR R4 profile validation and got the below error. How to fix this below error http://localhost:52773/csp/healthshare/learn1/fhir/r4/Patient/$validate?profile=http://examples.com/fhir/StructureDefinition/aktestpatient|4.0.1 #FHIR #InterSystems IRIS 0 3 0 68
Announcement Ashok Kumar · May 15 Documentation New Look The InterSystems documentation new look is pretty awesome. The integrated pervious release documentation are single page is really useful. Dark mode and collapse the side bar option is cool! #InterSystems IRIS 8 0 0 71
Question Ashok Kumar · May 13 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 73
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 79
Question Ashok Kumar · Apr 20 OpenAPI property mismatch in Spec First approach IRIS documentation Hello Community, #InterSystems IRIS 0 2 0 84
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 164
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 264
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 191
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 98
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 92
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 220
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 215
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 160
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 233
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 166