Article Robert Cemper · Aug 3, 2025 1m read

WARNING: Bug in IRIS Native API

Reviewing my published packages, I identified a nasty bug in IRIS Native API

  • There is a method in  %Net.DB.Iris named function ()
  • It's equivalent to  ObjectScript $$label^routine(param) 
  • It used to work fine 2 years ago, when I published my command-line-extension packages
  • Now it is broken since at least 1 year and throws <PROTECT>
  • I identified it for ObjecScript, Java, Python, Node.js
  • It is reported as WRC# 1002589
  • For all 4 cases, I also verified a workaround
    • Instead of calling an ObjectScript Function you call a Classmethod
    • It's by %Net.DB.Iris ClassMethodValue(...)
    • And you have
#InterSystems IRIS #Java #Node.js #ObjectScript #Python
14
0 274
Article Harshitha · Aug 3, 2025 2m read

Why It's Time for a TrakCare Techno-Functional Application Specialist Certification

Working in healthcare IT as a young developer, especially on InterSystems TrakCare, you quickly realize one thing: it’s not just about HL7 messages or backend integrations. A hugepart of making TrakCare work smoothly for hospitals comes down to how it’s configured, customized, and supported on the application side.

That’s where people like me come in—techno-functional developers who understand both the tech and how it impacts actual hospital workflows.

We’re Not Just Techies (or Functional Consultants)

Our role sits right in the middle. We're the ones:

  • Customizing modules like Pharmacy,
#Caché #InterSystems IRIS for Health #TrakCare #Ensemble #InterSystems IRIS #Certification #CSP #HL7 #JavaScript #ObjectScript
1
2 131
Question David Saunders · Aug 1, 2025

I am trying to design a home Zen screen with a title at the top and 6 buttons gathered in the center and middle of the screen arranged in 2 columns of 3 three buttons.

Here is what I currently have:

<page xmlns="http://www.intersystems.com/zen" title="">
<html id="title" height="200">Guides to Wellness: Invoices</html>
<hgroup width="100%">
<vgroup align="right" valign="middle">
<button caption="Import Client Consultation Extract" width="500px" height="200px"/>
<button caption="Manage Consultants" width="500px" height="200px"/>
<button caption="Manage Invoices" width="500px" height="200px"/>
</vgroup>
<vgroup align="left" valign="middle">
<button caption="Generate Report" width="500px" height="200px"/>
<button caption="Manage Services" width="500px" height="200px"/>
<b

#InterSystems IRIS
1
0 61
Article Henry Pereira · Jul 31, 2025 5m read

From Mud to Masterpiece: Meet dc-artisan and Craft Better Prompts

artisan cover

If you’ve ever watched a true artisan—whether a potter turning mud into a masterpiece or a luthier bringing raw wood to life as a marvelous guitar—you know that magic isn’t in the materials, but in care, craft, and process. I know this firsthand: my handmade electric guitar is a daily inspiration, but I’ll admit—creating something like that is a talent I don’t have.

Yet, in the digital world, I often see people hoping for “magic” from generative AI by typing vague, context-free prompts like “build an app.” The results are usually frustratingly shallow—no artistry, no finesse.

#Ensemble #InterSystems IRIS #Contest #Generative AI (GenAI) #Prompt Engineering #VSCode
Open Exchange
2
0 128
Article Robert Cemper · Jul 27, 2025 2m read

Reviews on Open Exchange - #54

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.

# Package Review Stars IPM
#Open Exchange
2
0 105
Announcement Vic Sun · Jul 31, 2025

[Demo Video] AI Clinical Trial Platform

#InterSystems Demo Games entry

⏯️  AI Clinical Trial Platform

The Trial AI platform leverages InterSystems cloud services including the FHIR Transformation Service and IRIS Cloud SQL to assist with clinical trial recruitment, an expensive and prevalent problem. It does this by ingesting structured and unstructured healthcare data, then uses AI to help identify eligible patients.

Presenters:
🗣 @Vic Sun, Sales Engineer, InterSystems
🗣 @Mohamed Oukani, Senior Sales Engineer, InterSystems
🗣 @Bhavya Kandimalla, Sales Engineer, InterSystems

#InterSystems IRIS #Artificial Intelligence (AI) #InterSystems Demo Games #Video
0
0 76
Article Guillaume Rongier · Jul 31, 2025 4m read

Introduction to Virtual Environments in Python

img

This article will introduce you to the concept of virtual environments in Python, which are essential for managing dependencies and isolating project from the OS.

What is a Virtual Environment?

A virtual environment is a folder that contains :

  • A specific version of Python
  • At start an empty site-packages directory

Virtual environments will help you to isolate your project from the OS Python installation and from other projects.

How to use it?

To use virtual environments, you can follow these steps:

  1. Create a virtual environment: You can create a virtual environment using the venv module that comes

#InterSystems IRIS #Backup #CSP #Framework #GitHub #Python #Terminal #Ubuntu
Open Exchange
3
2 205
Article wisitsak sangiamsak · Jul 31, 2025 1m read

