Why do these clauses affect SQL performance?

select ID from some_table where row_status in ('I','U') order by ID limit 5 - makes the query infinite select top 10 ID from some_table where row_status in ('I','U') order by ID - the same select ID from some_table where row_status in ('I','U') order by ID - is fast

Actually there are no rows in the table having row_status 'I' or 'U'.

I asked Gemini and it recommended me rewrite the query as

select ID from table where row_status in ('I','U') order by ID || '' limit 5,

and this helped, but I have never encountered a similar problem with any other dat

I want to implement isc-rest in my new project iris-budget/module.xml at master · oliverwilms/iris-budget

I get this error:

#8 11.30 Building dependency graph...
#8 12.69 ERROR! Could not find satisfactory version of isc.rest in any repositories. Required by: iris-budget 0.0.1: ^2.0.0
#8 ERROR: process "/bin/sh -c iris start IRIS && \tiris session IRIS < iris.script &&     ([ $TESTS -eq 0 ] || iris session iris -U $NAMESPACE \"##class(%ZPM.PackageManager).Shell(\\\"test $MODULE -v -only\\\",1,1)\") &&     iris stop IRIS quietly" did not complete successfully: exit code: 1
 

In this article, I aim to demonstrate a couple of methods for easily adding validation to REST APIs on InterSystems IRIS Data Platform. I believe a specification-first approach is an excellent idea for API development. IRIS already has features for generating an implementation stub from a specification and publishing that specification for external developers (use it with iris-web-swagger-ui for the best results). The remaining important thing not yet implemented in the platform is the request validator. Let's fix it!

Hey Community!

We're happy to share a new video from our InterSystems Developers YouTube:

     ⏯  Optimizing Query Performance in Health Insight @ Ready 2025

I am working on a new project oliverwilms/iris-budget
based on intersystems-community/iris-fullstack-template: This template shows you how to build, test and deploy a simple full-stack application using InterSystems IRIS REST API

I do not understand why I get this error:

[INFO] ...started InterSystems IRIS instance IRIS
[INFO] Executing command /docker-entrypoint.sh iris-after-start ...
[INFO] Create namespace: USER
[ERROR] module 'iris' has no attribute 'system'
[ERROR] Command "/docker-entrypoint.sh iris-after-start " exited with status 256
[FATAL] Error executing post-startup command
[INFO] S

Hi Community!

We’re excited to announce the launch of a new, hands-on training program:

 🧑‍💻 Developing FHIR Applications Using Python 🧑‍💻

This cohort-based course takes developers from FHIR fundamentals to advanced, real-world healthcare interoperability solutions, with deeper, more practical coverage than typical industry offerings and a strong focus on production-ready skills using InterSystems technology.

Recent versions of IRIS come with Lite Terminal available from VSCode. It's a websocket server, with JSON messaging. Here's how to connect to it from Python:

import websocket
import argparse
import requests
import json


