Search

Clear filter
Question
Stephen De Gabrielle · Jun 29, 2020

How do you identify orphaned classes

, you may be able to find whether they were recently accessed through SQL by looking into the Statement Index, but that of course only is about SQL and doesn't guarantee you
Article
Shanshan Yu · Apr 19, 2023

InterSystems IntegratedML-Height and weight prediction

the future height of children, and judge whether the child's body mass index is based on the current height and weight status. In the normal range. Key Applications: InterSystems
Announcement
Mike Morrissey · Feb 11, 2021

Advisory: Incomplete Query Results with ‘ORDER BY <row ID field> DESC’ – HealthShare

in descending (DESC) order. The field used for that sorting is the table’s row ID. The query contains conditions on multiple indexed fields. The query selects data from only
Announcement
Evgeny Shvarov · Mar 3, 2021

Technology Bonuses for Projects of the InterSystems Grand Prix

-rad-studio 4 iris-python-suite 7 fhir-chatbot 11 iris-ml-suite 10 IRIS Interoperability Message Viewer 10 isc-generate-db 10 iris-image-index
Question
Mike Henderson · Apr 15, 2016

SQL Parsing error

go - this will compile in USER namespace Class User.SQLForSome Extends %Persistent { Property Name As %String; Property Domains As list Of %String; Index Domains
Question
Marek Bernád · Jul 3, 2017

How to delete Caché global by its value in Caché ObjectScript

need to maintain a cross-reference (a.k.a. index) such as ^myglobalX("index1",Y)=X and check for the existence of a record here before saving a new record.
Question
Russell Knight · Jul 17, 2017

How to Discover What's Inside the Global

) you are in the global.You can use $qsubscript along with an index to fetch it's name.There's a sample within the $query documentation.Also, $order uses the lastest subscript you
Question
Jonathan Stanger-Moore · Sep 25, 2017

Getting SQL Gateway Connection Details - ODBC

","ODBCCONNECTION","DATA",1)=$lb("","ENS171 Samples","YJM","_system","HnBuSSuEERERntcVPGsUMQ==",0,0,"","","","",0,"",0,0,1,0,1,0,"",0) ^%SYS("sql","ODBCCONNECTION","INDEX","NameIndex
Article
Dmitry Maslennikov · Feb 4, 2016

Some more errors in Atelier

Atelier refresh (coincides with the next 2016.2 field test beta posting). The DLTK indexing initialization error is new and has been raised as an issue for our development
Article
Gevorg Arutiunian · Sep 20, 2018

Get Day of the Week from Date

, then subsequent centuries. EX (2000, 2100, 2200, 2300) Set dayList = $LISTBUILD("Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday") // Index goes from 0-6
Question
Stefan Schick · Mar 24, 2022

Howto add / remove searchtable items

] { Parameter DOCCLASS = "EnsLib.HL7.Message"; Parameter EXTENTSIZE = 4000000; /* Re-declare indices because the superclass is abstract */ Index indexValue On (PropId, PropValue
Article
Yuri Marx · Feb 25, 2021

Day 3: Developing with InterSystems Objects and SQL

to SQL commands, from terminal, execute do $system.SQL.Shell(). Persistent classes have a system generated ID, if you need ID controled by you, use IDKEY index with one or more
Question
Scott Roth · Nov 23, 2016

Text File Fixed Format

91 b/m Average Seizure Energy Index 7471.4 ?V? Postictal Suppression Index N/A Maximum Sustained Power 15787.0
Question
Eduard Lebedyuk · Feb 7, 2016

Best practices to store user information/settings in Caché

User As Security.Users; Property Settings As %String; Index UserIndex On User [ IdKey, PrimaryKey, Unique ]; /// Set settings for User equal to Settings ClassMethod
Question
Scott Roth · Apr 2

ErrException: <INVALID OREF>zOutputToIOStream+^EnsLib.HL7.Message

EMR, send it through a DTL to just update the Patient Class, and then send it onto the Operation which is TCP. We are starting to see this error message... ERROR <Ens>