Hello To all my fellow Cache Developers,

How the new year is finding everyone well.  The purpose of this post is to ask everyone a question about Cache tablepane dblclick functionality that does not appear to be working like I thought it would.   Here is my dilemma:   I have a fairly simple tablepane that displays several columns of data (just strings and dates).  I setup the tablepane property dblclick to call a client method, so I can take an action based on the row that the user double-clicked on.  So that table property is set to this     dblclick="zenPage.

Hey Community, 

We invite you to join the next French stream on InterSystems Technologies #8,  hosted by @Guillaume Rongier!

Date & Time: February 3rd, 12:00 Paris time.

👉 Direct link to join: https://youtu.be/2PFgnuF8bO8

If you're deploying to more than one environment/region/cloud/customer, you will inevitably encounter the issue of configuration management.

While all (or just several) of your deployments can share the same source code, some parts, such as configuration (settings, passwords) differ from deployment to deployment and must be managed somehow.

In this article, I will try to offer several tips on that topic. This article talks mainly about container deployments.

Requirement: Transform source XML message to target JSON.

step1: First create json equivalent xml from any online tool.

Did you catch an Experience Lab at the 2021 Virtual Summit? Head over to the InterSystems Learning site to access all four of these hands-on exercises, and get up to speed on:

Hey Community, 

Learn about the changes we've made to InterSystems IRIS Containers, including security updates and the new web gateway container:

⏯ InterSystems IRIS Container Updates

