Hi Everyone,

I am a very new to IRIS Object Script Development. There is a usecase where I have to execute a .sh file from the object script. I am looking for examples for that, but what I find is the ways to execute the shell commands. Can you please point me to some examples executing a .sh file. Thanks in Advance

I have followed the Article: Continuous Delivery of your InterSystems solution using GitLab, On our own Linux environment it works well but when I try to run it on a clients windows server; and the following command is run by the runner

irissession IRISHEALTH -U TEST "##class(isc.git.GitLab).load()"

we get the following "error"

<NOTOPEN>>

Is it possible to mirror the same database on Iris and an older Ensemble instance?

Specifically to try a zero downtime upgrade

Has anyone here been successfully populating a %Persistent object from calling %LoadFromMemory() with a temp. global?

I have tried using Sample.Person in the SAMPLES namespace. It worked EXCEPT that I have no way to set the id into that Sample.Person objec.

Hey Community,

I have an scenario, please advise or suggest possible ways to solve it.
So i have a persistent class to test results of a diagnostic laboratory. The properties are

• Patient name
• Type of Test
• Order ID

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")=""

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:

Hi,

I want to access a Stored Procedure in a remote SQL Server Database. I am quite new to Object script.

The stored procedure has 3 parameters: 2 datetime parameters and 1 integer.

Which is the best way to do that? I'm wondering if I can use the link stored procedure feature inside object script or some SQL statement in Object Script.

This SP returns a set of rows which I want to read, transform and save in a persistent class.

Thanks in advance,

I have a proprietary JSON and a need to transform to SDA and save to a sda file.

How to transform json to SDA and write to a file?

Thanks

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!

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，guys

My client is using IRIS 2021.1 Interoperability and they want to highlight the sessions with unresolved(without resent and completed operations) errors so their maintenance team can have a list of unresolved sessions to check against.

When I'm working on it, it seems to be it is is difficult to decide whether a session have unresolved errors. For example,