Hi All,
I am facing some issues. I am having a SQL query that is executed using %SQL.Statement ExecDirect() method. Now I want to convert it into Embedded SQL using &SQL().
But where clause is dynamic in my case and It may contain 3-4 clauses.
InterSystems IRIS for Health™ is the world’s first and only data platform engineered specifically for the rapid development of healthcare applications to manage the world’s most critical data. It includes powerful out-of-the-box features: transaction processing and analytics, an extensible healthcare data model, FHIR-based solution development, support for healthcare interoperability standards, and more. All enabling developers to realize value and build breakthrough applications, fast. Learn more.
Hi All,
I am facing some issues. I am having a SQL query that is executed using %SQL.Statement ExecDirect() method. Now I want to convert it into Embedded SQL using &SQL().
But where clause is dynamic in my case and It may contain 3-4 clauses.
Hey everyone,
Here we are again. New year, new contest, new project, old reasons.
Triple Slash is in the house!
SQLBuilder is a flexible and powerful SQL query string builder for InterSystems IRIS,
With SQLBuilder you have nice and clean object oriented methods, instead of having to use concatenation and substituition to generate dynamic queries.

If you like it, don't forget to vote in the IRIS Programming Contest
Managing InterSystems Servers - Virtual August 14-18, 2023 9:00am-5:00pm US-Eastern Time (EDT)


