InterSystems Developer Community is a community of 26,091 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more
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

4 2
1 42

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 15
0 149

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!

Open Exchange app
2 0
0 40

Hey Community!

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

⏯ Optimizing Query Performance in Health Insight @ Ready 2025

https://www.youtube.com/embed/s9CIi1HQ_iQ
[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]

1 0
0 21

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.

4 1
1 48

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.

2 0
0 27

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 3
0 47

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

https://www.youtube.com/embed/oDFS0k38_ik?utm_source=youtube&utm_medium=social&utm_campaign=oDFS0k38_ik
[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]

1 0
0 29

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

4 0
0 35

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 45

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 32

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 57

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 68