Search

Clear filter
Question
Oleksandr Kyrylov · Feb 2, 2022

ALTER TABLE ALTER COLUMN RENAME Syntax

Do not edit the SqlName of this index.
Question
Arto Alatalo · Apr 12, 2018

How to resume inner $order loop from given point?

=”” 2we select the first index(c11) on the third level.
Article
Developer Community Admin · Oct 21, 2015

Solving the Problem of Exchanging Medical Information between the DoD and the VA

This evolution is especially pertinent to government healthcare due to:Mobility of patients – approximately 60% of DoD and 40% of VA healthcare is provided outside of government
Question
Dmitrii Baranov · Dec 25, 2024

FHIR facade, override FHIR Search and return OperationOutcome

") { Set patientDynamicObject = ..MethodWhichLoadsPatient() Do resultSet.AddRow(somePatientId, "Patient", somePatientId, "1", "match",,patientDynamicObject)
Announcement
Brenna Quirk · Oct 16, 2023

Try IntegratedML

This exercise shows how IntegratedML® works, and you can get practice creating a model with sample patient data. Try it out and share what you think!
Question
Robert Cemper · Jun 10, 2018

Multi Language Sort

Idx On ArtNr [ IdKey ];Index IdxDE On DescDE;Index IdxHU On DescHU;Index IdxDE On DescEN;. . .}
Announcement
Pete Greskoff · Jul 21, 2021

Alert: Incorrect Query Results with Non-Standard ‘GROUP BY’ Query

Since they cannot be resolved using only the index, they are unaffected.
Question
Alexander Brown · Feb 6, 2017

Lookup Time Complexity of a Global

Would the lookup operation scale with the size of the array such that the variable is iterated through until the given index meets the current index, yielding a O(n) lookup?
Question
Mark OReilly · Jul 3, 2023

How does the front end of the portal look up the message head ID so quickly

The idea is to use index and the fastest index in MessageHeader is %ID.
Article
Dmitry Maslennikov · Sep 18, 2023

Vectors support, well almost

Inverted file index The search just will use the created index and its algorithm will find the requested information.
Question
Jose Antonio Cañizares · Apr 1, 2016

How to extract column sorting of %ZEN.tablePane with or without snapShot

Set tSub2 = $Order(@tIndexGlobal@(tSub1,tSub2),tSortOrder) // If we previously were on the last value for the index key, move on to the next index key.
Question
Virat Sharma · Jan 24, 2023

SQL Query needs optimization

the index.,
Question
Scott Roth · Sep 2

SearchTable properties not populating

This process enables the system to index messages using your newly added properties, replacing old indexed fields.
Question
Drew Holloway · Mar 12, 2020

How to search all tables for specific column in Intersystems Cache database

indeed, system schemas (whose name starts with a % sign) require certain privileges (that you quickly get used to once you have them :-) ).