This is a sample to deploy iris-oauth-fhir on k3d with IKO.
Hi
We've been asked to develop a HL7 interface, but the end system has very different needs than any we've ever interfaced with before. We need assistance to determine if these needs are things HealthShare can support that we're just not aware of, or whether we'll need to develop some custom code to accomplish this.
This end system wants us to send HL7 messages completely asynchronously, one after the other without waiting for any form of ACK or NAK. My first thought was that we could have an outbound HL7 operation which set the session to deferred, with a separate inbound listener service on
When manually coding REST services and using GET /api/mgmnt/v1/:namespace/spec/:application/ to return an OpenAPI spec, how do you specify supported properties (OpenAPI Properties in Use | Creating REST Services | InterSystems IRIS Data Platform 2021.1) like responses, definitions, and information in paths like summary and description?
Using a very basic manual REST service that returns a JSON string I get a pretty basic spec that is not really helpful when it comes to documentat
.png)
Hi InterSystems Community
We recently had an issue where we weren't able to parse a JSON HTTP request, but the issue went by unnoticed. We also did not have a trace of what the raw HTTP request was that we couldn't parse. I'm looking at improving our this by:
Tracing the raw request using $$$TRACE
Raising an alert which will hit our Ens.Alert router which will compose and send an email
I'm having an issue with consistently raising the alert (I've seen it raise an alert before, and then it wouldn't raise it again on a subsequent message), and also the error back does not really make sense. He
InterSystems announces its sixth preview, as part of the developer preview program for the 2023.2 release. This release will include InterSystems IRIS and InterSystems IRIS for Health.
Many updates and enhancements have been added in 2023.2 and there are also brand-new capabilities, such as Time-Aware Modeling, and enhancements of Foreign Tables (but still as an experimental feature). Note that some of these features or improvements may not be available in this current developer preview.
Another important topic is the removal of the Private Web Server (PWS) from the installers.
I am trying to write a class method to return the value of a object element. Input to method is the object and element. I am not getting a value returned. What am I missing?
ClassMethod GetObjectFieldValue(pObject As %DynamicAbstractObject, pField As %String) As %String
{
quit:pObject="" ""
quit:pField="" ""set tResponse=""
set tResponse = pObject.%Get(pField)
return tResponse
}
Here is my input data,
{
"priority": "2",
"lastmodifieduser": "PORTAL",
"assignedto": "jdoe01 STAFF",
"status": "REVIEW",
"documentclass": "PATIENTCASE",
"versiontoken": "937486",
Hi, I'd like to ask if it is possible to use an arbitrary JSON as a DTL source. Can the IRIS DTL editor parse JSON of arbitrary structure and display it as a tree?
I'm open for new opportunities and challenges. Remote Job for any part of the world. Languages: portuguese, english and spanish.
I have more tha 20 year of experience with InterSystems Technologies.
Two InterSystems Certifications.
Large HealthCare Interoperability Experience.
I'm worked on large projects in Brazil, Chile, United States.
Knowledge in other program languages then COS, like Java, Python, C#, JavaScript, R.
mail: cristiano.js@gmail.com
LinkedIn: https://www.linkedin.com/in/cristianojs/
Does InterSystems has CDS Hook implementations? if yes, where I could get the details.
As it says in documentation %ZEN.Auxiliary.jsonProvider been deprecated. We been using it's functions like %ConvertJSONToObject, WriteJSONFromObject etc. Is there any replacement?
A customer wants to create an IRIS for Health business rule via the graphical editor, and then to execute that rule in ObjectScript without the context of an interoperability production. Is this possible, and if so, how?
It can be obtained by using the Size query of the system-provided %SYS.GlobalQuery class.
See the sample code below for usage examples.
*Please check the class reference for specifying columns and parameters.
set dir="C:\intersystems\iris\mgr\user" // IRIS.DAT(or CACHE.DAT) folder
set rs = ##class(%ResultSet).%New("%SYS.GlobalQuery:Size")
do rs.Execute(dir) // You can also specify a mask with the 3d parameter
while (rs.Next()) {
set gname= rs.Get("Name") // global name
set gsize= rs.Get("Used MB") // global size (MB)
write gname," : ",gsize,!
}
With rapid evolution of Generative AI, to embrace it and help us improve productivity is a must. Let's discuss and embrace the ideas of how we can leverage Generative AI to improve our routine work.
Hi,
I'm trying to figure out why I'm unable to iterate through a dynamic array and access the nested objects.
Using the NHS PDS FHIR API in the NHS sandbox environment, I'm querying the PDS endpoint using a sample NHS Number to retrieve a patient's demographics. My Business Operation reads the response data and passes it back to my Business Process where I intend on iterating through certain nested objects. The data present in these nested objects will decide what happens next in the process.
In the JSON snippet below, I'm attempting to access the values of code and display.
"meta": {
Is it possible to hide certain properties in a class from displaying in the BPL visual editor, if you want to prevent drag and drop from accessing them or otherwise controlling or restricting their behavior?
Virtual document messages, such as EnsLib.HL7.Message, have hidden fields, such as Source, that do not show, presumably since the field list is rebuilt from the document schema. Setting the flag Internal, or XMLPROJECTION = "NONE" doesn't do it. Trying to follow the Virtual Document precedent to rebuild or edit the field list seems like a heavy list.
The extended maintenance releases of InterSystems IRIS, InterSystems IRIS for Health, and HealthShare Health Connect 2023.1.1 are now available. This release provides bug fixes for the previous 2023.1.0 releases.
You can find the detailed change lists / upgrade checklists on these pages:
The software is available as both classic installation packages and container images. For the complete list of available installers and container images, please refer to the Supported Platforms webpa
Hi All,
I am trying to fetch resultset using the below code -
set rs = ##class(%ResultSet).%New("Simple.Person:ValidateAge")
do rs.Execute()
it is giving me error while the same code I run it through iris terminal worked fine.
I want to understand that problem behind this. Also how can I check the possible methods that I can use on 'rs' somewhat dir() does in python.
I am getting this "Studio Item 'Ens.StringResponse' is mapped from a database that you do not have write permission on. " if I am pressing any key in that class. I need to define some Property inside it. How Can I do the same
As said in the previous article about the iris-fhir-generative-ai experiment, the project logs all events for analysis. Here we are going to discuss two types of analysis covered by analytics embedded in the project:
In order to extract useful data to apply analytics, we used the iknowpy library - an opensource library for Natural Language Processing based in the iKnow for IRIS Data Platform. It makes possible identifies entities (phrases) and their semantic context in natural language text in several languages.
Here it's used to extract concepts from data of


Previous post - Using AI to Simplify Clinical Documents Storage, Retrieval and Search
This post explores the potential of OpenAI's advanced language models to revolutionize healthcare through AI-powered transcription and summarization. We will delve into the process of leveraging OpenAI's cutting-edge APIs to convert audio recordings into written transcripts and employ natural language processing algorithms to extract crucial insights for generating concise summaries.
While existing solutions like Amazon Medical Transcribe and MedVoice offer similar capabilities, the focus of this post
Hi Community,
In this article I will demonstrate the usage of InterSystems Embedded Python, We will cover below topics:

Hello Everyone,
The Certification Team of InterSystems Learning Services is in the process of developing two exams focused on using SQL in InterSystems IRIS and we need input from our InterSystems IRIS SQL community. Your input will be used to evaluate and establish the contents of the exam.
How do I provide my input? We will present you with a list of job tasks, and you will rate them on their importance as well as other factors.
How much effort is involved? It takes about 20-30 minutes to fill out each survey. You can be anonymous or identify yourself and ask us to get back to you. If you
With InterSystems IRIS FHIR Server you can build a Strategy to customize the behavior of the server (see documentation for more details).

This repository contains a Python Strategy that can be used as a starting point to build your own Strategy in python.
This demo strategy provides the following features:
Account resourceObservation resource
Observation resource is returnedObservation resource is not returnedHi everyone,
This one had me breaking a sweat 😅
When a SOAP request has a %Stream.GlobalBinary property, it fails to serialize to base64 when stream is larger than ~43MB with
ERROR #6301: SAX XML Parser Error: <MAXSTRING>xeWrite+7^%occXMLInternal
Unless you enable the following parameters :
Parameter BASE64LINEBREAKS = 1;Parameter USEPPGHANDLER = 1;The first one instructs %SOAP.WebBase to insert line breaks in the XML text, and the second one to use globals rather than local array memory during serialization (to avoid <STORE> error, depending on your available $zstorage)
Enabling
Idea sourced from InterSystems Ideas Portal
Previous Posts:
Using AI to Simplify Clinical Documents Storage, Retrieval, and Search
Doctor-Patient Conversations: AI-Powered Transcription and Summarization
The healthcare industry is continuously evolving, and the need for efficient document management and patient data management is more critical than ever. In this article, we will focus on the specific aspects of integrating Google Docs and Google Sheets with FHIR data in the context of healthcare data interoperability.
Integra