Import CSV into CACHÉ

Here's a practical example of how to import data from a CSV file into InterSystems CACHÉ using ObjectScript
Assuming your CSV file is simple (e.g., comma-separated, with headers), you can use %Stream.FileCharacter to read it line by line and parse the data.
 

ClassMethod ImportCSV(filePath As %String) As %Status {
    Set stream = ##class(%Stream.FileCharacter).%New()
    Set sc = stream.LinkToFile(filePath)
    If 'sc Quit sc

    While 'stream.AtEnd {
        Set line = stream.ReadLine()
        Set fields = $ListFromString(line, ",")
        // Example: Save to a persistent class
        Set obj =

#Caché #CSV
0
0 114
Question Oliver Wilms · Apr 21, 2025

My AI use case - need help with Ollama and / or Langchain

I am brand new to using AI. I downloaded some medical visit progress notes from my Patient Portal. I extracted text from PDF files. I found a YouTube video that showed how to extract metadata using an OpenAI query / prompt such as this one:

ollama-ai-iris/data/prompts/medical_progress_notes_prompt.txt at main · oliverwilms/ollama-ai-iris
 

I combined @Rodolfo Pscheidt Jr https://github.com/RodolfoPscheidtJr/ollama-ai-iris with some files from @Guillaume Rongier https://openexchange.intersystems.com/package/iris-rag-demo.

I attempted to run

python3 query_data.py
Traceback (most recent call last):

#InterSystems IRIS #InterSystems IRIS for Health #Artificial Intelligence (AI) #Containerization #Docker #Generative AI (GenAI) #Large Language Model (LLM) #Python
1
0 177
Announcement Olga Zavrazhnova · Jul 28, 2025

Global Masters - New Rewards Arrived

Hey Community! New rewards have arrived on Global Masters 🎁

With our July update, we’ve added some fresh new options for you to choose from! The rewards catalog is now packed with even more exciting ways to exchange your points for something truly useful, , and well-deserved If you’ve been saving up your points, now’s the perfect time to treat yourself!


➡️ Enter Global Masters to check out available prizes*.

🧩 Want to learn how to earn points faster? You can find tips and guidance here 

#Developer Community Official #Global Masters
6
1 153
Announcement John McBride · Jul 24, 2024

VSCode extension for IPM (InterSystems Package Manager) Now Available

Overview

The extension and source code are now available
After having some discussions at Global Summit and using a lot of package managers in my day to day development (npm,nuget,Chocolatey, etc) in addition to recently using the InterSystems Package Manager for some CICD process I'm building using Intersystems IRIS and IRIS 4 Health, I wanted an easy and integrated way to search/view/install packages related to the Intersystems tech stack.

I recently built a VSCode extension for IPM repositories that I will be open sourcing and publishing to the marketplace but wanted create this post to get

#InterSystems IRIS #InterSystems IRIS for Health #VSCode
3
4 211
Article Ash Sherzhanov · Jul 31, 2025 3m read

Avoiding SQL Injection in InterSystems IRIS: The Case for Secure Query Practices

SQL injection remains one of the most critical vulnerabilities in database-driven applications, allowing attackers to manipulate queries and potentially access or compromise sensitive data. In InterSystems IRIS, developers have access to both Dynamic SQL and Embedded SQL, each with distinct characteristics. Understanding how to use them securely is essential for preventing SQL injection.

The Problem: Dynamic SQL and SQL Injection

Dynamic SQL constructs queries as strings at runtime.

#InterSystems IRIS #Security #SQL
0
2 210
Question André-Claude Gendron · Jul 31, 2025

Has anyone built a tool to generate a %Installer Manifest from an existing IRIS system?

Hi everyone,

I’m working with an existing InterSystems IRIS server that hosts several web applications and namespace-specific code and data. I’d like to reverse-engineer the current environment into a %Installer.Manifest file so I can store it in Git and manage its changes.

My goal is to:

  • Track the application setup and configuration in version control
  • Rebuild environments consistently (namespaces, CSP apps, security roles, etc.)
  • Possibly automate deployments later on

I understand that %Installer is declarative and wasn’t necessarily designed to reflect a running system.

#InterSystems IRIS for Health #API #Change Management #Compiler #CSP #Git #InterSystems Package Manager (IPM) #REST API #Security #System Administration
1
2 108
Article Dmitry Maslennikov · Jul 31, 2025 5m read

Introducing testcontainers-iris-node: Simplifying IRIS Integration Testing in Node.js

Overview I'm excited to announce the release of testcontainers-iris-node, a Node.js library that makes it easy to spin up temporary InterSystems IRIS containers for integration and E2E testing. This project is a natural addition to the existing family of Testcontainers adapters for IRIS, including testcontainers-iris-python and testcontainers-iris-java.

Why testcontainers-iris-node? As a Node.js developer working with InterSystems IRIS, I often faced challenges when setting up test environments that mimic production. testcontainers-iris-node solves this by leveraging the testcontainers-node framework to create isolated IRIS environments on-demand.

This is particularly valuable for:

  • Integration testing with IRIS databases
  • Testing data pipelines or microservices
  • Automating test environments in CI pipelines

Features

  • Launches IRIS in Docker containers using Testcontainers
  • Supports custom Docker images and configuration
  • Wait strategies to ensure IRIS is ready before tests begin
  • Clean teardown between test runs
#InterSystems IRIS #Continuous Delivery #Node.js #Testing
Open Exchange
0
1 114
Announcement Luciano Kalatalo · Jul 30, 2025

Better ML Models with AutoML and random samples

Why Randomization is Key When Splitting Data for Machine Learning

Post:
Essentially, Machine Learning is about learning from data. Having "good" data leads to better models, and more importantly, the quality of the information being used plays a crucial role in improving prediction accuracy.

One critical step in the process is how we separate our data into training and validation sets. If this isn’t done properly, we risk introducing bias, overfitting, or unrealistic performance expectations for the model.

In this article, we’ll explore:

  • Best practices for randomization when splitting data into
#InterSystems IRIS #Machine Learning (ML)
Open Exchange
0
0 65
Article Andre Larsen Barbosa · Jul 30, 2025 3m read

Toolqa - The wait is over

Well... It's time for testing. We know that often, it's already over. So, what now? Can I improve the quality of my development?

The answer is: YES. Yes, you can. The Toolqa tool aims to do just that. It's a facilitator. What's its goal?

To ensure that APIs meet pre-established business requirements, while also protecting against <sarcasm>  future failed attempts </sarcasm>  to destroy your application, website, app, or anything else that uses your API.

Now you might be wondering, how does this happen? Where's the magic?

The ToolQA.tool.BP.Tool class was designed as an intelligent and

#InterSystems IRIS #API #Mapping #Testing
Open Exchange
0
1 110
Question Alex Bravo · Dec 12, 2024

Connecting InterSystems IRIS with Metabase BI

Hi everybody,

A customer would like to connect an IRIS database to Metabase BI.  But Metabase does not have a connector that supports the IRIS database.

Metabase only supports these databases:

- Amazon Athena
- BigQuery (Google Cloud Platform)
- Druid
- MongoDB (recommend version 4.2 or higher)
- MySQL (recommend version 8.0.33 or higher, as well as MariaDB version 10.4 or higher)
- Oracle
- PostgreSQL
- Presto
- Redshift (Amazon Web Services)
- Snowflake
- SparkSQL
- SQL Server
- SQLite
- Vertica

And a few others. 

However, it is possible to create a driver for Metabase that connect to IRIS.

#InterSystems IRIS
3
0 190
Article Yuri Marx · Jul 30, 2025 5m read

BI and Interoperability Production documentation on MS Word

Sometimes your client may request documentation of your BI or interoperability project in a formal document. In this case, MS Word is a good alternative, as it has an advanced editor that allows you to generate professional documentation. Now it's possible!
The iris4word app has this functionality!

Final MS Word Document Word Template

 

iris4word business logic

the iris4word get BI asset list and metadata using the InterSystems IRIS BI REST API documented on (https://docs.intersystems.com/healthconnectlatest/csp/docbook/DocBook.UI.Page.cls?KEY=D2CLIENT_rest_api).

#InterSystems IRIS #Analytics #Interoperability
Open Exchange
0
1 82
Question Martin Zukal · Jul 30, 2025

Run InterSystems IAM on OpenShift

Hello everyone,

I would like to ask whether it is possible to run InterSystems API manager (IAM) on OpenShift. Is there some documentation describing how to do it? I was searching the forum as well as the internet and I have not found much unfortunately.

Any hints would be highly appreciated.

Best regards

Martin Zukal

#InterSystems IRIS #API
0
0 55
Article Guillaume Rongier · Jul 30, 2025 15m read

Introduction to Python First Approach in IRIS

img

In this section, we will explore how to use Python as the primary language in IRIS, allowing you to write your application logic in Python while still leveraging the power of IRIS.

#InterSystems IRIS #API #Debugging #DTL #Interoperability #JSON #ObjectScript #Python
Open Exchange
0
8 306
Article Yuri Marx · Jul 26, 2025 8m read

Creating advanced Word documents with IRIS

Word documents are widely used in the market. Users frequently create contracts, memos, resumes, reports, analyses, and other documents that may require data from or captured by InterSystems IRIS. However, IRIS does not have an API, SDK, library, or adapter for this. This limitation no longer exists. 

The new Open Exchange library iris4word (https://openexchange.intersystems.com/package/iris4word) delivers an ObjectScript SDK where the developer passes any %DynamicObject as a parameter, a Word file template and then receives a ready document, with the structure and formatting defined in its template.


#InterSystems IRIS #ObjectScript #Tools
Open Exchange
2
3 122