InterSystems Developer Community is a community of 25,984 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

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

0 14
0 118

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:

0 1
0 15

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

3 0
0 10

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 h

0 2
0 36
Hello and welcome to the InterSystems Ideas Portal Annual Recap 2025.
General Stats:
✓ 182 new ideas in 2025
✓ 44 new implementations in 2025
✓ 174 new comments in 2025
✓ 725 new votes in 2025
✓ 232 new users in 2025
✓ 713 ideas all time
✓ 132 implemented ideas all time
✓ 991 comments all time
✓ 3,426 votes all time
✓ 1,207 users all time

2 1
1 20

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

https://www.youtube.com/embed/K47GEnabO-k
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
0 10

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.

6 2
1 367

Hi,

I want to consume an API that provides HL7 messages. To achieve this, I have thought of the following workflow:

I have created a business service that periodically triggers a business process. The trigger request is forwarded to a business operation. There, a %Net.HttpRequest is assembled from scratch and then sent to the API endpoint. The corresponding HttpResponse then contains several HL7 messages encoded in UTF-8 in the message body. To further process the HL7 messages, the operation sends the HttpResponse back to the business process as EnsLib.HTTP.GenericMessage.

0 3
0 50

The 2025.1.3 maintenance releases of InterSystems IRIS® data platform, InterSystems IRIS® for HealthTM, and HealthShare® Health Connect are now Generally Available (GA). These releases include the fixes for a number of recently issued alerts and advisories, including the following:

1 0
0 41
Hello and welcome to the January 2026 Developer Community YouTube Recap.
InterSystems Ready 2025
By Elijah Cotterrell
By Daniel Franco
By Antonin Hlavinka
By Elijah Cotterrell, Kevin Kindschuh, Matías Fernández, Bernardo Linarez, Satchi Mouniswamy, Nikesh Kotecha
By Keren Skubach
By James MacKeith, Mark Bolinsky
1 0
1 13

I have always struggled with Iterating through a JSON response to pull out certain fields into a Data Class Structure to use to populate fields in a DTL. So I defined the whole structure for the following JSON, with the base structure extending Ens.Response, %XML.Adaptor, and %JSON.Adaptor.

0 5
0 48

Hey Community!

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

⏯ Vector Search Performance @ Ready 2025

https://www.youtube.com/embed/ZcrsyBvKFsw
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
0 23

Hi Community,

We’re excited to invite you to take part in shaping the next generation of ObjectScript development tools. We’re working on an AI-powered ObjectScript coding assistant designed specifically for IRIS developers. Not a generic AI adapted for ObjectScript, but a solution built from the ground up to understand ObjectScript idioms, IRIS APIs, interoperability productions, and real-world developer workflows.

To make sure we build something truly useful, we need your input.

👉 ObjectScript Coder Agent Developer Survey 👈

15 17
2 300

The third developer previews of InterSystems IRIS® data platform, InterSystems IRIS® for Health, and HealthShare® Health Connect 2026.1 have been posted to the WRC developer preview site. Containers can be found on our

1 4
0 91