It's time to announce the Winners for May 2022! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in May 2022:

🥇 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria

🥈 @José Pereira, Business Intelligence Analyst at Shift Consultoria e Sistemas LTDA, Brazil

🥉 @Heloisa Ramalho, Software Developer in the Application Services, InterSystems, USA

🥉 @Guilherme Mendes, Developer, BPlus Tecnologia, Brazil

Learn more about the competition and our awesome winners below.

Hi,

Any suggestion on how to compare dates? Below is my code but it does not seem to work.

USER>w $zdate(zdateh(x,8),1) > $zdate($zdateh(y,8),1)

When I set x to "06/01/2022" and set y to "04/01/2022" gives me an output of 1

When I set x to "09/01/2019" and set y to "04/1/2022" still gives me an output of 1

Any help is appreciated.

Thanks!

Hey Developers,

Learn about the changes we've made to InterSystems IRIS Containers, including security updates and the new web gateway container:

⏯ InterSystems IRIS Container Updates

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

Hello,

I'm using a ComplexBatchFileService to retrieve and process a 425 Mo File ( lines )

At some point the Business Service is in failure , and displays this error :

ERREUR #5002: Erreur Cache: <FILEFULL>%SaveData+18 ^CFAO.EOS.MasterFilePR.PMP.RM.ART1.Record.1 ^CFAO.EOS.MasterFileE50F.RecordD(535405931),e:\eos\
+
ERREUR #5002: Erreur Cache: <ROLLFAIL>%TRollBack+10 ^%occTransaction

Hi all.

I have a transform that I am calling from within an objectscript process, and I need to pass it a few values. I have in the past done this using the aux property, however I have got away with only needing to pass in a single value, so I have not had to worry about passing in anything other than a string container.

Hi Community,

Let's meet together at the online meetup with winners of InterSystems Grand Prix contest!

A great opportunity to have a discussion with our Experts on InterSystems technology. Our winners' demo included!

Date & Time: Friday, June10, 2022 – 11:00 AM EDT

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

I have been asked if we can capture the FHIR request and responses.

My first thought was to look at the ODS NameSpace to see if there was already a table with this info being written to.

There are a couple of tables that looked promising HS_FHIRServer_Interop.Request and HS_FHIRServer_Interop.Response. However, they did not pan out.

Is there a table which is capturing the request and responses by chance?

Motivation

This project was thought of when I was thinking of how to let Python code deal naturally with the scalable storage and efficient retrieving mechanism given by IRIS globals, through Embedded Python.

My initial idea was to create a kind of Python dictionary implementation using globals, but soon I realized that I should deal with object abstraction first.

So, I started creating some Python classes that could wrap Python objects, storing and retrieving their data in globals, i.e., serializing and deserializing Python objects in IRIS globals.

Good Morning SMEs,

I am a .NET developer and new to using this IRIS Component. We are using InterSystems.Data.Clients ADO.NET component to connection to IRIS, I am able to open the connection but when i called Close, ADO.NET code showing connection is closed state in .NET code but in IRIS side it showing as connection is still open. The will close only after recycling apppool or closing IISExpress/calling application

Here are the steps I used to open the IRIS connection.

what class or API I shall be using to execute a piece of sql to another server from one server? From within cache itself not java or python or any other languages.

Anything like $System.SQL.%Connect(...) ?

In the good old days (tm) determining the size of the data, streams, and indices for a class/table was easy - you just ran %GSIZE and check D, S, and I globals respectively.

However, nowadays sharding, optimized global names, and indices in separate globals produce %GSIZE output looking like this:

Hi,

I have 3 simple tables: Encounter, Patient and Immunizations. Encounter makes a reference to Patient, and Patient contains a list of Immunization objects.

I've tried using PowerBI to access IRIS (using ODBC connector, not InterSystems BI connector), PowerBI reports the error:

Expression.Error: The column 'Patient' of the table wasn't found.
Details:
    Patient

it does this for two of the three tables I need only (Patient and Encounter), but not for Immunization IRIS table..

Hi everyone, I'll be honest with you I don't have much idea how to do this, but I was asked to install IRIS for Health on an AWS ubuntu machine(ssh -i "teleker-net.pem" ubuntu@xx.xxx.xx.xxx(no I will put the real number)). My boss has sent me the .key and .pem files that I am supposed to need for the installation.

This month I announce the release of version 1.8.0 of the VS Code extension, which contains the following enhancements and bug fixes.