Search

Clear filter
Announcement
Mike Morrissey · Mar 23, 2020

March 23, 2020 – Multiple HealthShare Advisories

: Patient data is missing in the HSAA.PatientNumber table Advisory: The UpdatePlan for all cubes and cube groups is set to be Manual instead of BuildSynch Advisory: Slow DELETE
Article
Ash Sherzhanov · Jul 31

Avoiding SQL Injection in InterSystems IRIS: The Case for Secure Query Practices

a vulnerability if user input is not handled correctly. For example: Set query = "SELECT Name, Age FROM Patients WHERE Age > "_age Set statement = ##class(%SQL.Statement).%New
Question
Derek Day · Dec 15, 2015

SELECTING distinct keys from a collection

Is there a way to select distinct keys from an field that has a collection index? I have a field defined as follows: Property data As %Library.String(COLLATION = "EXACT", MAXLEN
Question
Ponnumani Gurusamy · Jun 1, 2017

Cache With FHIR

identifies a resource (a patient, a diagnosis, etc., etc.), the URL /fhir/patient/123, for instance refers to the patient with an ID of 123. The HTTP Verb used indicates what you
Article
Maria Muzychuk · Dec 3, 2022

Continuous glucose monitoring in Gestational Diabetes, by using FHIR Cloud Server and IRIS for Health

with preexisting diabetes, who would benefit from maintaining near-normal glycemia before conception. All DIP patients would benefit from earlier referral to the diabetes service. Emphasis
Question
Robert Cemper · Jun 10, 2018

Multi Language Sort

As %String;/// RomanianProperty DescRO As %String;/// SlovenianProperty DescSI As %String;Index Idx On ArtNr [ IdKey ];Index IdxDE On DescDE;Index IdxHU On DescHU;Index IdxDE On DescEN
Article
Jeff Morgan · Aug 6, 2024

Example of Overriding SDA to FHIR Transform Process to Include "RequestMethod" Setting

applicable Patient and Encounter /// references. /// @API.Method /// @Argument stream %Stream representation of an SDA object or Container /// @Argument SDAClassname Classname
Question
Arto Alatalo · Apr 12, 2018

How to resume inner $order loop from given point

=maxlog s oldroot=$name(@gl,4) ; we care only about first 4 indexes s gl=$query(@gl) ; take next global s root=$name(@gl,4) continue:oldroot=root ; skip all sub-globals
Announcement
Raul Rodriguez · Jul 7, 2023

Remote Job Oportinity - IRIS for Health

Remote Job Oportunity - IRIS For Health Job description RARUS HEALTH help patients and their families to improve dignosis and treatment of rare diseases. We are developing a web
Question
Arto Alatalo · Jan 30, 2020

Query Plan uses temp-file, why

which should be avoided, right? select * from Test.Log where cdate = 1 select * from Test.Log where cdate > 1 Plan for 1: Read index map Test.Log.cdateIndex, using the given
Question
Mark Runyan · Jul 6, 2021

Cache numeric comparison via ODBC something is not working

portal -- it will tell you which indices it uses and how it builds a result. Excellent suggestions Sergei. Yes I believe the index does need to be rebuilt! But I'll have to ask my
Article
sween · Sep 19, 2024

eBPF - Cilium on FHIR® - A Star Wars Story

": [ "Darth" ] } ], "gender": "male", "id": "DarthVader", "birthDate": "1977-05-25", "resourceType": "Patient" } EOF curl -v -X PUT \ -H "Content-Type
Question
Michael Wood · Jun 14, 2024

Create a unique constraint on an existing table

? Also, I would lke to know how to add it in the table class. The following SQL should do it CREATE UNIQUE INDEX ON TABLE <table> (field1, field2) You will then want to stop all operations against the data and build the index
Article
Alberto Fuentes · Feb 19, 2016

Object Generators: a homemade RuleEngine

, compile the rule and generate the code to evaluate that rule in run-time Run the example The example provides a patient alerts rule.After compiling the classes of the project
Question
Dmitrii Baranov · Dec 12, 2024

%ExistsId and %OpenId methods for linked tables in FHIR Facade do not work

My IRIS instance is connected to a Postgres database using SQL Gateway and linked tables. One of these tables is projected to the Patient class. I want to select a record from