I have a large tree outside my window. Here in Phoenix, Arizona, USA it's still warm and sunny so our plants are still covered in lush foliage despite so many other places in the full throws of Autumn. My desk is oriented such that I can look out at the tree throughout the day.

Hi folks,

I am announcing a new package I have loaded on the OEX, which I am also planning on entering into the contest this month.

In a nutshell, what it offers you are the following.

What's a good way to add a custom hyperlink to a table item in Clinical Viewer (CV2)? I am customizing the Diagnostic Studies page, and have a custom transform that returns the HTML code for the hyperlink. The hyperlink is supposed to open a custom CSP page in a new window or tab.

Using the layout editor, I then tried adding several "items" to the table like an Icon or External Viewer Link, and use the custom transform to get the hyperlink, but these items only show up as plain text and do not link to any page. How do I turn these items into a hyperlink?

In Caché, it's possible to iterate a local array using $QUERY() :

set a("foo") = 50
set a("bar") = 30

set key = "a"
for
{
     set key = $QUERY(@key)
     quit:key="" 
     write key_" = "_@key
}

This code works perfectly, unless it's called in a job (eg: a routine called by the JOB command).

Good afternoon people,

I'm setting up an integration using ASTM protocol via Interoperability, but I'm having a problem in returning the communication, the message stays in Loop and doesn't return the information to the device simulator that is executing the operation.

Has anyone of you worked with this protocol and are able to help me unravel this protocol?

When logging in to the management portal page, how to send the encrypted user name and password when sending a request

Hi

Newbie question. Could you please help me implement the following using DTL only - no programming.

We have a problem where our system sends longer addresses e.g. block of flats in an unexpected format

e.g. address below:

Last week I was onsite with a new customer of ours, implementing Deltanji to give them control of their development and deployment cycle. One particularly satisfying part of the visit was seeing their pleasure at how their production class now records its changes over time, allowing them to quickly diff the versions and see what configuration items have been added or what settings altered. ​

So calling this lookup manually from the console works as expected:

However, calling it from a method with some concatination to build the key is giving me problems:

1. A Motivating Example

Embedded Python has been around for a while. You probably followed the tutorials and learned about it. However, if you've tried to combine Python and ObjectScript in real development work, you probably ran into situations where you get an error message like this:

hello,

Is there an InterSystems IRIS connector that allows connect to the IRIS data platform (Hubic) from Power Apps / Power Automate ?

Thanks

Hi Community,

We are glad to invite you to the upcoming Interoperability Contest Kick-off Webinar: Building Sustainable Solutions! The topic of this webinar is dedicated to the Interoperability programming contest.

In this webinar, we'll show you some of the general principles and problems of solving sustainability challenges, as well as some great ideas that came up in hackathons for inspiration and do's and don'ts.

Also, we’ll discuss and answer the questions on how to build interoperability solutions using InterSystems IRIS and IRIS for Health.

Date & Time: Monday, August 29 – 09:00 AM EDT

Speakers:
🗣 Tomas Studenik, CEO of Insane Business Ideas and co-founder of Caelestinus
🗣 @Dean Andrews, Head of Developer Relations
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

Hi,

Is there a way to find the median in Intersystems Cache SQL? I know it is not available as an aggregate function. Also in SQL Server I could try something like:

SELECT
(
 (SELECT MAX(Score) FROM
   (SELECT TOP 50 PERCENT Score FROM Posts ORDER BY Score) AS BottomHalf)
 +
 (SELECT MIN(Score) FROM
   (SELECT TOP 50 PERCENT Score FROM Posts ORDER BY Score DESC) AS TopHalf)
) / 2 AS Median

However, there is no PERCENT Keyword in Cache as well. Any suggestions?

Thanks

If one of your packages on OEX receives a review you get notified by OEX only on YOUR package.
​​​So @Evgeny Shvarov suggested publishing my monthly summary of my reviews here in DC.
It reflects my experience with the status I found at the time of my review.