#InterSystems IRIS for Health

Hello, I'm using the InterSystems IRIS connector for Power BI to connect to our Iris for Health database, using Direct Query.

I have a column [Company] which is datatype bigint, and as far as I can tell the data is 2 for most (or all?) records.

When I bring the data into Power BI, every row shows as NULL (I think it should be 2 for most)

= Table.SelectRows(Table, each [Company] <> null and [Company] <> "")

-- removes all rows

Hi Community,

There are many ways to generate excel files using Intersystems, some of them are ZEN reports, IRIS reports ( Logi reports or formally known as JReports), or we can use third party Java libraries, the possibilities are almost endless.

But, what if you want to create a simple spreadsheet with only Caché ObjectScript? (no third party applications)

Is there any way to dynamically generate the output filename for a schedule task? For example when running a legacy code task every hour , is there anyway to specify the output file name to be appended with time stamp or some incrementing number to avoid overwriting ?

I haver read $Query and $Order but still not getting the code that i am looking to work correctly.

I have a global like

^TestGlobal("Not Configured","Value 1")=""

^TestGlobal("Not Configured","Value 2")=""

Newbie stuck again, hoping this won't be as bad as I'm thinking. In my DTL Editor I've got

Source.Appointments.(k1).Date = 07/05/2022

Source.Appointments.(k1).StartTime = 14:30

Source.Appointments.(k1).Duration = 30

Hi developers.
I often miss the ZPM program on a clean system.
Nothing complicated? Take and install.
And in one line? Especially in a docker container.
There is a solution. I'm very happy with it;)
Maybe the line can be shortened?

Hi There,

I'm fairly new to ObjectScript/Ensemble and I'm sure I may be fundamentally misunderstanding how the %JSONImport/%JSONExport and XDATA mapping work and I was hoping you good folks could help me out. I'm essentially trying to create an object that I can use to translate from one JSON schema to another.

First my class:

Hello,

I am wondering if anyone can help me with an issue we are facing. We are trying to add a parent-child relationship between 2 tables in the database that already contain data. We are able to add the new relationship property to the required data classes, and set the desired cardinality. We have also included code that will add the relationship using the Insert() method to new data that comes in.

The problem we have is how do we add the relationship to data that already exists in the database?

I'd like to to assign a value to a variable, depending on the results of a condition. The equivalent of what can be done in c++ with the following:

(a>b) ? a=1:a=0;

Or in python:

a = 1 if a>b else 0

This makes the code much more readable and compact.

In objectscript it would be:

Hi all

I'm struggling to insert into a table, and it is baffling me. The insert statement is now very simple (I was using a complex INSERT SELECT statement but I'm trying to narrow down the problem).

Insert statement:

Hello, everyone!

InterSystems IRIS has a menu called Interoperability.

It provides mechanisms to easily create system integrations (adapters, record maps, BPMs, data conversions, etc.) so different systems can be easily connected.

Hi All,

I am trying to install IRIS Health CE on a Ubuntu VM, so I can test IAM with it.

During the installation I get the following error:

=================

Warning: The installer can't find a platform in this distribution
supported by your system.

Searching for platforms that might install in unsupported mode...

1) Ubuntu LTS (x64)

Enter the number for your system: 1

Your system type is 'Ubuntu LTS (x64)'.
openssl version 1.1.1 is required.

** Installation aborted **

No packages will be installed.

Hi,
I am looking to define an architecture combining both IRISforHealth's FHIR server and HAPI's MDM capabilities. Is there anyone who has already implemented this type of solution?
The goal is to implement a single patient repository for multiple hospitals, so HAPI MDM is really interesting.
From what I've seen, some of the issues may be around compatibility between Caché and Hybernate.

Thanks