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
If you’re heading to READY 2026, make sure the Tech Exchange is on your list! It’s where things get a bit more interactive — demos, conversations, quick questions, and real-time answers from the people behind the tech 🚀
Stop by the Developer Ecosystems Booth👋
Learn how we support developers at every stage of their journey. Stop by to:
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.
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 Community,
Preparing for InterSystems Certification exams requires 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.
The platform offers a large pool of practice questions mapped to certification domains, along with detailed answer explanations that point back to relevant documentation.
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.
Hi Community,
Enjoy the new video on InterSystems Developers YouTube:
⏯ Data on the Move - Securing InterSystems IRIS Connections with TLS @ Ready 2025
InterSystems is pleased to collaborate with the Harvard Health Systems Innovation Lab (HSIL) on the HSIL Hackathon 2026.
As part of this joint initiative, InterSystems will support participants with a dedicated challenge focused on building innovative healthcare applications using modern interoperability and AI technologies.
The HSIL Hackathon 2026 is a two-day innovation event focused on developing solutions that improve healthcare systems through the use of AI.
📅 Event dates: April 10–11, 2026
📍 Format: One hackathon taking place simultaneously in two hubs
👥 Participation: ~50 teams across both locations
🏆 Next step for winners: Venture Building Program
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.Definition
{
Parameter TaskName = "Long running messages";
Property LongRunningMessageThreshold As %Integer(MINVAL = 1) [ InitialExpression = 60 ];
Method OnTask() As %Status
{
set ts = $zdatetime($NOW(0),3,1)
set ns = ""
while 1 {
// Iterate namespaces
set ns = $o($$$EnsJobMonitorRoot(ns))
quit:ns=""
set job =""
while 1 {
// Iterate jobs
set job = $o($$$EnsJobMonitorRoot(ns, job))
quit:job=""
// Get business host name
set bh = $o($$$EnsJobMonitorRoot(ns,job,""))
// Get the time of the last state change
set lastActivity = $$$EnsJobMonitorRoot(ns,job,bh,"%LastActivity")
// Get active message, if any - bh can be just idling
set active = $d(^[ns]Ens.ActiveMessage(job),messageid) // From $$$EnsActiveMessage
if active {
set time = $system.SQL.Functions.DATEDIFF("s", lastActivity, ts)
if time > ..LongRunningMessageThreshold {
set text = $$$FormatText("Long running message %1, in ns: %2, BH: %3, processing since %4, for %5 seconds", messageid, ns, bh, lastActivity, time)
// For debug
// write text, !
do ##class(%SYS.System).WriteToConsoleLog(text)
}
}
}
}
quit $$$OK
}
}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!
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
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
Introduction
The standard %Net.HttpRequest library in InterSystems IRIS is powerful and comprehensive, but it can be verbose for simple operations. Writing an HTTP request often requires several lines of code to instantiate the class, configure the server, the port, HTTPS, add headers, and finally send the request.
When testing in the terminal, this configuration quickly becomes too heavy, and usually ends up with the creation of temporary methods...
FastHTTP
The 2023.1.7 maintenance releases of InterSystems IRIS® data platform, InterSystems IRIS® for Health, and InterSystems 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:
Early Access Programs (EAPs)
There are many EAPs available now. Check out this page and register to those you are interested.
IrisTest is a light weight, powerful, user-friendly tool designed to simplify unit test report generation. It includes an interactive shell and API to facilitate communication, allowing developers to easily manage and generate reports for their test runs in various formats. Whether you're debugging or creating detailed reports for analysis, IrisTest makes the process smooth and efficient!
Hi Community,
Enjoy the new video on InterSystems Developers YouTube:
⏯ Ahead of the Threats - The Future of Secure Systems @ Ready 2025
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.
Hi Guys,
I get a Quit argument not allowed error in an if block how can I fix this?
So I would like to start a production with a service that has an SQL trigger for after and INSERT. Then I would like it to start a process. Could someone help me in the direction of a solution, please and thanks.
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 😊
 |
