Clear filter
Question
Michael Wood · Nov 17, 2023
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
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
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
The query contains conditions on multiple indexed fields.
The query selects data from only one table.
Question
Mike Henderson · Apr 15, 2016
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
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
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
=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
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
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
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
%Set("PatientID",tPID.GetValueAt(2))
do jsonObj.%Set("PatientIdentifierList",tPID.GetValueAt(3))
do jsonObj.
Question
Pietro Di Leo · Jul 4
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
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
The properties are
Patient name
Type of Test
Order ID
Type of test will values for Sugar, Urine and Thyroid.