HI, in The Netherlands I get lots of questions on the ability of InterSystems to handle openEHR data. Before I start a local initiative I'm interested in other work done with openEHR. Anybody?

Regards, Joost

Hello,

I just installed the IRIS 2024 version 2 and it doesn't have Cache Studio.  Doesn't anyone know how to add Cache Studio in the IRIS 2024 version 2 or did I install the wrong one?  Thank you for your help in advance.

Alan

Hello to you!

Is it possible to write to Windows Eventlog with Object Script?

Tried a bit but having trouble getting it to work. If possible, I would be grateful for a piece of sample code

Regards Michael

I attended Cloud Native Security Con in Seattle with full intention of crushing OTEL day, then perusing the subject of security applied to Cloud Native workloads the following days leading up to CTF as a professional excercise. This was happily upended by a new understanding of eBPF, which got my screens, career, workloads, and atitude a much needed upgrade with new approaches to solving workload problems. 

An IRIS.DAT file was removed, as it was not needed anymore. But the database was mirrored, so it still shows up in the mirror monitor and database list. How can this be fixed? There is no backup of the .DAT file so it cannot be restored.

w##class(SYS.Mirror).RemoveMirroredDatabase("/mydir/")

throws a protect error.

(everything else works fine and this is not a production system, it only is annoying in the mirror monitor and database list)

I can START and STOP a business process via its Schedule setting.

Is it possible to change the value of another Setting in an analogous way?

I can imagine a SettingSchedule that could look like 

action:YYYY-MM-DDThh:mm:ss[,action:YYYY-MM-DDThh:mm:ss]

But rather than just START or STOP, action could be "SET Setting = value", overriding whatever the normal value is.

Is there an existing way of achieving this kind of functionality?

Hello community,

How to install the iris  package installer for Python (pip) in python and import iris package in python source code. 

import iris
class Solution():
    iris.connection()

thanks!

Hey Community,

It's time for the new batch of #KeyQuestions from the previous month.

Here are the Key Questions of August chosen by InterSystems Experts within all Communities:

You might know that you can search posts in DC by Tags
starting in left upper  corner   and  

that's fine to start. But - based on some local feedback - some improvements
might make is more useful. actual the SELECT works .. IF TAGS CONTAIN %tag 
This spams you with a lot of results but often much more than useful
so the suggestions for extensions:

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in August 2024:

I am excited to share that the Learning Services team has recently added new content to our InterSystems Reports Learning Path. These latest videos, created by our partner, insightsoftware, provide instruction for developing reports with InterSystems Report Designer.

In these three short videos, you’ll learn how to:

docker login -u=<username> -p=<password> containers.intersystems.com
WARNING! Using --password via the CLI is insecure. Use --password-stdin.
Login Succeeded

$ docker pull containers.intersystems.com/intersystems/irishealth:2024.1
Error response from daemon: unauthorized: The client does not have permission for manifest: Download request for repo:path 'docker-customer-remote-cache:intersystems/irishealth/2024.1/list.manifest.json' is forbidden for user: 'anonymous'.

why the download is not working.

In today's data landscape, businesses encounter a number of different challenges. One of them is to do analytics on top of unified and harmonized data layer available to all the consumers. A layer that can deliver the same answers to the same questions irrelative to the dialect or tool being used. InterSystems IRIS Data Platform answers that with and add-on of Adaptive Analytics that can deliver this unified semantic layer. There are a lot of articles in DevCommunity about using it via BI tools. This article will cover the part of how to consume it with AI and also how to put some insights

InterSystems FAQ rubric

In SQL, NULL data and the empty string ('') are different data. The method for setting and checking each is as follows.

(1) NULL data

[SQL] 

insertintotest(a) values(NULL)
select * fromtestwhere a ISNULL

[InterSystems ObjectScript]

setx=##class(User.test).%New()
setx.a=""

(2) Empty string ('')

[SQL]

insertintotest(a) values('')
select * fromtestwhere a = ''

[InterSystems ObjectScript]

setx=##class(User.test).%New()
setx.a=$C(0)

For more information, please refer to the following documents:

NULL and empty strings [IRIS]
NULL and empty strings

When I was searching for the ideas to migrate IRIS DB to Oracle, I could find a tool called "ESF Data Migration tools" over internet with easy steps.

Can we use them to migrate?

Link for your reference

https://www.dbsofts.com/articles/cache_to_oracle/
 

Thanks in advance