|
100,000 points |
|
|
60,000 points |
Keep publishing. Keep asking. Become a Legend. 🚀
Hello InterSystems Community,
I hope you're all doing well. I'm reaching out to ask if there's any way to enable a dark theme or dark mode for the HealthShare Management Portal.
Background
I have a visual impairment (amblyopia/lazy eye) which means I'm nearly blind in one eye. Like many people with visual difficulties, I find that bright white backgrounds and interfaces cause significant eye strain and fatigue. This makes it challenging to work with the Management Portal for extended periods.
Hi Communtiy,
I am a begineer who is working and trying to understand Intersystems. I am developing an Ensemble interface which receives a XML message and converts it into HL7 format without using enslib.HL7 classes.
Requirement
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 = ##class(MyApp.Data).%New()
Set obj.Name = $List(fields,1)
Set obj.Age = $List(fields,2)
Set obj.Email = $List(fields,3)
Do obj.%Save()
}
Quit $$$OK
}SetUp:
vIris instance created on Production Host i.e. Host1 on local mount point based on local disk.
vA single LVM is created out of 20 PVOLs and mapped to a mount point directory for IRIS database on both hosts.
vA single LVM is created out of 5 PVOLs and mapped to a mount point directory for WIJ on both hosts.
vA single LVM is created out of 5 PVOLs and mapped to a mount point directory for Journal on both hosts.
On Host-1
Created tables on the IRIS database on Host1.
vStart insert operation on the database.
I have created the following Task to kick off a Ens.BusinessService to execute a SQL query and process the results
Class OSU.Workday.TerminationsTask Extends %SYS.Task.Definition
{
Parameter TaskName As STRING = "OSU - Workday Termination Update";
Method OnTask() As %Status
{
#Dim sc as %Status
#Dim ex as %Exception.AbstractException
set sc = $$$OK
try{
// create the service
#Dim tService As OSU.DataSource.Workday.TermService
Set tServiceConfigName = "OSU.DataSource.Workday.TermService"
// Call BusinessService
$$$ThrowOnError(##class(Ens.Director).CreateBusinessService(tServiceConfigName,.tService))
$$$ThrowOnError(tService.Adapter.OnTask())
set (tHint) = ""
}catch ex{
set tSC = ex.AsStatus()
}
quit tSC
}
ClassMethod TestTask()
{
set tTask = ##class(OSU.Workday.TerminationsTask).%New()
$$$ThrowOnError(tTask.OnTask())
}
/// Location and Revision of this file in Perforce (Auto-updating)
Parameter SrcVer = "$Id$";
}
Hi Community,
Enjoy the new video on InterSystems Developers YouTube:
⏯ Jobs to Be Done - Products Your Customers Will Really Buy @ Ready 2025
Join Bob Moesta, founder of the Re-Wired Group and co-architect of the Jobs to Be Done theory, to discover tools to help you understand your customers. Bob will introduce the essential frameworks and tools that underpin Jobs to Be Done, while challenging you to rethink how you approach customer behavior.
Hello, I am working with @Alberto Fuentes https://openexchange.intersystems.com/package/workshop-iris-oauth2.
I wonder how do I get a token to send to the resserver?
I tried calling "token_endpoint" : "https://webserver/authserver/oauth2/token"
The response was "error":"invalid_request","error_description":"Unknown grant_type"
I wonder what needs to be in the request body? Is it a GET or POST?
READY 2026 is almost here and some people are still deciding whether to go 👀
Imagine a colleague asks you: “Why should I attend READY this year?”
You only get one sentence to convince them.
💙 Read other responses and like the ones that stand out to you. The comment with the most likes will receive 500 bonus points on Global Masters.
Drop your best argument below 👇
Let’s see who can make READY 2026 impossible to resist.
We are trying to run the HS solution inside of a container, but we are getting the following errors un start up
03/17/26-10:19:05:108 (1386) 1 [Generic.Event] Cannot lock /usr/irissys/mgr/hslib/ err(13): will try accessing readonly
03/17/26-10:19:08:174 (1386) 1 [Generic.Event] Cannot lock /usr/irissys/mgr/enslib/ err(13): will try accessing readonly
I understand that those databases should be mounted as read only don't needing the lock, any idea how to fix it? or where should I look to configure it correctly?
Thanks!
03/17/26-10:19:08:176 (1463) 0 [Database.
