Search

Clear filter
Question
Michael Wood · Nov 17, 2023

INSERT OR UPDATE

If the table has an IDKEY index and another UNIQUE constraint, INSERT OR UPDATE matches these columns to determine whether to perform an insert or an update.
Question
Russell Knight · Jul 17, 2017

How to Discover What's Inside the Global?

the need of creating a recursive call.You can use $qlength along with $query to discover how deep (how many subscripts) you are in the global.You can use $qsubscript along with an index
Article
Dmitry Maslennikov · Feb 4, 2016

Some more errors in Atelier

The DLTK indexing initialization error is new and has been raised as an issue for our development team Ref: Server view and copy of routines.
Announcement
Mike Morrissey · Feb 11, 2021

Advisory: Incomplete Query Results with ‘ORDER BY DESC’ – HealthShare

The query contains conditions on multiple indexed fields. The query selects data from only one table.
Question
Mike Henderson · Apr 15, 2016

SQL Parsing error

reference: Here you go - this will compile in USER namespace Class User.SQLForSome Extends %Persistent { Property Name As %String; Property Domains As list Of %String; Index
Announcement
Evgeny Shvarov · Mar 3, 2021

Technology Bonuses for Projects of the InterSystems Grand Prix!

iris-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-demo
Question
Kurt Hofman · Dec 15, 2020

Intersystems IRIS 2020.4.0.524.0 (Docker) & IRIS Studio

Access directly to the label $ docker inspect containers.intersystems.com/intersystems/iris:2020.4.0.524.0 \ --format '{{ index .Config.Labels "com.intersystems.ports.default.superserver
Question
Jonathan Stanger-Moore · Sep 25, 2017

Getting SQL Gateway Connection Details - ODBC

=1 ^%SYS("sql","ODBCCONNECTION","DATA",1)=$lb("","ENS171 Samples","YJM","_system","HnBuSSuEERERntcVPGsUMQ==",0,0,"","","","",0,"",0,0,1,0,1,0,"",0) ^%SYS("sql","ODBCCONNECTION","INDEX
Question
Stephen De Gabrielle · Jun 29, 2020

How do you identify orphaned classes?

Also, for persistent 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
Question
Goran Stefanovic · Aug 5, 2019

Creating a table in one namespace and inserting into it, but reading and updating it from another namespace

need both Package mapping and global mappings.In package mapping you add package containing your table from routine database for original namespace.In global mapping you add data, index
Question
Jack Rack · Oct 11

Can I build a decentralized ledger (DLT) inside InterSystems IRIS using deterministic globals and consensus modules?

Globals allow you to define blocks that include attributes such as block index, timestamp, transactions, hash, previous block hash, and other metadata.
Question
Smythe Smythee · Jul 13, 2022

Can you help meHow to Convert HL7 input message into JSON Object Output Message

%Set("PatientID",tPID.GetValueAt(2)) do jsonObj.%Set("PatientIdentifierList",tPID.GetValueAt(3)) do jsonObj.
Question
Pietro Di Leo · Jul 4

How to export a project XML file for deploy with Visual Studio Code?

Hi John, this is my workspace file: { "folders": [ { "path": "." }, { "name": "Site Specific - CCN-16778 - Avallo Pazienti Stranieri - fpg_dev_production:DEV", "uri
Discussion
Evgeny Shvarov · Aug 31, 2019

What do You Use For Static Array Management in ObjectScript: List vs Global vs Local vs PPG

December" { s @ad@($I(@ad))=i } } Usage: ClassMethod MonthGlobalUsage() { set ad=$na(^Month) k @ad d ..MonthGlobalSetup(ad) // get the particular value by index
Question
Pratik Mankar · Jun 24, 2022

Accessing Property within a Property

The properties are Patient name Type of Test Order ID Type of test will values for Sugar, Urine and Thyroid.