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:

64559.001    Assistant Principal
64559.001    Case Worker
64559.001    Client
64559.001    Dad
64559.001    Daughter
64559.001    Mentor
64559.001    Mom
64559.001    Other
64559.001

Hey Developers,

Enjoy watching this new video on InterSystems Developers YouTube:

⏯ Demo of REST APIs defined in Swagger, built with InterSystems IRIS interfacing with a SQL backend

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

Hi all

I'm trying to recreate this method below in Cache/IRIS. 

https://en.wikipedia.org/wiki/Luhn_mod_N_algorithm ISO-7812-1 (LUHN-10)

I've been following the javascript example. It seems simple in theory but i'm struggling with which cache methods to pick.

$LENGTH, $System.SQL.FLOOR() - seem ok

$EXTRACT - I think for .charAt (though may need to correct base)

$FIND - for .indexOf

Any suggestion which would be the best ones for the job?

Thanks

Dan

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.

Do I have to replace the special characters or is there a possibility to

Let's imagine if you would like to write some real web application, for instance, some simple clone of medium.com. Such sort of application can be written using any different language on the backend side, or with any framework on the frontend side. So many ways to do the same application, and you can look at this project. Which offers a bunch of frontends and backends realizations for exactly the same application. And you can easily mix them, any chosen frontend should work with any backend.

Let me introduce the same application realization for InterSystems IRIS on a backend side.

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. 

Hello Community,

On the installation process of the IRIS Community Edition I came across an interface as below (image attached.)

I would like to know what it means, what is the use of it, what it is and where can i know more on this? 

I tried the documentation page but was not successful in finding anything regarding it. 

I would like to know more on it please. 

Hoping to hear soon. 

Regards. 

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:

Thanks.

Hi Team,

Can you please provider some example how to Create ACK/NACK for HL7 ORU ?

Thanks,

Ankur Shah

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

Hi Community,

We're pleased to invite you to the upcoming webinar in Spanish called "Learning ObjectScript from scratch"!

Date & Time: May 25, 4:00 PM (CEST)

Speaker: @David Reche, Manager of the Dev Community in Spanish

The webinar is aimed at:

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

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

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

and i'm still getting an error on running the Connect method (Connect(pDSN,usr,pwd,0))

"0 "_$lb($lb(6022,"DSN/User Connect",,,,,,,,$lb(,"TRAK",$lb("e^zConnect+15^%Library.SQLGatewayConnection.1^2","d^zConnect+13^%Library.SQLGatewayConnection.1^2","e^^^0"))))/* ERROR #6022: Gateway failed: DSN/User Connect. */

i verified the

Hello All,

Just wanted to acknowledge the fact that this community has become a great resource for help. I have had many wonderful people helping me out with my questions in last couple of weeks. Thank you to all of you :)

Regards,

Utsavi

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?

When you have been using cubes for business intelligence in a namespace for some time, you may find that there are many cubes in the namespace, only some of which are actively being used. However, it can be difficult to tell which cubes users are or are not querying, and maintaining unused cubes can be costly both in terms of storage and of computation to keep them up to date. This article provides some suggestions and examples for monitoring which cubes are in active use, and for removing cubes that you determine are no longer necessary.

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:

1. Is that the only job that $preprocess does?
2. Why would it generally work for most classes except for a single class? This is probably a bug since it works in a later Cache option for this class too but I need to work with this Cache version as well. This class does not contain any control characters except for plain vanilla tabs, checked.

Set tResultCode=$preprocess(pClas

In this article we are going to show the results of the comparision between IRIS and Postgress when handling Astronomy data.

Introduction

Since the earliest days of human civilization we have been fascinated by the sky at night. There are so many stars! Everybody has dreamed about them and fantasized about life in other planets.

Astronomers have been identifying and classifying stars since many centuries ago.

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.

I need some help. I have a requirement where HL7 messages will be sent through http. I am trying to read through the documentation & want some guidance.

The client is asking for a URL. So should I simply send the Ensemble url to them? Does the message structure change? How does Ensemble handle incoming http messages? Do I just create a http business service and it should come across fine?

Has anyone done a project with http? Would love some information on how it worked for you

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 Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems Developer Tools contest!

Date & Time: Friday, April 30, 2021 – 11:00 EDT

What awaits you at this Virtual Meetup? 

• Our winners' bios.
• Short demos on their applications.
• An open discussion about technologies being used, bonuses, questions. Plans for the next contests.

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 

If I have an online backup running and a snapshot backup is run whereby a freeze/thaw is done, will the online backup be affected ?

Hi developers!

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

We are running a restore of a mirrored database on the secondary mirror member via the DBREST restore procedure.

Since it is run from an interactive session, if the session times out or the vpn is severed, the restore is affected..... is there a way to run the restore in a background process instead ?

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

Hi Team, 

      A month ago, we purchased the cache license for a 10user limitation. We are a 6developers and using 3different development (internal)servers for this same license. All Developers aren't login at the same time. We have a limitation for login 2developers at a time in a server. But sometimes, we are facing a <LICENSE LIMIT EXCEEDED> issue.   We don't know why we are facing this one.  So anyone please guide me, why we are getting this type of issue. I have attached the errored screenshot.

Thanks, 
Ponnumani G  

Hello,

I am trying to find out if it is possible to decode the Azure access token in IRIS. Has anyone ever tried this before? I need to decode the token to extract the "Scope" details in order to verify the scope to make sure client is permitted to do the request they have done.

If you could point me to any information, that'd be great. 

Thank you.

Utsavi

I need to show the absence of data, so I have to join the list of predefined values with a result of a select statement.
However, it seems like Table Value Constructors in JOIN are either not supported, or I do not understand the syntax.
Basically, I am going for something like this:

Select v.valueId, m.name 
 From (values (1), (2), (3), (4), (5)) v(valueId)
     left Join otherTable m
        on m.id = v.valueId

Is it supported in Cache SQL or not?