Hi developers!

Want to share with you the new February release on Open Exchange:

• The ability to leave reviews and give ratings for applications
• Visits information on the Analytics page
• Other minor UI enhancements

When using "IDENTITY" as my primary key, I can select the last inserted ID with 

SELECT LAST_IDENTITY() FROM %TSQL_sys.snf;

Actually this is how Hibernate + Iris' Driver acquires the inserted ID when mapping with

@GeneratedValue(strategy = GenerationType.IDENTITY)

Now, considering that I am using the type "SERIAL" as my primary key instead, how can I get the last inserted ID?

Note that with "SERIAL" I can forcefully insert any value for this ID, from which Iris will continue generating values.

I want to create simple CSP page with some fields to filter and a table in the page that shows results from a table. Where to start any tips

I have lots of msg control id received from customers and i search these msg control id first in router to review the msgs and then search the same msg control id in the respective edge message viewer.

Is there a way i can generate the msg trace URLs for router and edge by using msg control id?

When I create a TASK on the Primary mirror member and Try to create the same TASK in the backup mirror member,  It Gives me CSP Application error.

The TASK gets created in the Primary node without any errors and When creating in the Backup node it prompts the error.

It happens is IRIS and I didn't face this in CACHE.

Finally what I did is export the TASK in Primary and Imported in Backup.

Is this a feature of IRIS?

Set SPMData= "SPM|1|A||^^^^^^^^||||ABDMN^ABDOMEN A^L|""_Modifier1_""^L~""_Modifier2_""^L~""_Modifier3_"

HL7 SPM:

SPM|1|A||^^^^^^^^||||ABDMN^ABDOMEN A^L|1^1^L10C^10:00^L11C^11:00^L|||||FREE TEXT NOTE 1|||202102152216||||||||||||

Hi Community! 

I'm sharing a little tool (REST service) to download interoperability messages from your browser.

You only need to:

1. Create a web application in Management Portal (e.g. /downloadmsg) and set DispatchClass=Util.DownloadMsg.
2. Call the tool using your browser passing the namespace and the message header id to download. http://localhost:52773/downloadmsg/ns/mydev/msgid/17441

/// 
/// Util to download messages given a message header id
/// 
/// Setup:
/// 1. Create a webapplication (e.g. /downloadmsg) and set DispatchClass=Util.DownloadMsg
/// 2.

I am working on automating to pick all the jobs running particular business process and kill them by using a routine. Though I was able to kill the jobs/PID on server by using (sudo kill jobid) and by using do $SYSTEM.Process.Terminate(jobid) or  Do ##class(Ens.Job).UnRegister("buseiness host", jobid), I am looking to build a routine by setting a variable with all the business process names and then fetch the jobid or PID associated with those business process and kill them. Any help is highly appreciated.

想问一下IRIS里有SHA256withRSA  加密算法的实现吗？因为最近用到该加密算法进行接口调用。

Translated by moderator

I want to know if IRIS has SHA256 with RSA encryption algorithm? we have interface needing this encryption algorithm recently.

Is there an API that can be used to remotely fetch the state of an IRIS instance similar to what is reported with "iris list"?  Specifically, I'm looking to be able to remotely detect when an IRIS instance is in "hung" state.

I know there is the "iris_system_state" metric that I can consume in Grafana, but I found that when our system was in a "hung" state, there was just no data for that metric and I'd think if you alert on that, you cannot be sure if the IRIS system is down or hung or there's just an issue with prometheus fetching stats from IRIS.

I have vendors asking for verification that messages for locations are coming through to them.  I can get generic ADT_A01 type of numbers in Activity.  I'd really like to get some good SQL queries that can give me a count of MSH.4s (for example) for a day for X Operation.  I'm not sure which table to look at for that information.

Hey Developers,

See how you can use InterSystems IRIS and Alteryx together to provide analytics and insights to your users.

⏯ Using InterSystems IRIS and Alteryx

How can I activate and configure web applications by code without going to the management portal?

And how to configure the rights of the web-application also by code without clicking on the form in the management portal?

Hello,

I have established an ODBC connection with our client based on credentials they provided.    The test connection was successful and after using the Link Table wizard I can now see the client's tables and properties.    However when we try to execute a query in IRIS we are getting error code -226.   I'm trying to determine if this could be just a simple setting problem in IRIS or something with the client.   

We have tried with PostgreSQL as well as with TSQL.  Same result for each.

Has anyone seen this error before and could it be pointing me in a certain direction?

We are a multi-state Health Information Network seeking experienced integration analysts for immediate, full time positions. Currently these positions are 100% remote. Excellent benefits.

Ideal candidates will have extensive experience with InterSystems HealthShare, experience with Amazon Web Services, HL7 v2 & v3, and IHE ITI profiles. Rhapsody or other integration engine experience is a plus. We are seeking confident, motivated individuals with strong communication skills and the ability to engage directly with a variety of healthcare stakeholders.

Hello all,

I have a Business Service which retrieves data via a SQL adapter and writes the data in text file. My production is doing the job, but instead of the Business Operation output being one file, I am getting many files, with 1 , 2 or 3 rows only. 

Any help is appreciated. 

Thank you 

Hey Developers,

We're pleased to invite you to the upcoming webinar in Russian called "Virtual Summit + Open Exchange"!

🗓 Date & time: Febraury 16, 10:00 (UTC+3, Moscow time)

🗣 Speaker: @Eduard Lebedyuk, Sales Engineer, InterSystems 

Hi everyone, I am trying to return a cloned version of my ADT that I have made changes to in a Business Process.  So far I have the following in my process.  

&sql(Select MemberId INTO :pMemberIDval from CDSM_MemberAPI.MemberInfo where MemDOB = :ptDOB and MemLname = :ptLname and MemFname = :ptFname)