defterminal(host, port, namespace, username, password, command, secure):
    session = requests.Session()
    r = session.get(f"http{"s"if secure else""}://{host}:{port}/api/atelier/", auth=(username, password))
    cookies = session.cookies.get_dict()
    ws = websocket.WebSocket()
    ws.connect(f"ws{"s"if secure else""}://{host}:{port}/api/atelier/v8/%25SYS

We use the Caché JDBC Gateway to Oracle and SQL servers to directly invoke their stored procedures from Ensemble. Getting quick, inline data results back are typically handled within the Functions.Library class as a function to wrap the query and format the return appropriately.

But what about more elaborate stored procedures made for posting data without log-jamming a Router?  The operations to construct those data pipelines can get tedious, especially when changes are needed.  What follows is a code generator to make a new Ensemble Message class from a SQL Stored Procedure that is compatibl

Hi Community! 👋
As 2026 gets underway, we’d love to hear what you’re focusing on this year.

This discussion is a space to share your resolutions, goals, and focus areas for 2026 - technical, professional or community-related.

These don’t have to be traditional New Year’s resolutions. Think of them as intentions or priorities you’d like to work on this year.

💬 What you can share

• Skills or technologies you want to learn
• Projects you want to start or continue
• Things you want to improve at work
• Events or activities you want to take part in
• Anything you’re excited to focus on in 2026

✍️

Hi Community,

Here we have requirement to process messages min 10 sec delay. Current time it is taking my businessProcess is less than 1 sec.

To implement this requirement , I need to sleep 10 sec in business process custom code.

Could somebody help me to implement delay in BusinessProcess.

Thanks,

Prashanth

Hello everyone,

The Certification Team of InterSystems Learning Services is excited to announce the release of our new InterSystems EHR Reports Specialist exam. It is now available for purchase and scheduling in InterSystems exam catalog. This exam tests candidates’ ability to use Logi Report Designer along with TrakCare/Intellicare to design, author, and support InterSystems Reports. For a list of topics covered by the exam, please refer to the exam page. Candidates who successfully pass the exam will receive a digital certification badge that can be shared on social media accounts like LinkedIn.  If you are new to InterSystems Certification, please review our program pages that include information on taking exams, exam policies, FAQ and more.

Hey everyone,

I'm just seeking some guidance and confirmation on what I'm doing for my production health monitoring.

We utilize Grafana to have reporting/monitoring dashboards and I have made a REST API to query the health of our productions. I believe I have everything figured out except for one thing that I'm uncertain about and that is the Production Item Color indicators:

Is there an easy way of being able to figure out the status of an item with the legend above? Ideally, I'd like to have this data in my JSON response. I did toy around with the idea of doing a bunch of checks like "i

Hi, Community!

Building integrations with InterSystems products? Find out about the latest UX enhancements available in version 2025.3!

Building Integrations: A New User Experience Version 2025.3

Hi developers!

In a method I need to return a result as a dynamic object aka JSON Object. And here is my logic:

Classmethod Planets() as%DynamicObject {

 set val1="Jupiter"
 set val2="Mars"// this doesn't work! cannot compile
 return {"value1":val1, "value2":val2}

}

So I need to do the following:

Classmethod Planets() as%DynamicObject {

 set val1="Jupiter"
 set val2="Mars"
 set result={}

 set result.value1=val1

 set result.value2=val2

 return result

}

The second case works. Maybe I'm preparing the Dynamic Object in the wrong way? Can we just use variables insi

Hey everyone.

I have a web service which is receiving XML as a stream, and I'm intending to then correlate the stream into an object. Unfortunately I am hitting a road block where the sender places a large chunk of the XML within a cdata block which is then causing the correlate of %XML.Reader to not work.

The structure of my xml is along the lines of:

<abc><def>010203</def><ghi>040506</ghi><jkl><mno><pqr>070809</pqr><stu>101112</stu></mno></jkl></abc>

I have my objectscript classes built that conform to the above, a

Hello everyone. I'm currently working on how to implement a solution that makes it possible to include within the response of a BusinessOperation the "RetryCount" for each message.
For Example, we have this message that was retried twice:
This is an HL7.message going through a specific business operation, we did not create a custom one: we used the default implementation EnsLib.HL7.Operation.TCPOperation. This operation should automatically handle retries (infinetely waiting on a response). I found out each Business Operation has this property :

Can we retrieve this information AFTER the messag

@Admin GlobalMasters 

can my old account be merged with my new account?

Hi,
I need to create a bundle of synthetic data in order to populate FHIR servers (not mine).

Can I use a predefined ids, or is it possible the one of the servers will not allow using my IDs and replace them with it's automatic numbering?

Hi Community! 👋

You’ve asked for easier ways to connect with other Global Masters and we heard you!
Random Coffee Chat is an easy way for Global Masters to connect and have an informal 1:1 conversation. ☕

🗓 When: January 26 – February 15

This thread is for participants in Europe & UK time zones who’d like to connect and schedule a short coffee chat directly with each other.
 
☕ How it works

• Leave a comment in this thread to join
• Reply to someone’s comment if you’d like to connect
• Continue the conversation in Direct Messages on the Developer Community and schedule a 30-minute quick call

Hi Community,

We're pleased to invite you to the upcoming webinar in Hebrew:

👉 Debugging InterSystems IRIS & Health Connect: From VS Code Breakpoints to Interoperability Traces 👈

📅 Date & time: Feb 18th, 3:00 PM IDT

When production issues arise, speed and precision matter. This webinar is a practical, tool-driven walkthrough of debugging in InterSystems IRIS (including IRIS for Health) and Health Connect - starting with code-level debugging in VS Code and extending into platform and interoperability diagnostics. We will cover core logging as well as tracing techniques. Attendees will l

Hello Team,

I am trying to duplicate the production flow in the Ensemble 2018 but after doing all the steps (like copying same class file, adapter file, process class file) as production, still the flow is not working. The error is that it is not reaching the operation (which is supposed to store the data), it gets stuck in the processes. Additionally, I am also trying to add a logic where in OUL message if the value of code 20061 > 30mg, it should automatically send another order back to service (OML). So the flow will be, Device -> Service->Processes->Operation(DB Store)->Process(ACK and di

in C++ program with #include iris-callin.h..  The program terminateswhen it tries to execute IRISSECURESTARTA with exit code -1073741515.

const char *username="user", *password="xyz",*exename="Test_Callin";

int termflag = IRIS_PROGMODE|IRIS_TTNONE|IRIS_TTNEVER;

Note: the %Service_Callin setting is Enabled.

Hello, I am trying to get some fields from HL7 message and create a file using BPL.  The values I need are in a repeating segment (AIG).  Even in the repeating segment, I just want the iteration that has a certain field (AIG:3 populated).  With the help of documentation and community posts, I was able to create the BPL to loop through all of AIG and create the file.  But when I try to narrow the results even further (AIG:3 present), the process gets stuck.  I am not sure I am missing anything or have anything incorrectly set up.  Also, since the process gets stuck, it doesn't even seem to hit

The time has come to meet in person!

Sign up at this link: AI afterwork meetup with InterSystems

If you’re passionate about artificial intelligence and want to discover how RAG is transforming generative AI, we’ve got the perfect plan for you:

February 19 · 4:10 PM - Covarrubias The One Calle de Covarrubias, 1, Chamberí, 28010 · Madrid 

Hi Community! 👋

You’ve asked for easier ways to connect with other Global Masters and we heard you!
Random Coffee Chat is an easy way for Global Masters to connect and have an informal 1:1 conversation. ☕

🗓 When: January 26 – February 15

This thread is for participants based in Asia, Australia and New Zealand who’d like to connect and schedule a short coffee chat directly with each other.
 
☕ How it works

• Leave a comment in this thread to join
• Reply to someone’s comment if you’d like to connect
• Continue the conversation in Direct Messages and schedule a 30-minute quick call

You choos

The READY agenda is now available!

As you know, InterSystems Iberia READY 2026 was created with the goal of showing where the future of data, interoperability, and artificial intelligence is heading. A perfect opportunity to learn, connect, and help the sector grow. You’re all more than invited, just in case you didn’t know 😉 Little by little, we’re revealing more about an event that will be a turning point for us. We’ll keep you posted. For now, the agenda is ready—what do you think? We believe it’s going to be a very engaging session.

📆 February 19, 2026
📍 Location: Madrid, Covarrubias

Welcome to the monthly recap of updates and releases to VS Code and InterSystems-related extensions relevant to IRIS developers. We'll break down the updates that are relevant to InterSystems developers with tips on how they can be applied to your day-to-day projects. 

Don’t forget, if you’re migrating from InterSystems Studio to VS Code, or want to deepen your knowledge, check out the VS Code training courses from George James Software: georgejames.com/vscode-training.
VS Code version 1.109

• Editor stability and navigation improvements - folding, syntax highlighting and navigation are now m

I am developing a C++ based program to access the IRIS database using iris-callin.h

I need to know what dll/dlls to use for the Iris object module?

Hey Community!

We're happy to share a new video from our InterSystems Developers YouTube:

     ⏯ Develop the Next Generation of Health IT with InterSystems@ Ready 2025

IRIS can use a KMS (Key Managment Service) as of release 2023.3.  Intersystems documentation is a good resource on KMS implementation but does not go into details of the KMS set up on the system, nor provide an easily followable example of how one might set this up for basic testing.

The purpose of this article is to supplement the docs with a brief explanation of KMS, an example of its use in IRIS, and notes for setup of a testing system on AWS EC2 RedHat Linux system using the AWS KMS.  It is assumed in this document that the reader/implementor already has access/knowledge to set up an AWS EC2 Linux system running IRIS (2023.3 or later), and that they have proper authority to access the AWS KMS and AWS IAM (for creating roles and polices), or that they will be able to get this access either on their own or via their organizations Security contact in charge of their AWS access.