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 63

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 40

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
0 10

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 42

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 90

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 1
0 30
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 7
0 50

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 5
0 44

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 232

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 2
0 27

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
0 42

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 44
Question
· Jun 8
Create Python pages

Hi Guys,

How can I create Python pages instead of CSP or Zen pages, not familiar with Python and the only way I know is using embedded Python as methods as attached below?

Thanks

0 1
0 57

Let's suppose two different routines use one and the same chunk of code. From the object-oriented POV, a good decision is to have this chunk of code in a separate class and have both routines call it. However, whenever you call code outside of the routine as opposed to calling code in the same routine, some execution speed is lost. For reports churning through millions of transactions this lost speed might be noticeable. Any advice how to optimize specifically speed?

0 14
0 117

Hi Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ Migrating 20TB to InterSystems IRIS with Near 0 Downtime @ Global Summit 2024

https://www.youtube.com/embed/-SM22eF8ekU
[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 56
Hello and welcome to the May 2025 Developer Community YouTube Recap.
InterSystems Global Summit
0 0
0 25

Hi IRIS experts!

I have a parameter in a class that stores a global name:

Parameter GlobalName = "^AGlobal";

then I'm trying to call it as:

set gn=$name(..#GlobalName)

to use it later as:

set @gn@("index")="value"

But! I'm having syntax at set gn=$name(..#GlobalName)

What am I doing wrong?

1 12
1 101