Search

Clear filter
Article
Benjamin De Boe · Dec 15, 2021

2021.2 SQL Feature Spotlight - Run Time Plan Choice

. When we have a regular index on both these fields, the most efficient plan for this normalized query will start with the most selective condition (CountryCode), using
Question
Stephen De Gabrielle · Jun 26, 2019

Message viewer 'Source' and 'Target' drop down menus very slow

is caused by the Bitmap indices of Ens.MessageHeader. I know I need to run the 'bitmap index clean up' routine for Ens.MessageHeader to fixed the issue. What I forget is how
Article
Alexander Koblov · May 20, 2016

Collations in Caché

================== Don’t confuse collation of array with SQL collation. The latter one is conversion applied to the string before comparison or using it as a subscript in index
Question
Bransen Smith · Oct 1, 2024

Help Understanding Global Mappings and Sharing One SQL Table Across Multiple Namespaces

Index - ^E2C8.D9IS.2 IDIndex Index - ^E2C8.D9IS.3 IDKey Index - ^E2C8.D9IS.1 Indexes - ^E2C8.D9IS.I Stream - ^E2C8.D9IS.S I am not sure what to put in as the Global Name, would
Question
Yana Rchks · Oct 30, 2019

SQL-query: Select item from table field of list of objects of another table

class is packet.Movie Class packet.Movie Extends (%Persistent, %Populate){ Property Title As %String (POPORDER = 0) [ Required ]; Index TitleIndex On Title [ Unique
Announcement
Mike Morrissey · Jun 4, 2020

June 4, 2020 – Advisory: Potential Data Integrity Issue with HealthShare FHIR Resource Searches against the FHIR Repository

This defect occurs due to an incorrect resource being deleted from the search index. Subsequent FHIR Resource requests against the FHIR Repository may return incomplete results due
Question
marco calderon · Jun 18, 2018

MessageBank Helper Class

will help you move forward.In your helper class, add code to your OnBankMsg() method to index messages: ClassMethod OnBankMsg(pHeader As Ens.Enterprise.MsgBank.MessageHeader
Announcement
Anastasia Dyubaylo · Jul 10, 2020

New Video: Reducing Readmissions with Machine Learning

will demonstrate using InterSystems IRIS for Health for notification and analytics to identify patients at high risk for readmission. Takeaway: InterSystems IRIS for Health can
Announcement
Anastasia Dyubaylo · Jun 16

[Video] It's CLEAR - Re-Imagining the Digital Front Door

with CLEAR provides exciting new capabilities for a variety of use cases, such as the patient registration and check-in process. See how to utilize CLEAR-verified digital identities
Question
Mathew Lambert · Jun 23, 2020

Best way to implement a one-to-one relationship

(Table.B).%OpenId(99)set objA.TableB=objBset objB.TableA=objAdo objA.%Save(), objB.%Save() You are free to index properties TableA or TableB according to your needsand you can also use
Question
Guillaume Rongier · Sep 23, 2022

Store Procedure Returning a ResultSet with Embedded Python

'] == 'Concept': print(e['index']) # Should return one new row in the result set Expected result : Call My_Python_Procedure(Table); Entity ----- test python interface
Article
Ashok Kumar T · Aug 31, 2023

Utilize custom datatype class for User-defined DDL table Creation

]; Parameter USEEXTENTSET = 1; /// Bitmap Extent Index auto-generated by DDL CREATE TABLE statement. Do not edit the SqlName of this index. Index DDLBEIndex [ Extent, SqlName
Announcement
Anastasia Dyubaylo · Sep 3, 2019

[September 10, 2019] Boston FHIR @ InterSystems Meetup

like to acquire patient data from Electronic Health Records (EHR) with FHIR, and use it for population health management and research.FHIR provides resources and foundations based
Question
Harshdeep Acharya · Feb 28, 2022

Duplicate Resource/Data added in FHIR Repository

If I add the same patient data with a different unique ID then it inserts as new data using a POST request.So, In the FHIR server How can I prevent this kind of thing by using
Announcement
Anastasia Dyubaylo · May 8, 2020

New Video: FHIR Update

for Medicare and Medicaid Services for API access to patient health information, adoption of the FHIR interoperability specification is likely to accelerate dramatically. FHIR itself