Learning
Documentation
Community
Open Exchange
Ideas Portal
Global Masters
Certification
Partner Directory
Startup Hub
Developer Community
Ask DC AI
Posts
InterSystems Official
Articles
Questions
Announcements
Discussions
Tags
Events
Tech Article Contest
Programming Contest
InterSystems Ideas Contest
Event Calendar
Products
InterSystems IRIS
InterSystems IRIS for Health
HealthShare
TrakCare
Caché
Ensemble
InterSystems Analytics (DeepSee)
InterSystems Text Analytics (iKnow)
Jobs
Job Opportunity
Job Wanted
Members
About
About Us
FAQ
Feedback
Report an Issue
Share an Idea
Code of Conduct
Contact Us
EN
Ask AI
Language
EN
|
ES
PT
JP
CN
FR
EN
Search
All
Top posts
Latest posts
Tags
Type of post
Announcement
Article
Question
Discussion
Search by user posts
Tags
Caché
Developer Community Official
Documentation
Ensemble
Global Masters
Health Connect
HealthShare
InterSystems Data Studio
InterSystems Ideas Portal
InterSystems IntelliCare
InterSystems IRIS
InterSystems IRIS BI (DeepSee)
InterSystems IRIS for Health
InterSystems Kubernetes Operator (IKO)
InterSystems Natural Language Processing (NLP, iKnow)
InterSystems Official
InterSystems Reports (Logi)
IRIS contest
Job Opportunity
Job Wanted
Learning Portal
Open Exchange
Other
Partner Directory
Resource Library
Summit
Supply Chain Orchestrator
TrakCare
.NET
Access control
Adaptive Analytics
Alerts
Analytics
Analyzer
Angular
Angular2
API
Apple macOS
Application Server
Artificial Intelligence (AI)
Authentication
AWS
Azure
Backup
Beginner
Best Practices
Big Data
Business Operation
Business Process (BPL)
Business Rules
Business Service
C++
Callout
CaretDev
CCR
Certification
Change Management
ChatGPT
Cloud
Code Golf
Code Snippet
Coding Guidelines
Columnar Storage
Compatibility
Compiler
Containerization
Contest
Continuous Delivery
Continuous Integration
Convergent Analytics
CSP
CSS
CSV
Cubes
Dashboards
Databases
Database Transaction Processing
Data Import and Export
Data Model
DC Feedback
Debugging
Deployment
Developer Community FAQ
Development Environment
DevOps
Digest
Distributed Data Management
Docker
Document Data Model (NoSQL)
DTL
Early Access Program (EAP)
Eclipse
ECP
Embedded Git
Embedded Python
Encryption
Enterprise Message Bank
Error Handling
Events
Failover
FHIR
Field Tests
Framework
Frontend
FTP
Generative AI (GenAI)
George James Software
Git
GitHub
Globals
Global Summit 2016
Global Summit 2017
Global Summit 2018
Global Summit 2019
Global Summit 2022
Global Summit 2023
Global Summit 2024
Google Cloud Platform (GCP)
Graph
High Availability
HL7
HTML
iFind
Indexing
Innovatium
IntegratedML
integration-required
Interoperability
InterSystems API Manager (IAM)
InterSystems Business Solutions and Architectures
InterSystems Demo Games
InterSystems Package Manager (IPM)
IoT
isNewTech
ITvisors
J2 Interactive
Java
JavaScript
JDBC
Journaling
JSON
Key Question
Key Value
Kubernetes
Languages
Large Language Model (LLM)
LDAP
LEAD North, LLC
Listings
Localization
Machine Learning (ML)
Management Portal
Mapping
MDX
Meetup
Message Search
Microservices
Microsoft Windows
Microsoft Windows Server
Mirroring
Monitoring
Multi-model
MultiValue Basic
Namespace
Natural Language Processing
Node.js
OAuth2
Object Data Model
ObjectScript
ODBC
Open Source
OpenVMS
Perforce
Performance
PID^TOO||
Platforms
Podcast
Prompt Engineering
Python
React
READY 2025
Red Hat Enterprise Linux (RHEL)
Relational Tables
Release
REST API
Security
Sharding
SOAP
Source Control
SQL
SSL
Startup
Studio
SVN
Swagger
System Administration
System Alerting and Monitoring (SAM)
Terminal
Testing
Tips & Tricks
Tools
Tutorial
Ubuntu
UI Development
UIMA
Unstructured Data
Vector Search
Video
Virtual Summit 2020
Virtual Summit 2021
Visualization
VSCode
Vue.js
Web Gateway
Webinar
XML
ZEN
Apply
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)
first
previous
…
99
100
101
102
103
…
next
last
Log in or sign up
Log in or create a new account to continue
Log in
Sign up
Log in or sign up
Log in or create a new account to continue
Log in
Sign up
Log in or sign up
Log in or create a new account to continue
Log in
Sign up
Log in or sign up
Log in or create a new account to continue
Log in
Sign up