Search

Clear filter
Article
Pietro Di Leo · Dec 9

IRIS IO Utility: A Complete Guide to Smart Importing in VS Code

Available types are: INDEX BITSLICE BITMAP COLUMNAR (IRIS Analytics) You can edit the index name — if left empty, the extension auto-generates one You can specify if index
Announcement
Pete Greskoff · Jun 4, 2020

June 4, 2020 – Alert: Data Integrity Issues with the FHIR Resource Repository

The defect manifests because a FHIR update interaction deletes an incorrect resource from the search index.
Question
Denham Pole · Feb 22, 2023

Using UUID as primary key

You can use whatever you want, just remember about some caveats, like issue with bitslice/bitmap indexes, which requires numerical ID I would recommend using just a Unique Index for
Article
Robert Cemper · Feb 16, 2018

Adopted Bitmap

So a wrapper class Bmap.PersonQ around the data eliminates the top level ofthe index (Country) and isolates the PersonalId (%Integer, MINVAL=1).We are ready to use a Bitmap index.
Question
Guillaume Lepretre · Dec 4, 2019

[Ensemble] Req table with big data

Regards, You need to index columns used in conditions, for the specified query: etatTitre numRemise If there are less than 6400 possible values you can use bitmap indices.
Question
Eduard Lebedyuk · May 23, 2017

How to get the time of Business Service start

There is a bitmap index on both Type and ConfigName so this should be blazing fast too!
Question
Steven Henry Suhendra · Aug 4, 2023

Calling Second Method inside the Main Method

,PAPMIRowID,PAPMINAME2,PAPMINAME,Age,Address,SphereJauh) } &sql(close adm) // Build QHandle (AtEnd,ReportID,Index) set QHandle=$listbuild(0,repid,0) set QHandle(1)=mon quit $$$
Question
reinhard lebensorger · Sep 5, 2019

CACHE SQL: Is the order of the WHERE conditions relevant

Usually, I follow the order of indexes or column selectivity (this is a general rule in all databases). For large tables or complex queries, this can influence.
Question
Jack Abdo · Jan 15, 2016

Using iKnow domain configuration from iFind

Hi Jack, you can enable stemming by setting the INDEXOPTION index parameter to 1 (or by leveraging the more flexible TRANSFORMATIONSPEC index parameter if you are on 2016.1).
Question
Ephraim Malane · Jul 25, 2023

Working with Allergy FHIR Resource

Tolerates canned fish" }, "patient": { "reference": "Patient/example" }, "recordedDate": "2015-08-06T15:37:31-06:00", "recorder": { "reference": "Practitioner/example
Article
Fan Ji · Nov 20

Questionnaire Made Easy – with IRIS, FHIR SQL Builder, and Vector Search

When a user asks, “Which patients have a family history of heart disease and take cholesterol-lowering medication?”
Question
Scott Roth · Jul 25, 2023

REST API Request Logging

executing the command: NO-PATIENT-FOUND details: No patient was found with the provided ID and ID type..","ExceptionType":"System.Web.HttpException","StackTrace":null} I would like
Question
Steve Pisani · Aug 31, 2017

iKnow Disk space requirements

If iFind, then what index?
Question
WHAT THE · May 20, 2019

Something similar to hibernate/criteria on InterSystems Cache?

, the method name is always "[index-name]Open".
Article
Lydia Huang · Mar 14, 2016

Execute an MDX query in the DeepSee Shell with/without results cache

[Age Bucket].Members),2000) ON 1 FROM [PATIENTS] %FILTER [GenD].[H1].[Gender].