I have a number of services that call SQL stored procedures and map their result sets to Record Map Batch objects. The stored procedures take optional start and end date parameters, but default to the prior day for their daily run.

Because the database they're running against is an asynchronously updated data repository for an EHR, there are times where the stored procedures will not capture all the data that should have been there and we need to re-execute the stored proc with a specific date (and sometimes time) range.

Hello,

I am receiving the following message structure on Ensemble from a lab machine, and it is still being processed. I am using the ASTM format with the EnsLib.EDI.ASTM.Service.TCPService service. I have reviewed multiple ASTM messages and verified the schema structure. Logs are not showing any error or TCP connection is not disconnecting. I am not able to understand why am I receiving this. Please let me know if any additional details are required.

Introduction — The Problem with AI Streaming in ObjectScript

Today, I would like to introduce a problem I encountered and the solution I found when integrating AI APIs into an ObjectScript application. My initial tests were successful, yet somewhat frustrating.

The HTTP call worked; the request was properly sent to my LLM APIs. But then, silence... a long wait. Eventually, the entire response arrived as a single block.

Technically, it worked, but the user experience was disappointing compared to a ChatGPT session.

Currently have an extension of the ..lookup function as a custom version of the lookup. Is there any easy way to get it to display it as a list of the lookup tables 

ClassMethod LookupV3(table As %String = "",

and the one i'm trying with 

Hi Community!

We’re building a series of short, hands-on Instruqt tutorials to help newcomers get up to speed with InterSystems technologies faster and more effectively. To kick things off, we’ve just released a new tutorial, “Data Models of InterSystems IRIS,” covering the fundamentals of the IRIS multimodel approach. This is exactly the type of focused, concise, practical learning experience we want to expand. And this is where you come in!

We’d love to hear your ideas for other tutorial topics to help developers new to InterSystems IRIS take their first steps with confidence.

Please, provide Code example to build a %Library.DynamicObject or a %Library.DynamicArray from Resultset followed by converting to JSON

If you have long-running messages here's a simple code to catch them. You can also use Queue Wait Alert to get the same results, although this code will catch even a single active message with an empty queue. It also scans all namespaces with no production modification, so it can be used for debugging.

Include Ensemble

Class User.LongMessagesTask Extends %SYS.Task.

If you have ever dug through a large IRIS namespace looking for where a particular string, method call, or pattern was used, you know the pain: there was no built-in way to do a grep-style search across your server-side ObjectScript code from VS Code — at least not without jumping through some hoops.

That is what ObjectScript Search fixes.

Try it today with a simple install from the VS Code Marketplace. If you don't like it, uninstalling is just as easy. But I think you will like it — it is a huge quality-of-life improvement for anyone doing ObjectScript development in VS Code.

Hi everyone, 

I need to connect to an SFTP server from InterSystems IRIS 2024, but the connection must go through a proxy. 

I couldn’t find any built-in support for SFTP with proxy in IRIS/Ensemble. 

What would be the recommended approach in this case? 

is there any native or supported way to handle SFTP + proxy? 

Any examples or best practices would be appreciated. Thanks!

My team is trying to decide on the best Git strategy for a group of related but separate projects/environments.

One side prefers one repo per project/environment/namespace for cleaner separation. The other side prefers one repo with multiple project folders so shared code and releases are easier to manage in one place.

The challenge is that these projects are separate enough that boundaries matter but related enough that some utilities and common logic may need to be reused. We also want the setup to be easy for developers to understand and not become a deployment nightmare later.

Despite the fact that LOCK (docs) is a foundational part of InterSystems IRIS, responsible for concurrency, there is not a lot of discussion on the Developer Community about it. Which is understandable, considering it's stable and fairly low-level command. In this article, I will show a simple example of how to use locks with interoperability.

v2026.1 was just released as GA, and one of the features I'm looking forward to using is the DTL Explainer feature.

This allows you to take a Data Transformation, and with a click of a button get a human-readable description of the transformation (which you can also use as the basis for the DTL Description).

For complex DTLs, especially ones you didn't write yourself, or you did but a long time ago, this will allow you to get a clear quick understanding of what it's doing.

Hi, Community!

Find out about the latest UX enhancements in version 2026.1 of InterSystems products!

Building Integrations: A New User Experience (v2026.1)

In this video, Product Manager @Aya Heshmat walks you through:

• Updates to the BPL Editor, Message Viewer, and Visual Trace interfaces
• Improvements to the Production Configuration, DTL Editor, and Rule Editor

Introduction

FHIR (Fast Healthcare Interoperability Resources) is the modern standard for storing and exchanging clinical data. But once your data is in a FHIR server, how do you actually explore it? FHIR data is stored as JSON — powerful, but not practical to read directly. I wanted a tool where you could click on a patient, see their conditions, medications, lab results, and more — in a clean, readable format. So I built the FHIR Patient Viewer.

How It Works

The app runs entirely in Docker and connects directly to an InterSystems IRIS for Health FHIR server.

Working with files often starts off simple. open the file, read, and process. That approach works perfectly well, until the file happens to be an Excel file.

A Common Assumption

At first, an Excel file (.xlsx) looks like just another data file, rows, columns and values. nothing unusual. So it's natural to assume it can be read the same way as a .txt ot .csv file. But that's where things start to break.

Why Excel files behave differently

The key difference is how the data is stored:

-> .txt / .csv - plain text, line-by-line.

-> .

Hi Guys,

I've connected VS Code to my IRIS server and can see projects & web application option but not Classes tab, how can I add it, and with the old Studio we do have the Inspector tab where we can check properties, Storage, methods, are these available in VS code?

also does any changes or new classes created via VS code automatically reflected in my IRIS namespace ? 

Thanks

Hi Community,

🚀Are you joining us at READY 2026? While you're there, you can build your skills, validate your expertise, and connect directly with our experts! Take a look at these free resources from Learning Services. 👇

• Free Certification Exams: Demonstrate your InterSystems technology skills!
  • 👉Book by April 24 using the certification app after you register.
     
• Be Ready: Ask a Trainer: Meet with a technical trainer 1-1 or with your team!
  • 👉Email us to schedule a 45-minute session. Let us know your availability, and what you'd like to discuss.
    

Since our previous announcement, we have introduced several incremental improvements to the client‑side editing experience in VS Code. These updates focus on preserving developer‑authored formatting when synchronizing with the server.

What Changed

Client‑side *.cls files previously lost certain formatting details during compilation, including keyword casing (e.g., classmethod → ClassMethod), normalization of blank lines between class members, and removal of line breaks within parameter lists.

The 2023.1.7 maintenance releases of InterSystems IRIS^® data platform,InterSystems IRIS^® for Health^TM, and HealthShare^® Health Connect are now Generally Available (GA). 

Please share your feedback through the Ideas Portal using the category Post-Release Feedback so we can build a better product together.

Documentation

You can find the detailed change lists & upgrade checklists on these pages:

• InterSystems IRIS
• InterSystems IRIS for Health
• HealthShare Health Connect

Early Access Programs (EAPs)

There are many EAPs available now. Check out this page and register to those you are interested.

Hi Community,

Preparing for InterSystems Certification examsrequires more than reading documentation. It calls for focused practice aligned with real exam objectives.If you are planning to validate your expertise in HL7, SQL, System Administration, or Development, structured preparation can make a significant difference.

🧑‍🏫 Exam preparation platform

The platform offers a large pool of practice questions mapped to certification domains, along with detailed answer explanations that point back to relevant documentation.

The 2026.1 release of InterSystems IRIS® data platform, InterSystems IRIS^® for Health^TM, and HealthShare^® Health Connect is now Generally Available (GA). This is an Extended Maintenance (EM) release.

The Interoperability user interface project has continued from 2025.1 and has incorporated many of the items that you – our customers and partners – have suggested and observed.  We are continuing to invest in feedback and updating this important user experience.  In the latest release, 2026.1 for IRIS, IRIS for Health, Health Connect and Health Connect Cloud, the BPL Editor and Message Viewer/Visual Trace applications are now available for opt-in!
NOTE:

• Existing users can switch between the modernized and standard experiences.

For example in %Library.File Class Documentation,  FiieSet query is listed as: 
"Selects Name As %String, Type As %String, Size As %BigInt, DateCreated As %TimeStamp, DateModified As %TimeStamp, ItemName As %Stringof ..."

How to obtain a "real" syntax?

Thank you.

Hi Guys,

I get a Quit argument not allowed error in an if block how can I fix this?

Hi Community,

We're excited to invite you to the next Community webinar presented by George James Software, InterSystems partner:

👉 Deltanji source control 👈

🗓️ Date & Time: Thursday, April 9th, 4 pm BST | 11 am EDT

Hi Community,

We’re excited to introduce two new Global Masters milestone badges that recognize outstanding long-term contribution on the Developer Community.

These badges are part of the Global Masters program and reward members who reach major publishing and participation milestones on DC.

More badges and updates are coming soon - stay tuned 😊

	🏆 Legend Author Awarded for publishing 100 articles on the Developer Community.	100,000 points
	❓ Curiosity Legend Awarded for asking 100 questions on the Developer Community.	60,000 points

Keep publishing. Keep asking. Become a Legend. 🚀

Hi!
We are deploying the iris image in a Kubernetes environment and the cluster state is "Hung" , looking the alerts endpoint we get 2 alerts:

[
  {
     "time":"2026-03-24T13:45:44.548Z",
     "severity":"2",
     "message":"System appears to have failed over from node a69a9f137593"
  },
  {
     "time":"2026-03-24T13:46:30.274Z",
     "severity":"2",
     "message":"Error: <PROTECT>KillAlive+1^%SYS.CDIRECT in SERVERS"
  }
]
Any idea / help where those are comming from and how to address them?