Hi Community,
How Can I do to return ID when I call %JSONExport()?
Hi Community,
How Can I do to return ID when I call %JSONExport()?
Prefer not to read? Check out the demo video I created:
I've conducted some tests using different InterSystems IRIS Community Edition container images, which I pulled from https://containers.intersystems.com.
During this process, I noticed some inconsistencies that I’d like to clarify:
latest-preview pulls: InterSystems IRIS Version 2025.1.0.204latest-cd pulls: InterSystems IRIS Version 2024.3.0.2172025.1 pulls: InterSystems IRIS Version 2025.1.0.223This behavior was a bit confusing to me, especially since latest-preview does not point to the most recent 2025.1 build.
Could someone please confirm if this is the
Hey Community,
Great news for all those of you who have missed the Super Early Bird discount for the InterSystems READY 2025! You still have a chance to get an Early bird discount up until 26th of May! So don't miss you chance to participate in the event of the year.
🗓 Dates: June 22-25, 2025
📍 Location: Signia Hilton Bonnet Creek, Orlando, FL, USA

The 2024.1.4 and 2023.1.6 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 the following alert recently issued - Alert: SQL Queries Returning Wrong Results | InterSystems. Please share your feedback through the Developer Community so we can build a better product together.
You can find the detailed change lists & upgrade checklists on these pages:
I need a DTL to handle this.
Any ideas appreciated.
For all Prosthetics orders:
when ORC-1(Order Control) is "NW" (New Order), need to update OBR-18(Placer Field 1) based on PV1-2 (Patient Class) value.
assumption is that the selection logic is that all prosthetics orders with OBR-18 field is always blank.
Description :
If PV1-2 is I, insert I in OBR-18
If PV1-2 is O, insert O in OBR-18
If PV1-2 is E, insert O in OBR-18
If PV1-2 is P, insert O in OBR-18
If PV1-2 is R, insert O in OBR-18
If PV1-2 is B, insert O in OBR-18
I was wondering if someone could help me. In the past I have been able to call external Stored Procedures through a SQL Outbound Connection and have them return me the EnsLib.SQL.Snapshot to use within a BPL to extract data.
But this time instead of using a SQL Outbound BO to make the Stored Procedure call, I decided to create a Linked Stored Procedure through the %JDBC_Server to point to the Stored Procedure out on MS SQL.
However, I am struggling to get the code just right to return the Column value from the Linked Stored Procedure.
set result = ##class(EnsLib.SQL.Snapshot).%New()
set resultNew at DTL. I need some pointers on this DTL
For all Prosthetics orders:
when ORC-1(Order Control) is "NW" (New Order), need to update OBR-18(Placer Field 1) based on PV1-2 (Patient Class) value.
assumption is that the selection logic is that all prosthetics orders with OBR-18 field is always blank.
Description :
If PV1-2 is I, insert I in OBR-18
If PV1-2 is O, insert O in OBR-18
If PV1-2 is E, insert O in OBR-18
If PV1-2 is P, insert O in OBR-18
If PV1-2 is R, insert O in OBR-18
If PV1-2 is B, insert O in OBR-18
Hi Community,
We’re excited to introduce the AskMe assistant—try it out for yourself!

