Search

Clear filter
Question
Stella Ticker · May 26, 2021

SQL Data Import Wizard with into table with %Library.TimeStamp and %Boolean datatype columns

No Defer Index Building with %SortBegin/%SortEnd: No
Question
Jeffrey Drumm · Jun 1, 2021

Storing a %DynamicObject

I've been tasked with an interface that needs to supply some additional metadata for the indexing of HL7v2 messages.
Question
Pedro Lopes · Feb 3, 2023

List properties

An example: SELECT Name FROM %Dictionary.PropertyDefinition WHERE parent = "mypackage.MyClassName" The field parent is fully qualified name of the class that you want to list properties
Question
Yone Moreno · Nov 24, 2023

Utilizing Intersystems HealthShare API Monitor Metrics in Kibana: Seeking Guidance on Retrieval, Processing, and Visualization

Via the Kibana web interface and to set up an index where we could search and visualize the metrics.
Question
David Hickman · Dec 12, 2023

JSONImporting an array without a key

Yellow Caution : For dynamic array, first element is indexed by 0, not 1 like ObjectScript standard arrays I wasn't exactly clear with my problem.
Announcement
Anastasia Dyubaylo · Apr 7, 2022

InterSystems Global Contest Bonuses Results

Here are the projects that scored it: Project Data-model implementation Functional index implementation Data Move usage Embedded Python Docker
Question
tom whalen · Jun 29, 2022

Measuring Global References ````

Usually, the more efficient the query is and there are "correct" indexes, the smaller the GREF and, accordingly, the shorter the execution time.
Question
Jack Rack · Oct 11

How do I trace IRIS internal locking behavior for debugging deadlocks in object transactions?

ObjectScript | InterSystems IRIS Data Platform 2025.12.Locking and Concurrency Control | Using ObjectScript | InterSystems IRIS Data Platform 2025.13.Locks (Tools/APIs) | InterSystems API Index
Article
Thomas Dyar · Mar 25

Workaround for scikit-learn 1.6.0 Incompatibility in IRIS 2024.3 AutoML

install automl: pip install --index-url https://registry.intersystems.com/pypi/simple \ --no-cache-dir \ --target /path/to/iris/python \ -r /path/to/requirementsSnapshot.txt
Article
Eduard Lebedyuk · Aug 9, 2016

Tips & Tricks - Process-private Globals as a class storage

ignoring duplicates)check if an element exists in the poolHere's the class: /// Stores unique identifiers Class Utils.Pool Extends %Persistent { Property Value As %String; Index
Question
david clifte · Oct 5, 2016

How to connect to JDBC database using SQL Gateway?

KEY=BGJD_gateway [2] https://community.intersystems.com/product-documentation/intersystems-programming-tools-index%C2%A0%C2%A0%E2%96%B6%C2%A0%C2%A0sql-gateway-connections [3] http
Question
Lewis Greitzer · Aug 29, 2017

ad hoc sql service

If you have a flag on your database that you set after reading the records, and this flag has an Index, you should be fine. Why bother?
Question
John Bland · Jul 24, 2019

Using Relationships

Hi John,Can you show me your class definitions, because when i execute the second SQL on my classes and some random data, it will show the results i expect :(maybe you need to re-index
Article
Shintaro Kaminaka · Mar 4, 2021

Building an FHIR Repository + OAuth2 Authorization Server/Resource Server Configuration on IRIS for Health Part 2

I use this to get FHIRResource (https://[HostName]/csp/healthshare/fhirserver/fhir/r4/Patient?access_token= ) like this but I get 401 error
Question
Oliver Wilms · Jul 9, 2022

ERROR #5540: SQLCODE: -99 Message: User UnknownUser is not privileged for the operation

%Prepare(pQuery) ClassMethod PostSQL(pQuery As %String = "", pIndex As %String = -1) As %Status{ Do ..DebugTEST("Riches.REST - PostSQL") Do ..DebugTEST("pQuery = "_pQuery)