set newrequest = pRequest.%ConstructClone()

set MemberIDPID4 = newrequest.SetValueAt(pMemberIDval, "PID:4.1")

The following does return the value I am populating the clone with to the log

  set newrequestPID4 = newrequest.GetValueAt("PID:4.

Hey Developers,

Thank you so much for being with InterSystems Developer Community for yet another year! 

More than 8K+ users are already registered in our community! And day by day our team is trying to make it better and more useful for InterSystems developers.

We want to know how helpful the Developer Community is for you today. Please go through this short survey which will let us know what do you think and what could be improved!

👉🏼 Developer Community Survey 2020 👈🏼

Note: The survey will take less than 5 minutes to complete.

Hi Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems Multi-Model Contest!

Date & Time: Friday, Febraury 5, 2021 – 10: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.

Since some months ago we automatized source code analysis for projects on Github, so anyone with an open source project can have its code analyzed with no cost.

You only need to create the file ".github/workflows/objectscript-quality.yml" in your project with following contents:

name: objectscriptquality
on: push

jobs:
  linux:
    name: Linux build
    runs-on: ubuntu-latest

    steps:
    - name: Execute ObjectScript Quality Analysis
      run: wget https://raw.githubusercontent.com/litesolutions/objectscriptquality-jenkins-integration/master/iris-community-hook.sh && sh .

February 11, 2021 – Advisory: Incomplete Query Results with ‘ORDER BY <row ID field> DESC’ – HealthShare

InterSystems has corrected a defect that can cause incomplete query results.  This defect affects the platforms underlying HealthShare and HealthShare Health Connect:

• InterSystems IRIS and InterSystems IRIS for Health 2019.1.0, 2019.1.1, and 2020.1.0

See Alert: Incomplete Query Results with ‘ORDER BY <row ID field> DESC’ for further detail

Customers using HealthShare Personal Community should evaluate the number of proxy relationships they have established or removed.

Hi Developers,

We're pleased to invite all the developers to the upcoming InterSystems Grand Prix contest kick-off webinar!

The topic of this webinar is dedicated to our mega Grand Prix contest. We invite to use IntegratedML, Native API, multi-model, Analytics and NLP, Open API and Interoperability, IKO.

In this webinar, we'll talk about the topics to expect from participants and show you how to develop, build and deploy applications on InterSystems IRIS data platform.

Date & Time: Monday, Febraury 8 — 10:00 AM EDT

Speakers:  
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

🗣  @Thomas Dyar,  InterSystems Product Specialist - Machine Learning

February 11, 2021 – Alert: Incomplete Query Results with ‘ORDER BY <row ID field> DESC’

InterSystems has corrected a defect that can cause incomplete query results. This defect affects:

• InterSystems IRIS and InterSystems IRIS for Health 2019.1.0, 2019.1.1, 2019.2, 2019.3, 2019.4, 2020.1.0, 2020.2, and 2020.3
• HealthShare Health Connect 2019.1.0, 2019.1.1, 2020.1.0
• HealthShare Products 2019.2, 2020.1 and 2020.2

(In HealthShare and HealthShare Health Connect, this defect only affects Personal Community with 64,000 patient proxies and possibly customer-built custom queries.

Hello everyone,

I have an issue with using "Open" function.

My goal is to execute a shell script with parameters like as:

/trak/FRXX/config/shells/transportIDE.sh "login|password|NOMUSUEL|PRENOM|NOMDENAISSANCE|1234567891320|199999999999999999999999|09%2099%2099%2099%2099|31%2F12%2F1999|242%20IMPASSE%20DES%20MACHINCHOOOOOOOOSE%20||99999|SAINT%20BIDULETRUC%20DE%20MACHINCHOSE|isc%24jhu|123456|123456798"" 2>&1"

But when some parameters are too long, I have a <NAMEADD> error.

Hello,

We would need to find messages where a property "pEntrada" of type %GlobalCharacterStream contains "C006"

We have read:

https://docs.intersystems.com/irislatest/csp/docbook/Doc.View.cls?KEY=E…

We have tried:

The production outputs:

How could we search in fields which are not strings?

Hi developers!

Recently we announced the preview of Embedded Python technology in InterSystems IRIS.

Check the Sneak Peak video by @Robert.Kuszewski.

Embedded python gives the option to load and run python code in the InterSystems IRIS server. You can either use library modules from Python pip, like numpy, pandas, etc, or you can write your own python modules in the form of standalone py files.

So once you are happy with the development phase of the IRIS Embedded Python solution there is another very important question of how the solution could be deployed.

One of the options you can consider is using the ZPM Package manager which is described in this article.

Hi Developers!

Here're the technology bonuses for the InterSystems Grand Prix Contest that will give you extra points in the voting.

Below are the details and useful links on all the technical bonuses.

Hello,

We would be grateful if you could help us,

Our aim is to develop a method which retrieves an image stored in an external system, using a REST Operation

To upload the image we have the following code:

/// Operacion para gestionar el Registro imagen identidad digital en Tarjeta Sanitaria
Class Operaciones.REST.miSCS.miSCS Extends EnsLib.REST.Operation
{

Parameter INVOCATION = "Queue";

/// Subir la imagen del usuario
/// La documentación para crear este metodo es:
/// https://docs.intersystems.com/irisforhealthlatest/csp/docbook/Doc.View.cls?

Hi community, 

 The question that I have , it's very simple. I developed a pivot that contains two rows, the first it's a date and the other another field. I need to orde by date in descending order and I can´t find where I can do this. I saw that it's a option Sort members, but it's based  in a condition of the measures. 

Can someone help me with this. 

Thanks in advance.