Syndicate content 0  
 

If you're migrating from Oracle to InterSystems IRIS—like many of my customers—you may run into Oracle-specific SQL patterns that need translation.

Take this example:

SELECT (TO_DATE('2023-05-12','YYYY-MM-DD') - LEVEL + 1) AS gap_date
FROM dual
CONNECT BY LEVEL <= (TO_DATE('2023-05-12','YYYY-MM-DD') - TO_DATE('2023-05-02','YYYY-MM-DD') + 1);

In Oracle:

2 1
0 88

Hi Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ It's CLEAR - Re-Imagining the Digital Front Door @ Global Summit 2024

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

0 0
0 88

Hi, Community!

⛅Need to connect your application to InterSystems Cloud Services? Get a high-level overview of the process:

Connecting to InterSystems Cloud Services

https://www.youtube.com/embed/gcVhUSNhNuM?utm_source=youtube&utm_medium=social&utm_campaign=gcVhUSNhNuM
[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]

0 0
1 20

Is anyone using DICOM Interoperability in IRIS for Health configured in Mirror?

I'm asking because I'm not sure how to handle where the DICOM messages are stored.

For some reason DICOM use the filesystem to store raw messages, the directory used can be configured in the StorageLocation production settings, obviously this is a big issue if/when a mirror failover occur.

Unfortunately in IRIS it's not possible to change the DICOM storage from file stream to global stream.

Has anyone came across this issue?

0 9
0 119

Hi Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ Innovation Highlight - Medical Device Waveform Data @ Global Summit 2024

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

0 0
0 91

InterSystems has released new point updates to resolve a defect affecting the most recent prior versions of 2025.1.0, 2024.1.4, 2023.1.6, and 2022.1.7, for the following supported product lines:

0 1
0 111

For those that use IRIS for Health, HealthShare, and or Health Connect...

As Health Applications are moving to the Cloud, how have you handled communication from the Application to your instances via HTTPS?

Trying to figure out the best path on designing the proper workflow to allow these messages to be allowed to be eventually sent to our EMR to post to the patient chart.

We are very wary of opening a connection from the internet to our instance of Health Connect.

Thanks

0 0
0 54
Question
· Jun 11
Multiselction Zen component

Hi Guys,

I'm looking for a Zen component that allow me to populate a list of items and the ability to multiselect, similar to checklist?

I've thought of using MultiSelectSet component but don't know how can I populate it like to a query or resultset?

a short sample code would be helpful.

Thanks

0 6
1 66

I have created a New Database/Namespace within our TEST environment on both the Primary and Backup of the mirror. When I go to create the database/namespace on the DR node I am getting "Cannot open file '/ensemble/TEST/iris.cpf_...." while the cpf file that it references does not exist. Anyone have any clue to why this might be happening?

0 3
0 63

Hi Developers,

We’ve got great news — the Developer Community has a new, smart, and proactive helper:

🤖 Developer Community AI Bot a.k.a. @DC AI Bot 🤖

Powered by the same IRIS Vector Search technology as the DC AI assistant, our new @DC AI Bot takes it a step further:

👉 it automatically scans every newly posted question — and, if it finds a relevant answer, leaves a reply right in the comments.

10 12
0 265

good afternoon!

I was trying to set up the "File Spec" to match the exact filename that will be in the file path.

however, it seemed grab whatever the name of the file and work on it.

wondering how I can specific the exact filename in "File Spec" so that It wont touch other files in the same path?

https://docs.intersystems.com/healthconnect20251/csp/docbook/DocBook.UI....

0 1
0 39

Hi Community,

Our Project Managers created a series of videos to highlight some of the interesting features of the new 2025.1 release. Please welcome the first one of them:

⏯ Foreign Tables in InterSystems IRIS 2025.1

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

2 0
1 60

Introduction

MonLBL is a tool for analyzing the performance of ObjectScript code execution line by line. codemonitor.MonLBL is a wrapper based on the %Monitor.System.LineByLine package from InterSystems IRIS, designed to collect precise metrics on the execution of routines, classes, or CSP pages.

The wrapper and all examples presented in this article are available in the following GitHub repository: iris-monlbl-example

7 1
2 189

Digital health solution providers face increasing pressure to integrate complex health data systems while ensuring scalability, security, and compliance with standards like HL7 FHIR. Fast Healthcare Interoperability Resources (FHIR) has revolutionized health data exchange by offering a standardized framework that allows diverse health IT systems to communicate effortlessly. But simply adhering to FHIR standards isn’t enough to overcome the intricacies of health data integration. Solution partners must leverage advanced architectural components like FHIR brokers, façades, and repositories to build scalable and efficient solutions. InterSystems offers all the essential features you need to implement FHIR for your health data, whether on-premises, in a public cloud, or as a cloud-based service managed by InterSystems.

Medical Science Hospital Lab Meeting healthcare

1 0
1 96