Hi Community, 
Join our next Developer Meetup in Cambridge, MA to learn the latest trends, tools, and features to Innovate on Health Data.

>> RSVP here <<

Hi, Community!

Curious how a retrieval-augmented generation (RAG) application works? Take a look at this demonstration:

Exploring a Basic RAG Application

I need to know if given package exists or not.

Currently found two solution - one doesn't work, another works but I don't like it.

Solution 1.

I started, of course, with %Dictionary package - it has PackageDefinition class after all.

However, %ExistsId returned 0 on packages that clearly do exist, so I went to %LoadData, it uses this macro to determine if the package exist:

#define PACKAGE(%package)             ^oddPKG($zcvt(%package,"u"))

And zw ^oddPKG showed the root cause - ^oddPKG global only contains data for packages with tables (or something along these lines).

Solution 2.

For those of you who still use the Studio IDE for ObjectScript programming and are going through the process of migrating to VS Code, did you know there's a section in the VS Code documentation just for you? Have a look at the Migrating from Studio chapter. It covers:

• Server-side editing and source control
• Studio projects
• Importing server definitions from the Windows Registry
• Loading Studio snippets and syntax colors

Hey Community,

We're pleased to invite you all to the upcoming kick-off webinar for the InterSystems Developer Tools Contest 2024!

During the webinar, you will discover the exciting challenges and opportunities that await IRIS enthusiasts in this contest. We'll discuss the topics we expect from participants and show you how to develop, build, and deploy applications using the InterSystems IRIS data platform.

Date & Time: Tuesday, September 10 – 12:30 pm EDT | 6:30 pm CEST  

If you plan on using the nginx server to front end you IRIS instance (as opposed to the standard apache web gateway install) you will need to add a few configuration options into the CSP.conf file in order for all urls to work. It took me a little bit to figure this out but this seems to be the configuration that works.

I'm trying to convert date - 2023-09-28T20:35:41Z to BST/GMT format. I tried with $ZDT($ZDTH("2023-09-28T20:35:41Z",-2),8,1) but it's giving the output as '19700101 01:33:43' and looks link the date format in $ZDTH specified is wrong. Any inputs or solution would be appreciated.   

Hello,

I've recently updated the python version of a linux server running Red Hat Enterprise Linux 8.10 (Ootpa). We have an instance 2023.1 running there, and whenever I run the $System.Pyhthon.Shell() I can see it's still pointing to the old version. From within linux, it runs the latest one (we've change all the links to the new 3.11, so no scripts are broken).

So I guess the problem comes from the fact irispython is still compiled using old python version. So, how can I do to force IRIS to use the current version on the server, or update the irispython file?

Thanks!

Hey Community, 

We’re pleased to announce that the InterSystems Ideas Portal now features 400 diverse and innovative ideas 🙌🙌🙌

This milestone highlights the active participation and creativity of our Community. We appreciate all the contributions and support that drive the ongoing success of this portal!

Hi,

I am using this "$ZDATETIME($h,3,1,3)" and getting response as 2024-09-03 12:07:45.000
But I need proper values at the end instead of zeros (000)

Something like below -
2024-09-03 12:07:45.658

Hello everyone,

I'm a bit confused about the number of elements in an XML object.
I have an object of the class EnsLib.EDI.XML.Document
The xsd structure ( DocType)  is an SDA Object

We are third party vendor who acts as a buffer between the customer and intersystems to purchase licenses for intersystems.
I am wondering can we use AWS license manager to manage the IRIS licenses on behalf of our customers?

HealthShare Unified Care Record Fundamentals – InPerson * Cambridge, MA September 23-27, 2024

* Please review the important prerequisite requirements for this class prior to registering.

I encountered an unexpected behavior while working with the $ZTIMEH and $ZTIME functions, specifically with times between 12:00 and 13:00. Here's what I observed:

W $ZTIMEH("08:50:38.975411826")
Output: 31838 

W $ZTIME(31838,1)
Output: 08:50:38
 

This behavior is correct as $ZTIME returns the expected time of 08:50:38.

However, with the following example:
 

W $ZTIMEH("12:05:38.975411826")
Output: 338

W $ZTIME(338,1)
Output: 00:05:38
 

This seems incorrect to me. $ZTIME should have returned 12:05:38, but instead it returns 00:05:38.

Hi,

I'm getting an unexpected behavior when using pandas function to_sql(), which uses sqlalchemy-iris. After the first execution, a transaction seems to be opened and all rows inserted are lost after closing the connection: