I am trying to use Dynamic SQL because I need to supply data at runtime.
The generated query returns 0 rows for some reason. If I copy/paste the query into Monitor, it works correctly. I am suspecting it has something to do with dates being the wrong format (I am supplying them in 'YYYY-MM-DD' format). Is that the cause? And if so, how do I supply dates in correct format?

I had a challenge recently where I was asked to parse and iterate JSON to find a patient that has a forename = "Bill" and try to make the function that iterates through the code re-usable.

Being working in Healthcare there isn't much experience or demand for parsing JSON, as most of my work is HL7.

I took this on using the documentation and worked out a way to parse the JSON (see posts below for code and source data).

I've worked out how to iterate through the fields and repeating elements, however I'm having an issue quitting out upon finding a patient with the forename Bill.

E.g. I want to add a button on a widget that will rebuild the cube when clicked. 

How can I make it happen?

In my previous article, we reviewed possible use-cases for macros, so let’s now proceed to a more comprehensive example of macros usability. In this article we will design and build a logging system.

Logging system

Logging system is a useful tool for monitoring the work of an application that saves a lot of time during debugging and monitoring. Our system would consist of two parts:

• Storage class (for log records)
• Set of macros that automatically add a new record to the log

I'm trying to setup a REST server with CORS support. I have created a class that handles a specific part of the service (printer control). This class I have referenced in my main REST class by adding <Map Prefix="/print" Forward="myClass.PrintAPI" />

My main class does have its own <Route>s and handles CORS requests perfectly. But in my subclass OnHandleCorsRequest() is only run when requesting from same origin and never run when making a CORS request. I have set Parameter HandleCorsRequest = "true" in both my main REST class and the subclass.

Hi Developers,
We want to know what you like about Open Exchange and how we can make it better in 2021. Could you please go through this short survey which will let us know what do you think.

➡️ Open Exchange Survey 2020 (3 minutes, 10 questions)

Your answers are very important to us!
Sincerely,
Your InterSystems Developer Community Team

Hi, folks!

Sometimes I need to schedule a task programmatically.

And in 99% I need having some class method be periodically called.

And I want to have the schedule be started by one line. As a job in crontab.

I decided to introduce such a module with iris-cron-task module.

See the details below!

React Native or Flutter which is most compatible with InterSystems

During some consulting activity, I found at the client's site CACHEAUDIT database of more than 100 GB size. The reason was simple: several processes produced a great amount of %System/%System/OSCommand audit records due to frequent external calls ($zf(-100,.)). As it is well-known, those events can be easily disabled systemwide, while this can be hardly considered secure enough. Reducing the number of days before audit cleanup from default 62 to some reasonable figure (e.g.

Purpose

Most CloudFormation articles are Linux-based (no wonder), but there seems to be a demand for automation for Windows as well. Based on this original article by Anton, I implemented an example of deploying a mirror cluster to Windows servers using CloudFormation.I also added a simple walk through.
The complete source code can be found here.

Update: 2021 March 1 I added a way to connect to Windows shell by public key authentication via a bastion host as a one-liner.

We have multiple NTE segments in the ADT message.  I need to loop through all of the NTE segments looking for "NAVIRADTHPT" in the NTE-4 field.  I have yet to get this to work using the following code.  

HL7.(NTE:4()) Contains "<NAVIRADTHPT>"

Here's how the segments look.

NTE|1||This patient is currently being seen for radiation therapy.|AHRADTHPT||20210223093342
NTE|2||This patient is currently being seen for radiation therapy.|NAVIRADTHPT||20210223113634

I've also tried it this way with no luck.

HL7.(NTE():4) Contains "<NAVIRADTHPT>"

Any help would be greatly appreciated!

Hi community,

I need to write an SQL query with hierarchical order, I have a table with a column referencing itself, similar as the sample bellow:

Hi! I have a complex SQL select query which I execute via %ResultSet. It also includes a UNION. The select statement within the union should only be done when an external parameter is set, and I'm not sure of way of doing that within SQL, other than something like

SELECT FOO FROM BAR

WHERE (some conditions)

UNION