Sometimes it is necessary to transfer or migrate data and data schema from Postgres to IRIS. There are currently a few options for doing this, but the two most popular options are using DBeaver (https://openexchange.intersystems.com/package/DBeaver) or SQLGateway. The first will be demonstrated in this article and the second is presented in an excellent article by Robert Cemper, DB Migration using SQLgateway (https://community.intersystems.

Astronomers’ tools

5 years ago, on December 19, 2013, the ESA launched an orbital telescope called Gaia. Learn more about the Gaia mission on the official website of the European Space Agency or in the article by Vitaly Egorov (Billion pixels for a billion stars).

However, few people know what technology the agency chose for storing and processing the data collected by Gaia. Two years before the launch, in 2011, the developers were considering a number of candidates (see “Astrostatistics and Data Mining” by Luis Manuel Sarro, Laurent Eyer, William O’Mullane, Joris De Ridder, pp. 111-112):

• IBM DB2,
• PostgreSQL,
• Apache Hadoop,
• Apache Cassandra and
• InterSystems Caché (to be more precise, the Caché eXTreme Event Persistence technology).

Comparing the technologies side-by-side produced the following results (source):

The first four will probably sound familiar even to schoolchildren. But what is Caché XEP?

Hi Community,

Welcome to the first InterSystems Spanish technical article writing competition! Write an article in Spanish on any topic related to InterSystems technology:

🏆 1st Spanish Tech Article Contest 🏆

Duration: February 1-28, 2022

Prizes for everyone: Everyone who publishes an article on Spanish Dev Community during this period will receive a special prize pack!

Main prize: Apple iPad

I want an example that converts CDA to FHIR R4.

Need Full production pipelines like service, process, and operations.

I'm using this Dockerfile to build .Net Gateway with my PEX BS. It works fine. If I change the image reference here to store/intersystems/iris-community:2021.2.0.617.0 in line 8 (so update from 2020.2 to 2021.2) it fails to build with:

KafkaConsumer.cs(4,20): error CS0234: The type or namespace name 'EnsLib' does not exist in the namespace 'InterSystems' (are you missing an assembly reference?) [/source/KafkaConsumer.csproj]

KafkaConsumer.cs(9,34): error CS0246: The type or namespace name 'BusinessService' could not be found (are you missing a using directive or an assembly reference?

Hi Community,

I have created persistent classes for source, target XSDs and completed DTL. When I tested in DTL window by passing source xml it is generating below target xml as result.

DTL result:

<root>
  <CaptureSource>2</CaptureSource>
  <Document>
    <Description>1235@TEST.COM.Message.ReportType</Description>
    <EventDate>1489@TEST.COM.Message.EventDateZ</EventDate>
    <ExternalSystemId>1213@TEST.COM.Message.ReportID</ExternalSystemId>
    <FileContent>1142@TEST.COM.Message.

Hello everyone,

I am having a challenge with the IRIS community version in Docker with wsl2. Host machine is Win 11 and the IRIS/Ubuntu image is Ubuntu-20.04 from running 'wsl -l -v.

I am not able to reach the WebPortal in IRIS nor the Super User port. docker ps -a = containers.intersystems.com/intersystems/iris-community:2021.1.0.215.3   "/tini -- /iris-main"   3 weeks ago   Up 26 hours (healthy)   0.0.0.0:1972->1972/tcp, 2188/tcp, 53773/tcp, 0.0.0.

I am looking for a way to find all properties defined in any given class through coding, including those inherited from parent class(s). In case of inherited properties, I would like to know from which class etc.

A related question: XML adaptor provides a way to export xml schema for a class. Is there a similar method for JSON adaptor to generate a JSON schema for a class?

Thanks in advance for your help.

Hello Community,

to return data from the OnPage() method of a %CSP.Page I used to simply write out the value of a %DynamicArray e.g. via

write tResponse.%ToJSON()

and return $$$OK afterwards.

Large objects bigger than 4MB result in an exception when trying to create return values using this way. What is best practice for returning values as JSON, especially if values exceeding the capcity of the %String class are to be expected? I saw that it is possible to write data to a file with e.g.:

set tmp = tResponse.%ToJSON("/opt/home/tmp/test_stream.

When I installed the IRIS 2021.2 Community Edition, I found some Globals, which seem to be set for the Intersystems Ensemble and DeepSee products. For me that is an annoying design error in those products and only confusing my developers.

As I do not want to use these, I tried to delete them, because they interfere in the list of globals mixed with our own Globals.

But for several of the EnsEdi Globals I get an error message telling me, they can't be deleted, because they are wrong.

Is there a way to get rid of them? Or do I have to wait for a new IRIS version?

We are using the out-of-the-box  IHE components to exchange CCDs with an external system. A requirement to audit the outbound CCDs has arisen.

Is there an existing report that will show these ? If not, how can we audit these?

Thank you for reading

Hi Guys,

I've set DEFAULTMODE ="xlsx" in my report to be exported to Excel but it's exporting as .zip, is there something I need to add or set or maybe MS Excel to be installed in the server?

Thanks 

We are running HealthShare on Linux Redhat via Azure.

A couple of days ago, the Azure server rebooted. Which we were unaware of. 

Resulting in the Instance being in a downed status.

In the short term I put together a quick script to check the status, if it is down to restart it.

However, before I go down that road, I thought it would be best to inquire if there is a much better and more streamlined solution?

In a nutshell I just want to check and see if the Instance is up or in a state such as  down or hung then start it.

Hi Community,

Let's meet together at the online meetup with the winners of the InterSystems Datasets contest!

You'll have an opportunity to have a discussion with InterSystems Product Managers on new LOAD DATA functionality, Q&A on datasets, etc. Our winners' demo included!  

Date & Time: Thursday, January 20, 2022 – 11:00 EDT

Hey Community,

We're pleased to welcome @Weidong Li as our new Moderator on the Developer Community in Chinese!

Let's greet Weidong Li with big applause and take a closer look at his bio!

Is there any recommended KPI's we should be using to monitor our IRIS configurations in Azure?

I started some development with the IRIS 2020.4 version and did not continue it for some months.

Now I just wanted to continue, but saw the license is not valid anymore.

Is there still a possibility to upgrade to 2021.2 community edition and to recover the globals from the old edition without having a valid license key?

How to execute it from the command line? I am able to use SQL in Management Portal, but I need to do it in Unix 

select * from Ens_Util.Log where ConfigName='SFTPTo.HQ.SAFETRACE.DFT' AND Text LIKE '%Put Stream%' and TimeLogged LIKE '%2021-10-16%'

I have a user value set for an HL7 component that was removed from the source message.  How can I pull that value for use in a Routing Rule suppression logic?  Or do I have to create a custom class in order to do so?

Hi Developers,

I have created SOAP webservice , did not mentioned any security. Configured business service.

When I try to invoke from soaup UI, getting below error.

Hi,

We a currently looking at a way of securing any future REST API's using OAuth2, where the Authorisation Server (OAuth2) and Resource Server would be on the same server.

However, as we have mirrored environment the Resource Server, and therefore the Authorisation Server, need work with a Virtual IP Address and be able to failover to either of the mirror member servers.

Is that possible with OAuth2 and if so what are the best practices for this?

Any advise or guidance much appreciated.

Thank you.

Hey Developers,

Watch as the presenter uses IKO to deploy the WebGateway, SAM, and InterSystems API Manager with the latest version of the InterSystems Kubernetes Operator: 

⏯ IKO: The InterSystems Kubernetes Operator (Version 3.0)

Hey Developers,

It's time to announce the winners of the InterSystems Datasets contest! Are you ready?

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

Hi Guys,

I was testing the Zen report from Samples namespace ( ZENReports.PageLayouts) by changing the DEFAULTMODE  from PDF to xlsx and html and noticed that each time I get different output and fields! I thought that the output should be the same and the only difference would be the report format, or am I missing something? try yourself and you will see.

Thanks