I'm trying to get a count of specific message type with a specific entry and thought I could build the query in Message Viewer but  this does not provide counts (as far as I am aware). So when I take the SQL from 'Show Query' it omits the segment criteria as the code shows below. 

 I have attached the criteria that has been excluded. Is this possible?

Thank you

SELECT head.ID AS ID, 
       {fn RIGHT(%EXTERNAL(head.TimeCreated),12)} AS TimeCreated,
       head.SessionId AS SESSION,
       head.Status AS Status,
       COUNT (*) AS messages,
       CASE head.

My VS Code plugin "InterSystems Objectscript" upgraded to version 0.8.7 but the server settings no longer visible in extension settings and can no longer connect to our InterSystems server.

What has chnaged and how do we set the server connectio up? I checked the JSON file and it still has the settings as it was before but it is not connecting.

Screenshot of the settings json and then on the left a timer icon on the InterSystems icon and blue line running from left to right at top as it tries to conenct to server. I downgraded to version 0.8.

Hi Community!

We're pleased to invite you to the Online Meetup with the Winners of the InterSystems IRIS AI Programming Contest!

Date & Time: Friday, July 24, 2020 – 11:00 EDT

What awaits you at this virtual Meetup? 

• Our winners' bios.
• Short demos on their applications.
• A short interview with all the winners about the past contest. Plans for the next contests.

Preview releases are now available for the 2020.3 version of InterSystems IRIS, IRIS for Health, and IRIS Studio!

The build number for these releases is 2020.3.0.200.0.

Container images, components, and evaluation license keys are available via the WRC's preview download site.

Community Edition containers can also be pulled from the Docker store using the following commands:

docker pull store/intersystems/iris-community:2020.3.0.200.0

docker pull store/intersystems/iris-community-arm64:2020.3.0.200.0

docker pull store/intersystems/irishealth-community:2020.3.0.200.

The offer of ZPM is growing daily and the short names and
acronyms of the offer are sometimes hard to understand and
also hard to type with my lazy fingers.

So I decided to have

• a listing with the descriptions from the repository,
• split in short junks to avoid backscroll,
• controlled forward / backward scrolling,
• the option to select my packages by number,
• to install or uninstall with limited typing.

It runs with do ^zpmshow

A snapshot from the screen:

USER>d ^zpmshow

1 analyzethis 1.1.4 -- not github --
2 apps.rest 1.0.0 -- no descripition --
3 bitmap-adoption 1.0.

I want to write the values that are stored in an array into the OBX 5 field.  The text in MyArray(1) will go in the the first OBX 5 field.  Then the text in MyArray(2) will populate the next OBX 5 field. 

My question is how do you format the Set > Action Tab > Value entry so that it pulls the data from MyArray(source.{PIDgrpgrp().ORCgrp().OBXgrp().OBX:SetIDOBX})