The InterSystems IRIS is a great data platform and it is met the current features required by the market. In this article, you see the top 10:
Note: this list was updated because many features are added to IRIS in last 3 years (thanks @Kristina Lauer)
| Rank | Feature | Why | Learning more about it |
| 1 | Democratized analytics | InterSystems IRIS Adaptive Analytics: Delivers virtual cubes with centralized business semantics, abstracted from technical details and modeling, to allow business users to easily and quickly create their analyses in Excel or their preferred analytics product |
Hi guys,
Would like to replace our scheduled Tasks to instead run in a production, so basically the same code running in OnTask () to be instead called in a Business Service (I guess) and use the Interval filed to specify the iteration, so with adapter would be suitable in this case, and I noticed the Schedule filed as well but not sure how to use it?
.png)
Thanks
Hi - I'm refreshing my IRIS instance, now upgraded to 2025.1, and ensuring IPM is installed in each namespace, as well as git-source-control, but in my first attempt I get this error.
Everything else seems to work - but why the error (I'd like to get rid of it) ?
[git-source-control] Module object refreshed.
I read the article by @Rodolfo Pscheidt Jr:
https://community.intersystems.com/post/ollama-ai-iris
I forked his app and copied selected files from @Guillaume Rongier iris-rag-demo to make it containerized:
ollama-ai-iris/test_conn.py at 3da62770a90e34eff92241abbfc4f2c2a7027898 · oliverwilms/ollama-ai-iris
I struggle to understand what each element is or I do not understand why the code does not work:
url = f"iris://teste:teste@localhost:51774/TESTE"
Is teste:teste refer to username / password? I tried _SYSTEM:SYS
Is 51774 webserver port? Is TESTE namespace?
I tried both webserver and superserver
i have a line in my *.scr file like this:
send: s rlt=##class(%SYS.Namespace).ListAll(.rlt)<CR>
wait for:USER>
send: S A="" F S A=$O(rlt(A)) q:A="" I A["USER"!(A["CLIE") F I=1:1:$L(L,",") S G="^["""_A_"""]"_$P(L,",",I) S B="" F S B=$O(@G@(B)) Q:B="" F J=1:1:$L(B) S V=$A($E(B,J,J)) I (V<48!(V>57))&&(V<65!(V>90))&&(V<97!(V>122)) W A,?10,G,?30,B,!<CR>
wait for:USER>
it errors out with this <SYNTAX> error where the "<" or ">" are not accepted.
I (V057))&&(VA90))&&(Va122)) W A,?10,G,?30,B,!
How do I escape these characters so that my script works??
Thanks
I read the article by @Rodolfo Pscheidt:
https://community.intersystems.com/post/ollama-ai-iris
I forked his app and copied selected files from @Guillaume Rongier iris-rag-demo to make it containerized:
I ran load_data.py and I got this output:
irisowner@e10968e4da42:/irisdev/app$ python3 load_data.py
Document ID: cbfa2f20-6627-407b-bbad-31722d18ca13
modules.json: 100%|█████████████████████████████████████████████████████████████| 349/349 [00:00<00:00, 778kB/s]
config_sentence_transformers.json: 100%|████████████████████████████████████████| 123/123 [00:00<00:00, 447kB/s]
RE
Hi all,
I can't find the list of business host setting sections and (crucially) how to refer to them in the SETTINGS parameter, as marked in purple here:
Parameter SETTINGS = "MySetting:Basic";
Does anyone know where this list lives?
Otto
After upgrading from 2024 to 2025 Im not able to compile any class.
I was using ZPM and git-source-control.
Now Im getting
Compilation started on 04/19/202520:53:00 with qualifiers 'cuk /checkuptodate=expandedonly'
ERROR #5002: ObjectScript error: <CLASS DOES NOT EXIST>OnAfterSave+4^SourceControl.Git.Extension.1 *SourceControl.Git.Utils
Detected 1 errors during compilation in 0.209s. class '%Studio.SourceControl.Interface', method 'OnBeforeTimestamp': <CLASS DOES NOT EXIST> 150 I disabled SourceControl in Management portal and nothing happen.
I cloned iris-rag-demo from Open Exchange and issued docker-compose up -d. I went to the front end and type in the chat message:
Who was the 46th President of United States of America?
I got a run time error:
RuntimeError: ERROR <Ens>ErrBPTerminated: Terminating BP ChatProcess # due to error: ERROR #5002: ObjectScript error: <PYTHON EXCEPTION> *<class 'RuntimeError'>: <PYTHON EXCEPTION> <class 'ValueError' > ERROR #5002: ObjectScript error: <PYTHON EXCEPTION> *<class 'RuntimeError'
Traceback:
File "/irisdev/app/src/python/rag/app.py", line 28, in process_input agent_text =
I cloned @Yuri Marx's langchain-iris-tool repo and typed docker-compose up -d. I see error message:
Error response from daemon: could not select device driver "nvidia" with capabilities: [[gpu]]
I added extra OBX segments and I need to renumber OBX 4 so they are sequential.
.png)
Hey Community,
Enjoy the new video on InterSystems Developers YouTube:
For my hundredth article on the Developer Community, I wanted to present something practical, so here's a comprehensive implementation of the GPG Interoperability Adapter for InterSystems IRIS.
Every so often, I would encounter a request for some GPG support, so I had several code samples written for a while, and I thought to combine all of them and add missing GPG functionality for a fairly complete coverage. That said, this Business Operation primarily covers data actions, skipping management actions such as key generation, export, and retrieval as they are usually one-off and performed manually anyways. However, this implementation does support key imports for obvious reasons. Well, let's get into it.
Hello Developers,
I have MacBook Pro M3 and I'm new to the IRIS for Health setup / installation with all pre-requisite / requirements so someone could please help me with detailed instructions on how to setup IRIS for Health (HL7 & FHIR) from scratch along with SQL Server? I have Windows 11 installed in parallel desktop if that's required and complete installation / setup is not possible on MacBook.
Thank you in advance.
Rushi
InterSystems IRIS 2025.2.0 introduces several features to improve the user experience of configuring OAuth2.
- OAuth2 is now a native authentication type and can be easily enabled for your services and web applications. Previously, OAuth2 was a type of delegated authentication.
- You can now create resource servers with the new OAuth2.ResourceServer class, which simplifies resource server configuration significantly. Previously, resource servers were instances of OAuth2.Client.
- The OAuth2.ResourceServer class and provides a sample authenticator for determining user permissions which, for
Hi, Community!
Looking to get actionable insights from your healthcare research? See how InterSystems OMOP can help:
Hey Community,
We're excited to invite you to the next InterSystems UKI Tech Talk webinar:
⏱ Date & Time: Thursday, April 24, 2025 14.30-15.30 UK
👨🏫 Speaker: @Kinshuk Rakshith, Sales Engineer, InterSystems

Looking to download IRIS for health 2024.1 software
Dear Community,
I need to collect a file from an FTP server over FTPS.
I have the :
When I run the business service to connect it connects, but soon after connecting it fails to open the directory:
| Type | Time | Text | ID |
|---|---|---|---|
| Error | 2020-06-23 14:42:06.542 | ERROR <Ens>ErrFTPListFailed: FTP: Failed List for *.txt (msg='PROT P required',code=521) | 36581958 |
| Inf |
I have written a new script for csv file export, which writes lines to a %Library.File file based on a SQL query.
The code is simplified into the following as
try {
// set up file as %Libary.Fileset f = ##class(%Library.File).%New()
set f.Name = "export.csv"if (##class(%File).Exists(f.Name)) { $$$ThrowOnError(##class(%File).Delete(f.Name)) }
$$$ThrowOnError(f.Open("WUN"))
$$$ThrowOnError(f.LineTerminatorSet($C(13,10)))
// Write lines from SQL
&sql(DECLARE cur CURSORFORSELECT a, b into :a, :b FROMtable)
&sql(OPEN cur)
&sql(FETCH cur)