Search

Clear filter
Question
Pravin Barton · Apr 29

How to access a stream property in a SQL trigger

property, for easy querying and indexing. See below for a minimal example: Class PAB.DebugStream Extends %Persistent { Property Contents As %Stream.GlobalCharacter; Property
Article
Alex Kogan · Nov 15, 2020

Using explicit Foreign Key simple example

in this table is set to null. [ OnUpdate ] - OnUpdate says what to do in the class containing the foreign key when the property/properties with the referenced unique index
Article
Rizmaan Marikar · Mar 20, 2023

InterSystems Embedded Python with Pandas - Part 1

. If you want to specify column names, you can pass a list of names to the names argument. If the file contains a row index, you can use the index_col argument to specify it. It's
Question
David Jimenez Vargas · Dec 28, 2017

Better strategic. Business process with pool size = 4 or 4 business process

system that was used on many facilities. On this feed I had messages to create a patient, update it, admit it, etc. If one messages arrived on its destination before the previous
Question
Frank Langel · Mar 14, 2020

Can IRIS do parallel data querying across multiple sharded server (code to data

measurements) Thanks a lotFrank make your formula f = x + 20(y*y) > z a calculated, SQLcomputed property in your TABLEand provide it with a bitmap index and it will run distributed
Announcement
Lexi Hayden · Oct 31, 2019

New look and feel for IRIS documentation

, including the Supported Platforms document, the PDF index document, and (soon) the website landing pages. The goal is to have less code and more tests. Let us know what you think! Hi Lexi
Article
Stephen De Gabrielle · Jun 28, 2019

Speeding up Source and Target drop-downs in Message Viewer

Slowness of the 'Source' and 'Target' parameters in the (portal) Message Viewer is caused by the Bitmap indices of Ens.MessageHeader.Running the 'bitmap index clean up' routine
Question
CM Wang · Aug 18, 2017

%Dictionary.StorageSQLMapDefinition

) Alternatively you can use Open method for IDKEY index (more on auto-generated methods for indices, properties etc.): Set Obj = ##class(%Dictionary.StorageSQLMapDefinition).IDKEYOpen(Class, Storage, SQLMapName)
Question
Scott Roth · Jan 30, 2018

EnsLib_HL7.Message retaining data after purge

too.You very likely need to run an index validation against Ens.MessageHeader.NAMESPACE>Set sc = $System.OBJ.ValidateIndices("Ens.MessageHeader",,1,1)Depending on the size of your
Question
Richard Housham · Aug 20, 2018

using import in an xsd schema

files I've the data for the patient/client. Then in the xml schema which I've imported I've specified the elements. I've created a subtransform which has helped when converting
Article
Lucas Enard · Aug 17, 2022

Full Python IRIS production : DataTransformation of a CSV to a FHIR server

, PatientRequest):` and then map your request resource to a fhir.resource Patient. Now if you go into the management portal and change the setting of the `ServiceCSV` to add `filename
Article
Yuri Marx · Aug 25, 2022

Transform custom healthcare messages to SDA

for Health. The sample data we used was generated by the SYNTHEA bulk data generation project (https://synthea.mitre.org/downloads). We will convert 1000 patients from a CSV file to SDA
Article
Benjamin De Boe · Jun 7, 2016

iKnow demo apps (part 2) - Set Analysis demo

to implement relevant use cases and help users be more productive in their daily tasks. Last week's article discussed the Knowledge Portal, a straightforward tool to browse iKnow indexing
Question
MARK PONGONIS · Jul 17, 2018

Cache Dynamic SQL Pagination

prop FROM table WHERE prop=?-The second suggestion is what I am doing above. Using %VID with a subquery is just too slow when dealing with large datasets.Is there an index for "prop
Article
Iryna Mykhailova · Aug 2, 2022

Data models in InterSystems IRIS

STORAGEDEFAULT = "columnar"; Parameter USEEXTENTSET = 1; /// Bitmap Extent Index auto-generated by DDL CREATE TABLE statement. Do not edit the SqlName of this index. Index DDLBEIndex