Search

Clear filter
Question
Laura Cavanaugh · Jul 12, 2018

How to make an array of Objects property use index to find rows with low cost

that it's not possible to have duplicates when using an array of Objects.However, I am unable to make my queries on the array of Object use an index. Here is a code example
Question
Meenakshi Muthu · Jun 20, 2024

Could any one please tell me the purpose of "Extent Index" in more detail

In Index types, I can see "Extent Index", Please tell me in detail about it see: https://docs.intersystems.com/iris20241/csp/docbook/Doc.View.cls?KEY=RGOT_complete browser search
Question
Jenna Poindexter · Apr 15, 2018

Indexes in Cache Objects

Hi-I have the following objectsClass A Property P1 As B Property P2 As %String Property P3 As %StringClass B Property P1 As %StringCan I create an index in Class A based
Announcement
Evgeny Shvarov · Aug 10, 2017

Tag Indexing is Introduced

Hi, Community!I just have introduced new tag Indexing which relates to articles and questions on how to introduce, manage and increase performance with Indexing on Caché Objects.
Question
Alexandr Ladoshkin · Nov 23, 2017

Indexing null value

Dear community!I have problem with index NULL value. Unique index doesn't work for this case. If I use insert and one of parameter is "NULL". Message of constraint doesn't
Question
Mindy Caldwell · Apr 21, 2023

Indexing on a Multivalue file

Salesrep is the production file with only an index on the idkey (it has more properties than shown here). Property SalesRepId As %String(MVATTRIBUTE = 0, MVJUSTIFICATION = "L
Article
Lorenzo Scalese · Nov 24, 2023

Journal File Indexer

Hi community! In this article, I'm excited to introduce my latest application, Journal File Indexer. The development of this application is rooted in the portal idea DPI-I-270
Question
Keith Davis · May 31, 2019

Indices Not Working

User.Patient Extends (%Persistent, %Populate) [ SqlRowIdName = Patient, StorageStrategy = SQLStorage ] { Index AcctIndex On accountNo; Property accountNo As %String
Article
Keren Skubach · May 5

Creating a primitive extension in a FHIR resource

property value",<primitive extension index>,...) primitive extension index set as well. I could see the HS.FHIRModel.R4.Patient from 2024.1 version Thank you!
Question
Conor Browne · Nov 17, 2016

Duplicate Patients in FHIR Repository

and processed by the FromSDA DTL. The Repository Stores that data as a New patient ( i.e. when I query the Repo they have different IDs "resource":{ "resourceType":"Patient", "id":"4
Question
Carl Osborne · Apr 11, 2022

MIT Hackathon - Sample Patients

Hello, We are preparing for the MIT hackathon and noticed that when using the cloud services for FHIR, there isn't enough or any Patient data to test the FHIR APIs. Which sample
Article
sween · Apr 15, 2022

Home Based Patient Monitoring - A Fast Track FHIR Story for the MIT Grand Hack 2022

Wanted to have a FHIR Story in the back pocket to share with the participants on a dead simple series of calls against the FHIR Server for anybody in the mindset of emitting
Question
Ahmad Bukhtiar · Nov 29, 2020

create join query on the same table

Hi I have a table where i want to create join query like (select * from patients where facility=abc) qry1 left join (select * from patients where facility=xyz) qry2 on qry1
Article
Ikram Shah · Jul 4, 2023

Using AI to Simplify Clinical Documents Storage, Retrieval and Search

storage solutions for documents exist (e.g, FHIR), accessing and effectively searching for specific patient data within those documents meaningfully can be a significant challenge
Question
Jiri Svoboda · Nov 29, 2016

SQL and indexing on collection properties

I have a class which defines a property as array of %String. Is it possible to index values of this property and use this property in SQL?I have tried 'Index idx On prop(ELEMENTS