Search

Clear filter
Question
Keshav Iyer · Apr 11, 2022

Is it possible to add an index to a %SerialObject property?

I want to add an index to a property of the %SerialObject class. Is this possible? Yes.
Question
Yone Moreno Jiménez · Aug 5

Validate Global Indexes and Rebuild them

%BuildIndices($LB("TimeLogged")) You can also rebuild indices using SQL from 2021 version Rebuild all indices BUILD INDEX FOR TABLE Ens_Util.Log Rebuild a specific index BUILD INDEX
Question
Ba Moser · Aug 25, 2020

How to create index inside Array

Have you try the following: Index fcIDX1 On (Invoice(ELEMENTS), Invoice(KEYS)) [ Type = index ]; Index fcIDX2 On Invoice(KEYS) [ Type = index ]; Property Invoice As list Of %String
Question
Hannah Sullivan · Dec 30, 2024

Unique Index Open on Empty String

I have a unique index on two properties in a class, and I want to open the instance by index key with one of the two properties is set to the empty string.
Question
Yuri Marx · Sep 5, 2021

Rebuild table index using ObjectScript

%BuildIndices($lb("indexName1", "indexName2")) BUILD INDEX (via SQL) %BuildIndicesXXX()
Question
Guillaume Rongier · Jun 17, 2019

iFind Index With Relationship RowID Specification

NarrSemanticIdx On (Narrative) As %iFind.Index.Basic; Index UniqueNumIdx On UniqueNum [ Type = index, Unique ]; } The problem start when I add an Relationship in my indexed class,
Question
sween · Dec 10, 2018

Multiple Claims and Removal of a Claim by Index

before it by using:Set tNumClaims = pTargetDocument.GetValueAt("loop2000A(*)")so I really don't think its the schema.Can anybody give me some advice on how I remove a single claim by index
Question
Güvenal · Nov 10, 2021

SQL Search index on JSON objects.

Indexing a JSON ObjectYou can create an iFind index for text stored in a JSON object.
Question
Evgeny Shvarov · Nov 30, 2017

Index Globals: Take Away or Rebuild?

I've rarely rebuilt indexes while moving Cache DBs.
Article
Daniel Kutac · May 3, 2017

InterSystems IRIS Open Authorization Framework (OAuth 2.0) implementation - part 3

There is a real life scenario that uses the above described logic – the FHIR standard for exchanging electronic patient records.
Question
Shashvati Dash · Jun 25

Difference between Index ZipIDX On ZipCode [ Data = (City,State) ]; and Index ZipIDX On (City,State)

Whats the significance of creating an Index with Data Keyword in Index Creating an index with the `Data` keyword specifies a list of properties whose values are stored within the index
Article
Luis Angel Pérez Ramos · Jun 2, 2023

Performance tests IRIS - PostgreSQL - MySQL

I have not included any type of index beyond those that are created automatically with the definition of primary keys in the different databases.
Question
Ahmad Bukhtiar · Nov 12, 2020

is there a command to delete patient from Edge Production

So everytime we have to generate differnet patient data or change MRNs etc.
Question
Devin Gilmore · Sep 16, 2020

Create Custom DTL to List multiple Patients

Hello Developers, I am pretty new to developing using HealthShare, I am working on a project and need to create a custom DTL that will List multiple patients.
Announcement
Anastasia Dyubaylo · Mar 6, 2019

New Video: Engaging Patients Through Communication

New video is already on InterSystems Developers YouTube Channel:Engaging Patients Through CommunicationIn this video, we will highlight new APIs within HealthShare Personal Community