InterSystems Developer Community is a community of 25,920 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more
Article
· Mar 28, 2025 2m read
Reviews on Open Exchange - #50

If one of your packages on OEX receives a review you get notified by OEX only of YOUR own package.
The rating reflects the experience of the reviewer with the status found at the time of review.
It is kind of a snapshot and might have changed meanwhile.
Reviews by other members of the community are marked by * in the last column.

I also placed a bunch of Pull Requests on GitHub when I found a problem I could fix.
Some were accepted and merged, and some were just ignored.
So if you made a major change and expect a changed review just let me know.

5 1
0 102

Hi,
I want to automate a menu based program for which I don't have the source

If I run it interactively I do this:
do ^<program>

It presents a menu and then you can go down further menus

Based on the selection it may ask for answers to other questions.

Is there some way I give the program a "response" file?

If not would I be able to use I/O redirection for this task?
Inputs would come from a file.
Output should go to the terminal (so I monitor how far the process has gone)

1 4
0 118

Hi noble developers!

Have a question/discussion. Sometimes, while developing, we'd need to connect VSCode directly to a remote server (e.g., stage one) for debugging purposes. And after change back to local one. And then to remote again.

How do you perform this switching in VSCode in a convenient way?

I have several settings.json files (settings_local, settings_remote) which I put to a main settings.json when I need to make VSCode to connect to switch the connection:

0 8
0 113
Article
· Aug 22, 2025 26m read
Building a robot with IRIS

In this case, a robot is nothing like Gort from the movie “The Day the Earth Stood Still” or any other humanoid robot from science fiction. Nor is this Robot the one-armed automated welder from a real-world automotive assembly line. This Robot is a program that controls another program. You might want this for automated testing or to capture application logic from an application for which you don’t have the source, and the application’s author lacked the kindness or foresight to provide an API for its capabilities.

5 0
1 121
Question
· Aug 8, 2025
count() is too slow. Why?

I have a table with 5M rows, the table contains lab observation codes and display names, both columns have type varchar(2000) and both are indexed.

The query looks like:

select code_1_text, count(code_1_text)
  from demo.observation_lab
  group by code_1_text
  order by 2 desc

The table contains ~1000 distinct display names.

It takes 4 minutes for the query to complete on a VM with some pretty old Xeon, 4 cores, 32G RAM, NVME SSD and Linux on board.

0 4
0 117
Article
· Jul 23, 2025 1m read
Global-Inspector

If you are investigating complex structured Globals this can become
a rather boring typing exercise. Different from Global Explorer in
System Management Portal Global-Inspector allows a kind of drill-down
to dig deeper and deeper by subscript levels.
You also have the option to see the stored content or to show only
the subscript structures.
Globals storing SQL Tables are probably not so thrilling, but in SYSTEM
space you find real trees with completely different branches and twigs.

Open Exchange app
3 1
0 101
Job
· Jul 7, 2025
In job search

My last assignment ended in June and I am again in job search.

Seeking positions that need experience in HealthConnect, modifying Rules and DTLs.

My background is in HL7 interface development and support.

Located in the greater Boston area, open to remote or hybrid as well.

0 0
0 121

I have a segment within a Group (grp) that needs to be validated that it is populated within the message.

When you use a Foreach within a Business Rule how should you account for the counter in the group?

For example, Epic sends their MFN message in the following format.

MSH~MFI~[~{~MFE~STF~PRA~[~ZPR~]~[~ZLK~]~[~CER~]~[~ZMG~]~[~ZTF~]~[~ZGP~]~[~ZDD~]~}~]

1 1
0 120

Build 2025.1.0.1.24372U.f00326d.

Overview


This release delivers expanded Azure support for InterSystems Data Studio, enhanced subscription flexibility, major module updates, and multiple improvements to networking, security, and API responsiveness.

New Features and Enhancements

Category

Feature/Improvement

Details

Azure Support

Enhanced InterSystems Data Studio (IDFS) on Azure

4 0
1 120

Hello Team,

I got xDBC protocol is not compatible while executing python script. How to fix this error

C:\Users\ak\Desktop\lpyth\iris>C:/Users/ak/AppData/Local/Programs/Python/Python312/python.exe c:/Users/ak/Desktop/lpyth/iris/irisconn.py
An error occurred: connection failed: IRIS xDBC protocol is not compatible

py -m pip list
Package Version
------------------ ---------
intersystems-iris 3.9.2

0 2
0 118

For some build scripting with the InterSystems Package Manager, I'd like to first uninstall a package with `zpm "uninstall"` and then load it from disk using `zpm "load"`. That way anything that got deleted from the source will also be deleted from IRIS.

The problem is that `zpm "uninstall"` takes in a module name and I only have the directory path to the package source. Is there a way to get the module name for an installed IPM module given the source path? It's okay to assume that it has previously been installed from that same directory with `zpm "load"`.

0 1
0 119

InterSystems FAQ rubric

The ^%GCMP utility can be used to compare the contents of two globals.

For example, to compare ^test and ^test in the USER and SAMPLES namespaces, it would look like this:
*In the example below, 700 identical globals are created in the two namespaces, and the contents of one of them is changed to make it the detection target.

5 0
1 119

Hi, Community!

Have you thought about becoming a subject matter expert (SME) for InterSystems Certification?

The benefits are many—but you can hear directly from five members of our SME community as they discuss:

How did participating in exam development boost your own expertise?

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

3 2
1 117

#InterSystems Demo Games entry

⏯️ Text-to-SQL and MQTT Monitoring

A text-to-sql demo on mqtt data analytics with RAG.

🗣 Presenter: @Jeff Liu, Sales Engineer, InterSystems

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

11 1
0 98
Announcement
· Sep 1, 2025
[Demo Video]

#InterSystems Demo Games entry

This demo introduces an AI-powered clinical decision support tool built on InterSystems IRIS. The use case addresses clinician burnout by unlocking the wisdom trapped in 30,000 unstructured clinical notes. We showcase IRIS's powerful vector search to perform hybrid (semantic + keyword) queries for complex diagnostic challenges. The highlight is our multi-modal Retrieval-Augmented Generation (RAG) assistant, which analyzes clinical video content in real-time to find similar past cases and synthesize evidence-based recommendations, transforming how clinicians access and utilize institutional knowledge.

🗣 Presenter: @Vishal Pallerla, Sales Architect, InterSystems

7 1
0 98

Hi Community,

Let's meet at the online meetup with the winners of the InterSystems FHIR and Digital Health Interoperability Contest! It's a great opportunity to chat with the InterSystems Experts team and our contestants.

Winners' demo included!

Date & Time: Thursday, June 5, 11:30 am EDT | 5:30 pm CEST

https://www.youtube.com/embed/ne6UCGjoah8?si=JMmm1d5lF41zc-8X
[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 1
0 98

I am starting a conversion project for a health system that is currently migrating to Health Connect. They have their DEV and TST environments in one production and their PRD in another. What is the best practice for standing up conversion environments...separate name spaces in the two productions or separate productions? Keep in mind the interfaces are temporary?

Mike

0 3
0 115
Announcement
· Feb 19, 2025
[Video] AI model distillation

Hi Community!

We're happy to share the next video in the series dedicated to Gen AI on our InterSystems Developers YouTube:

⏯ AI model distillation

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