SELECT FOO2 FROM BAR2

WHERE :doUnion = 1 AND (some conditions)

this works, but I don't think it's particularly optimal as I believe it will still execute the second SELECT regardless of :doUnion.

Hi developers!

We are glad to share what we have new in March Open Exchange release:

• New editor for long text inputs    
• Table support  
• New analytics views and conversion
• Local GitHub links and images support

Hi,

I have to create to a web socket client, but I'm unable to read any data from the server, after flushing the buffer. I have no access to the server, only two examples for the client, one in java and the other one in php:

java example:

socket = new Socket("192.168.0.1", 2003);

DataOutputStream out = new DataOutputStream(socket.getOutputStream());

out.writeUTF("aPassword");

out.writeInt(websiteId);

out.flush();

DataInputStream in = new DataInputStream(socket.getInputStream());

int orderId = in.readInt();

in.close();
out.close();
socket.

In previous versions of cache I used to be able to write click on a class and get a delete class option but in this version I can not find the delete class option was wondering if there is another way to delete a class if you wanted to do some house keeping.

N.B. These are the classes I create not the ones that comes with cache.

Is there any reason that property method DisplayToLogical() is not calling before object saving?

I have such situation and do not know how it is possible

My response definition is below.  I keep getting ERROR #9406: Unexpected format for value of field, physicianFirstName, using class base mapping. Any ideas would be helpful.

Hi all,

I have a very weird error when I'm calling to a SOAP Webservice as client.

I've create all objects to invoke to this SOAP using the add-in "Assistant SOAP" in Eclipse, it has created all objects (Response, Request, Business operation WS class, etc...).

When I call to this service it retuns the following error message:

ERROR #6243: HTTP request to SOAP WebService returned unexpected CONTENT-TYPE response: text/html.

However, If I call the same WS using SOAP UI or Postman, the header of response has the content-type "text/xml", as expected.

What is

Can a license be reserved for a specific user or group of users? So if I have 20 available licenses, only allow other users to use 19 of them while keeping one open for this specific user?

Hi all

I've been looking into how to convert some images with IRIS and saw some recommendations on the forums around using image magick.

However I can't seem to get this working using ZF100 and on windows server and I'm wondering if I'm missing something really obvious as I've not used IRIS to call third party applications before.

If I run via a Windows CLI on the server, it works fine, e.g:

magick "D:\1221701739_20190716134351965_1_0.jpg" -resize 640x480 "D:\1221701739_20190716134351965_1_TEST.jpg

But I keep getting NOTOPEN when I attempt this in IRIS.

I want to operate on the class in enslib, but I don't have write permission. How can I modify the permission with code, or which table is given write permission

ERROR:#5388 - You do not have write permission on the database class ,so class lock cannot be obtained .

Hey everyone,

The InterSystems Grand Prix Contest is over. It was an incredible competition with a record number of participating apps and developers! 

Thank you all for participating! And now it's time to announce the winners! 

A storm of applause goes to these developers and their applications:

Until what version of HTML and CSS can I use on zen pages? 

Hey Developers,

Enjoy watching this brief explanation of a new feature in IRIS RAD Studio – a new project by @José Pereira and @Henrique.GonçalvesDias:

⏯ Automated user management in IRIS RAD Studio

I need some compasion between these two products， Thx!

Hi 

we are implementing HIE and wan to get expert opinion on facility registry setup. Below are some example and which method we should adapt.

Transition and transfer from Caché to Iris databas. I have a question about import-export from Caché to Iris. Someone will tell you how to do this with a regular one, i.e. using standard procedures from Caché itself or Iris? I am asking in connection with the planned transition from Caché to the new IRIS DBMS.

Hey developers,

We want to hear from you! Give us your feedback on the InterSystems Grand Prix Contest! Please answer some questions to help us improve our contests.

👉🏼 Quick survey: InterSystems Grand Prix Contest Survey

i have a problem with CSP files, i can create a CSP file with termination ".csp" or ".CSP" and this configuration is case sensitive, but a CLS file, this configuration is not case sensitive. there is a way i can change this to the CSP file don't be case sensitive?