Hey I would like to INSERT mulitple rows to 1 table.  I need to intersystems cache equivelant for 

INSERT INTO table_name (column_list)
VALUES
    (value_list_1),
    (value_list_2),
    (value_list_3);

Have tried this post https://community.intersystems.com/post/how-execute-multiple-query-or-script-sql-management-studio
but still got an error

I have a table with 4 column: MRN (primary key), Name, DOB, and Gender. I want to bring in the values on all of the columns into a DTL. Currently, I declare variables for each of the columns and using 3 select statements.

  &sql(SELECT Name INTO :Name FROM osuwmc_RQGPatient.DataTable WHERE MRN=:MRN)

  &sql(SELECT DOB INTO :DOB FROM osuwmc_RQGPatient.DataTable WHERE MRN=:MRN)

  &sql(SELECT Gender INTO :Gender FROM osuwmc_RQGPatient.DataTable WHERE MRN=:MRN)

Is there a way to do this in a single select statement?

Dear All, 

I am currently working on a project to record ORU^R01 into a global for a particular set of tests.

I have multiple OBX repeats that need to go into a specific fields withing one row/ record on the global.

I am having trouble finding a way to either count or loop though the OBX's correctly in ObjectScript often with the counter being undefined.

I have done this this way, as I am building upon an existing class to populate this global.

The latest iteration of my obx looping code is below:

// handle repeating obx's by setting count of value    
            set segcnt = pMsg.SegCountGet()
            ///count no of obx repeats
            for segmentIndex = 1:1:segcnt{
               IF pMsg.FindSegment("OBX",segmentIndex,.sc)='"",$$$ISOK(sc) {
                    set obxcnt = obxcnt+1}
            }
            
            for obxIndex=1:1:obxcnt {
                    // Check for OBX-3.1 = "CodeA" f
                    IF GetValueAt("OBX("_obxIndex_"):3.1") = "SARS" {
                        set CovRes.Ward = "CodeA"
                        set tResultAB = $ZSTRIP(GetValueAt("OBX("_obxIndex_"):5(1)"),"<>W")
                      IF tResultAB = "Positive" {
                            set CovRes.TotalAbPositive = 1
                       }
                       elseif tResultAB = "Negative" {
                            set CovRes.TotalAbPositive = 0
                        }
                    }
                    // Check for OBX-3.1 = "CodeB" 
                    elseIF GetValueAt("OBX("_obxndex_"):3.1") = "CodeB" {
                        set tResultAB = $ZSTRIP(GetValueAt("OBX("_obxIndex_"):5(1)"),"<>W")
                        If tResultAB = "Positive" {
                            set CovRes.IgGPositive = 1
                        }
                    }

Some time ago I got a WRC case transferred where a customer asks for the availability of a raw DEFLATE compression/decompression function built-in Caché.

When we talk about DEFLATE we need to talk about Zlib as well, since Zlib is the de-facto standard free compression/decompression library developed in the mid-90s.

Zlib works on particular DEFLATE compression/decompression algorithm and the idea of encapsulation within a wrapper (gzip, zlib, etc.).
https://en.wikipedia.org/wiki/Zlib

About regulations

Personal data privacy regulations have become an indispensable requirement for projects dealing with personal data. The compliance with these laws is based on 4 principles:

1. Compliance with the rights of the holder of personal data;
2. Governance of personal data assets;
3. Privacy by Design and by Default;
4. Data protection.

Ready Computing is a full-service IT firm, specializing in software development and data exchange solutions within the healthcare industry.

We are looking for a highly-motivated staff that can guide clients in developing their healthcare IT strategy and back up that guidance with high quality technical work. Solution Consultants work directly with clients, IT vendors, and internal teammates to deliver integrated health solutions. Solution Consultants focus primarily on deploying high volume interfaces and interoperability software.

I've got a REST service that I can access via a browser. I can get it to take HTML tags as data and display it back to me (so I know the REST part is working). So if I send it this:

http://MyServer:57772/TestArea/rest/TestQuery?UUID=1&RTX=RTX123456&CareType=Palliative
 

Then I can pick out the data and tell it to display in the browser, which is great but what I really want to do is put the data into a string and send to a business process that will do lots of looking up but eventually return a URL that my REST service will then redirect the browser to.

Hi All,

I have created a custom method into persistent class to call vendor Rest API from Ensemble that is working fine through Terminal, but my concern is:

I want to call only if  Error, Warning or Alert are generated. Is there any way that it would call automatically to send that Logs records through API or from where I need to call custom method of persistent class.

I also tried to put that persistent class method from Ens.Util.Log class but it's calling multiple time automatically.

Thanks,

Asif

Sometimes you need quickly and easily import data into IRIS. For this, an IRIS import manager has been developed.

This application allows you to import JSON data and also provides a really simple interface for transferring data from MongoDB collections to IRIS globals. It has never been so easy.

Let's look at examples.

Import JSON

Suppose we have data in JSON format and we want to import it into IRIS. To do this, you just need to specify the global name and insert the data. After import, you will see the imported data. If global exists data will be overwritten.

Globals as a Graph Data Structure in Python

How to use the IRIS Native API + Python to see globals as a Graph Network Chart.

Iris Globals

Reading the documentation these topics are related to globals:

• A global consists of a set of nodes (in some cases, only one node), identified by subscripts.
• Each node can contain a value.
• ObjectScript includes functions to iterate through the nodes of a global and quickly access values.
• A global is automatically stored in the database. When you assign a value to a node of a global variable, the data is written immediately to the database.

Hi Community!

This week is a voting week for the InterSystems IRIS Native API Programming Contest! We have 8 applications — so you have a set of applications to choose from!

How to vote? This is easy: you will have one vote, and your vote goes either in Experts Nomination or in Community Nomination.

Hi Developers,

Please welcome the new video, specially recorded by @Renato.Banzaifor the InterSystems IRIS Native API Programming Contest: 

⏯ IRIS Python Suite: Installing Running and Using

Hello,

How can I use ISC_DATA_DIRECTORY once IRIS runs inside a container? Some background...

We plan to deploy multiple containers running the same Health Connect IRIS Interoperability production in containers. So far we use docker run to start a container with ISC_DATA_DIRECTORY individual per container inside a efs that gets mapped using -v.

Hi All
This is the index to a series of articles I hope to create over the coming months.

ZEN and ZEN Mojo are no longer being actively developed by Intesystems - this is a great shame as it is a fine product that works so well for business applications.
However ZEN is a 15 year old product and I need a path forward to replace the ZEN UI with a supported development framework.

This article is an index of the other articles I have, or plan to write. - the articles will be subject to change as I develop my thoughts and climb the learning curve.

I'm trying to sign an xml but this is showing an Id attribute in the Signature tag and the xmlns attribute is not appearing.

This is the xml generated:

SET = ##class

Hi everyone! If it doesn't bother you, could you help me teach my bots to talk?

Open my chatbot here: Help my chatbots to talk!

What? Aren't your chatbots smarts?

Smart isn't the best term for this scenario. They are trained but with little data! Most of chatbot solutions uses Machine Learning to create a way to talk with people and Machine Learning needs one important thing to performs well: DATA. 

How does it work?

A simple way to explain: imagine someone who has a brain but dont have any experience in his life he just born.

Hey Developers,

Here is a digest of the InterSystems Data Points Podcasts in May 2020:

What is the OData

OData (Open Data Protocol) is an ISO/IEC approved, OASIS standard that defines a set of best practices for building and consuming RESTful APIs. OData helps you focus on your business logic while building RESTful APIs without having to worry about the various approaches to define request and response headers, status codes, HTTP methods, URL conventions, media types, payload formats, query options, etc. OData also provides guidance for tracking changes, defining functions/actions for reusable procedures, and sending asynchronous/batch requests (source: OData.org).

Last time we deployed a simple IRIS application to the Google Cloud. Now we’re going to deploy the same project to Amazon Web Services using its Elastic Kubernetes Service (EKS).

We assume you’ve already forked the IRIS project to your own private repository. It’s called <username>/my-objectscript-rest-docker-template in this article. <root_repo_dir> is its root directory.

Before getting started, install the AWS command-line interface and, for Kubernetes cluster creation, eksctl, a simple CLI utility. For AWS you can try to use aws2, but you’ll need to set aws2 usage in kube config file as described here.

Hi Community,

Please welcome the new video, specially recorded by @Robert.Cemper1003for the InterSystems IRIS Native API Programming Contest: 

⏯ WebSocket Client JS with IRIS Native API as Docker Micro Server

Hey Developers,

New "Coding Talk" video was specially recorded by @Yuri.Gomesfor the InterSystems IRIS Native API Programming Contest: 

⏯ OData Server for InterSystems IRIS

Hi Community! I need your advice.

The method below is 6 times slower on production server than on developing machine:

ClassMethod runme4()
{
    s cnt=615210
    s st=$zh
    for i=1:1:cnt {
        s p=##class(digi.packet).%OpenId("packet||5237")
        w:p="" "not found",!
        k p
    }
    w $zh-st,!
}

BUT the server is 6 times faster if OpenId replaced with simple read of a large global (s p=^someLargeGlobal). Any ideas what makes OpenId so slow only on the server?

And another question: I wanted to profile the code with  %Monitor.System.

Hi

While adding new patient getting this message, any idea what could be the problem

Hi Community,

The new video from Global Summit 2019 is already on InterSystems Developers YouTube:

⏯ InterSystems Health Connect: New and Next

InterSystems has corrected a defect that can lead to missing resource data in FHIR search results.

This problem exists for:

• HealthShare Unified Care Record 2020.1.0 b7015

This defect occurs due to an incorrect resource being deleted from the search index. Subsequent FHIR Resource requests against the FHIR Repository may return incomplete results due to that missing index. Any type of FHIR resource data can be lost, and depending on when the defect occurs, the same FHIR request could return different result sets.

This defect only affects FHIR resources at the HealthShare ODS.

InterSystems has corrected a defect that can cause FHIR searches to return incomplete results. The defect manifests because a FHIR update interaction deletes an incorrect resource from the search index. Although the data still exists in the repository, subsequent searches may return incomplete results due to the missing entry in that index.

This defect affects InterSystems IRIS for Health 2020.1 and HealthShare Unified Care Record 2020.1. (In HealthShare, this defect only affects FHIR resources at the ODS.

Hi All,

I am writing this article to tell about the application "CRUD-GLOBALS-IRISNATIVEAPI-JAVA" which is developed as part of "InterSystems IRIS Native API programming contest". The intention of this application is to manage the Globals which are in IRIS instance through java program using IRIS Native API. To use this application basic knowledge of CACHE Globals structure is required.

In this application as of now we  have options to Create,View  Globals and Data Search in Globals. Update and Delete will be added in next releases.

In this article I'd like to share with you a phenomena that is best you avoid - something you should be aware of when designing your data model (or building your Business Processes) in Caché or in Ensemble (or older HealthShare Health Connect Ensemble-based versions).

Hi Developers!

We are pleased to announce the next competition in creating open-source solutions using InterSystems IRIS Data Platform!

Please welcome the third InterSystems IRIS Online Programming Contest for Developers!

And the topic for this contest is InterSystems IRIS Native API.

The contest will last three weeks: May 18 – June 7, 2020. 

A lot of developers like to work with Studio and have been looking into source code version control such as GIT or into enabling modern development workflows like CICD or DevOps processes.

This article describe an elementary solution to get you started in CICD and DevOps, even if you are not yet ready to move to Atelier or forth coming VS Code approach which enable client side source code version control.