I'm looking for a SQL function equivalent for SQL server STRING_SPLIT. I have records like this:

join_to_tx_history (key), ss_note_multi_dict_1_value (varchar)

and I like the field ss_note_multi_dict_1_value split to rows for each comma delimited value. So I can get this:

Hello everyone,
I can choose between RSA and DSA. ECC seems to be unsupported.
Is there any workarounds without using external binary like curl?

Best regards
RY

Hello,

I created a custom business operation to copy PDF files in Intersystems Healthshare. To copy the files I used:

$ZF(-100, "", "cp", "-f", tSource, tTarget)

tSource contains the source file e.g. "/opt/var/data/dir/1821008687135422926_5849146876.pdf".

tTargetSource contains the target file "/opt/targetdir/Müller_Jörg_1821008687.pdf".

Copying files without german Umlaute works fine (e.g Smith_Robert_1821081542.pdf), but when the string contains special characters like "ä", "ö", "ü" or even "ß" copying is not successful.

Hello there developers,

As I started to install the IRIS for community editing I came across this interface. (Image attached below)

Is there a major difference in these 2 types of installations and is there a place where I can refer with regard to this in detail please?

Please let me know.

Thank you in advance.

We use the Category drop-down for other IT analysts to quickly see interfaces related to their application/group. This drop0down fails to work (IDs get out of sync with Config Item IDs) if the Production is compiled. There is no fix available (development was started, but stopped in favor of other items).

Has anyone else run into this issue? Any custom work-arounds?

Example:

Hi Community,

Want to learn about the Record Mapper tool? Then don't miss this video on InterSystems Developers YouTube:

⏯ Using the Complex Record Mapper

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

I'm trying to connect to a database (outside Cache) using the examples here:

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

and https://docs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=BGOD_g...

Images for other languages are often build using multistage build process.

What about InterSystems IRIS?

Consider this Dockerfile:

FROM irishealth-community:2020.4.0.524.0 AS builder

# Load code into USER and compile
# Adjust settings, etc.

FROM irishealth-community:2020.4.0.524.0

# replace in standard kit with what we modified in first stage

COPY --from=builder /usr/irissys/iris.cpf /usr/irissys/.
COPY --from=builder /usr/irissys/mgr/IRIS.DAT /usr/irissys/mgr/.
COPY --from=builder /usr/irissys/mgr/user/IRIS.DAT /usr/irissys/mgr/user/.

The advantage of this approach is the image size.
The disadvantage is that on a final stage developer must know/remember all the modified places in the builder image.

But otherwise is this approach OK for InterSystems IRIS?
Have anyone tried to build IRIS images this way?

There is an undocumented command, $preprocess, that can be called as below. In this case it takes the class name and converts its code into a text array. That includes comments as well. Two questions about it if you know:

Awhile back the Developer community helped me with a situation I was having... How to loop through a Repeating Segment and Single Filed, example OBX().5, within a Business Process Rule and compare it against a Data Lookup table.

Well now I need to take it a step further. I need a way to loop through OBR() segment, and loop through OBR().4() and the subfield 4.1 and compare it to a Data Lookup table.

So I thought I could copy my existing function code and add another level to it, but its not returning what I would expect.

Hi-

I have a REST client that calls a REST service and as a response gets a stream containing a JSON structure. The service is placing some weird non-printable characters into some places in the JSON document that is throwing off parsing of a down-stream XML document.

What I would like to do is just remove the non-printable characters from the response stream that comes back from my call to the REST service.

Does anyone have a handy utility or method for removing all non-printable characters from a character stream?

Hi ,

I am trying to retrieve the contact type column data of a patient based on the recent date as shown below.

for instance

contacttype Datefrom

contact 1. 24/03/2020

contact 2. 20/05/2021

i need to retrieve the second contact2 based on the recent date.

i tried like below but not working .

Case max(datefrom) >0 then contacttype

End as contacttype

Can anyone please tell me why this is not working.Any other options?

Thanks

jude

Hi developers!

I have an existing CSP app and I want to add a role to it. How can I make it programmatically?

Hi Community,

We're pleased to invite all the developers to the upcoming InterSystems FHIR Accelerator Contest Kick-Off Webinar! The topic of this webinar is dedicated to the FHIR Accelerator programming contest.

On this webinar, we will talk and demo how to use InterSystems IRIS FHIR Accelerator as a service.

Date & Time: Monday, May 10 — 01:00 PM EDT

Speakers:
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager
🗣 @Regilo Regilio Guedes de Souza, InterSystems Service Executive
🗣 @Anton Umnikov, InterSystems Senior Cloud Solution Architect
🗣 @Patrick Jamieson, InterSystems Product Manager - Health Informatics Platform

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