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

Intersystems IRIS 2020.4.0.524.0 (Docker) & IRIS Studio

declares available ports in the image. Access directly to the label $ docker inspect containers.intersystems.com/intersystems/iris:2020.4.0.524.0 \ --format '{{ index .Config.Labels
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
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
Question
Goran Stefanovic · Aug 5, 2019

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

you add package containing your table from routine database for original namespace.In global mapping you add data, index, stream and id globals from global database for original
Question
Marek Bernád · Jul 3, 2017

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

will probably 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
Michael Wood · Nov 17, 2023

INSERT OR UPDATE

details, see Uniqueness Checks." "When using INSERT OR UPDATE, you can only insert IDKEY column values, not update them. If the table has an IDKEY index and another UNIQUE
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
Question
Mike Kadow · Jun 15, 2017

Ways and methods of Accessing Relationships with SQL

) are indexed then a selection on a date range (say) will only select the required rows from the index.= =But as I said before - it depends on the size of the system - my clients have
Article
Dmitry Maslennikov · Aug 22, 2023

REST Api with IRIS on Python with sql migrations

import Column, Integer, String, Text from app.db import Base class Todo(Base): __tablename__ = 'todo' id = Column(Integer, primary_key=True, index=True) title
Question
Victor Castanon · Jul 9

Has anyone worked with <MAXSTRING> in Fhir R4 Binary deserialization (From Athena

Encoded Content>", "id": "XXXXXXXXXXX", "meta": { "security": [ { "code": "NOPAT", "display": "no disclosure to patient, family or caregivers without attending
Article
Timur Safin · Aug 26, 2016

Caché MapReduce - Basic interfaces for MapReduce implementation (part II

) Method GetNext() As %String { #dim value As %String #dim index As %String = $order(@i%GlobalName@(""),1,value) if index'="" { kill @i%GlobalName@(index