I know the array is ok, because when I hard code MyArray(2) in the Set > Action Tab > Value, then the OBX lines contain the correct element in MyArray(2).  When I drop source.{PIDgrpgrp().ORCgrp().OBXgrp().

Hello people!

I am Brazilian and I am starting to work with the latest version of CACHE, and I would like to know where I can see an example of a TRIGGER, I would like to validate the fields before writing the actual data in the database.

in advance, thank you very much! and sorry for any mistake in concordance in english

Hi Developers!

Now it's time for all Japanese speaking users of our community! 

We're pleased to announce the official start of the Japanese InterSystems Developer Community!

And let me introduce you @Minoru Horita and @Toshihiko Minamoto from InterSystems Japan as managers of the InterSystems Developer Community in Japanese!

Here are the main points you need to know:

Iris for health has a wizard or procedure to create a fhir database and expose as rest service?

Good morning all,

Could we please get some insight on what is possible (or what other organizations may be using) for tracking uptime for our HL7 engine?  We can use Activity Tracking to show how many messages went through, but are there any good canned reports (or queries) about the number of message failures or the amount of time that an interface was down?

We are using alerting to the team to know about not getting messages or if messages failed.  Has anyone created a report or dashboard against the Ens.Alert table or would you recommend elsewhere?

Hi,

Can anyone  point me to an example of a DTL & Class method that can pull a base64 encoded PDF out of a MDMT02 message?

This is really asking for two things;

- how to make a DTL that extracts a specific subfield of an HL7 2.3 message into a message of its own,

and

- how to transform an base64 encoded document into its original binary form for writing to a file.

I'd also love to see an example of an HL7 2.n MDM^T02 ==> HL73.ITK2 non-coded CDA

I've seen some snippets in the community Q&A, but I've not been able to find any examples either here, or in the documentation or training materials.

This article is a continuation of Deploying InterSystems IRIS solution on GKE Using GitHub Actions, in which, with the help of GitHub Actions pipeline, our zpm-registry was deployed in a Google Kubernetes cluster created by Terraform. In order not to repeat, we’ll take as a starting point that:

Until this week, my customer had Ensemble writing HL7 messages to my TCP listener, working fine on ageing physical servers (Windows Server 2003, Caché 2009). They had four app servers (app1, app2, app3 and app4) with an overarching DNS simply called "app".  Ensemble was connecting to "app:port", and it somehow found whichever of the four app servers my background listener was running on, and the interface worked fine for 10+ years.

Hello Community, 
I hope you're going well.

I am programming a daily reporting that will send by e-mail when people will add a dashboard as favorite by clicking on the star :

I asked Intersystems WRC on how to automatically generate a report with some line coding, but I heard there is no way to do this without a headless Browser.

I downloaded google-chrome to use the "--headless"  and "--print-to-pdf" function , to print the HTML content of my dashboard into a PDF.  ( I will use $ZF function to launch the generation ).

I have to implement a custom query result to be returned using the FHIR Bundle Resource.

I am a novice and not well versed in InterSystems yet so please excuse mistakes due to ignorance.

What is the shortest frequency of time I can set to have Cubes rebuilt.

Tell us your tips and tricks for using InterSystems products, and you may see yourself featured in a future newsletter! Check out the July newsletter from Learning Services to find out how.

Plus, tons of new videos, upcoming classes, and more. As always, subscribe to receive the monthly newsletter in your inbox! 

Hi Developers!

I'm pleased to present to you a new feature of Open Exchange - ZPM Package Manager support!

What's about it?

Hello
This is Shashank with Randstad. I am working on to fill Cache ObjectScript Developer role with our direct client in USA. Please let me know if anyone would be interested and can contact me through email: shashank.gundu@randstadusa.com
Thanks

Using the community edition of IRIS, how do I read the HealthShare and Trak doc?

Hi, what’s the syntax for picking up low/high cases?

I have tried

*.zip;*.ZIP

But, it’s not working any pointers much appreciated.

GA releases are now available for the first version (v1.0) of InterSystems System Alerting and Monitoring (InterSystems SAM for short)
  
InterSystems SAM v1.0 provides a modern monitoring solution for InterSystems IRIS based products. It allows high-level views of clusters and single-node drilled down metrics-visualization together with alerts notifications.  This first version provides visualization for more than one hundred InterSystems IRIS kernel metrics, and users can extend the default-supplied Grafana template to their liking.
 
V1.0 is meant to be a simple and intuitive baseline.

Hi,

 A device is sending me HL7 messages (ORM^O01)

the framing is set to "None"

and i get the following error:

3 Segments
Build Map Status = 'ERROR <EnsEDI>ErrMapRequired: Missing required PID element at segment 2 (PID)'
'ERROR <EnsEDI>ErrMapRequired: Missing required OBR element at segment 2 (PID)'
'ERROR <EnsEDI>ErrMapSegUnrecog: Unrecognized Segment 2:'PID' found after segment 1 (MSH)'

i seems that there framing chars in at the beginning and end of each segment

(in Hex)

 0b (MSH DATA HERE)  1c 0d  0b  (PID DATA HERE)  1c   0d   0b  (OBR DATA HERE)  1c 0d

i have tried all the Framing options of no

Hi Developers!

The InterSystems IRIS AI Contest is over. Thank you all for participating in our IRIS AI Competition!

And now it's time to announce the winners! 

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

Hi Community!

Please welcome the next video from Global Summit 2019 on InterSystems Developers YouTube:

⏯ Implementing FHIR Use Cases

It would be interesting if there is some recommended documentation about best practices using Healthshare for interoperability.

Also, some how-tos or frequently asked questions about ObjectScript.

Or event better, if there are experienced developers who would like to share some common habits on their work with Studio / ObjectScript, which are valuable to do the developing work better.

For example, How to get the XML of a class and write it into a REST operation:

...

Method X(pRequest As Mensajes.ServiciosGeneralRequest, ...){

set writer=##class(%XML.Writer).%New()
set status=wri

This is a sample to use %JSON.Adaptor class available in IRIS to produce a snapshot of your object.

The sample consists of 2 classes that are variations of what was known in Caché/SAMPLES as Sample.Person.
Be aware that the possibilities are limited by %JSON.Adapter and how you make use of it.

Once in place, you create some test data by Populate().
You select an object and take a snapshot.
You apply changes to your object and take another snapshot.
And see the difference.

BINGO!

GitHub

It's also an example of a customized SystemFunction extension (ZZISJSON) in Caché & IRIS
This time it is to be included in %ZLANGF00.mac

A JSON string is mostly imported from a file or over REST
You rely on a clean and compatible structure. This is the check.

required: ZPretty.mac

demo

USER>ZWRITE jsn  
jsn="{"Name":"Li,Robert K.","SSN":"672-92-9664","DOB":"1975-01-12","Home":{"Street":"986 Washington Blvd","City":"Boston","State":"PA","Zip":"95802"},"Office":{"Street":"6012 First Place","City":"Reston","State":"MT","Zip":"77739"},"Spouse":{"Name":"Avery,Zelda H.

t's also an example for a customized command extension (ZZJSN) in Caché & IRIS

This is the Caché version for fast JSON formatting but it also works in IRIS.
Requires package ZPretty
To allow parallel existence in IRIS this is named ZZJSN

see:

USER>ZWRITE jsn  
jsn="{"Name":"Li,Robert K.","SSN":"672-92-9664","DOB":"1975-01-12","Home":{"Street":"986 Washington Blvd","City":"Boston","State":"PA","Zip":"95802"},"Office":{"Street":"6012 First Place","City":"Reston","State":"MT","Zip":"77739"},"Spouse":{"Name":"Avery,Zelda H.