SQLBuilder is a flexible and powerful SQL query string builder for InterSystems IRIS,

With SQLBuilder you have nice and clean object oriented methods, instead of having to use concatenation and substituition to generate dynamic queries.

A Dynamic SQL without SQLBuilder

A Dynamic SQL with SQLBuilder

The aim of my question is to achieve this :

• User with authorization :

• User without authorization :

You can notice that some information of the PID segment are obfuscated.

I don't know execute witch one? 

Preview releases are now available for the 2020.4 version of InterSystems IRIS, IRIS for Health and IRIS Studio. As this is a preview release, we are eager to learn from your experiences with this new release ahead of its General Availability next month.

Caché  2018.1.4 and Ensemble 2018.1.4 maintenance releases are now available.   

Full product installation kits can be downloaded from the WRC Software Distribution site.

Hey Developers,

Don't miss the new exciting promo video from our Brazilian developers on InterSystems Developers YouTube:

🍿 Promo video + Screencast for No Project Mess By IRIS

Hi 

Has anyone used Health Connect/Ensemble to receive results directly from POCT devices (Glucose monitors etc)?

I've been looking for information on the POCT01-A  protocol, and as far as I can tell it is a HL7v3 XML schema, I should be able to get results from these devices, though I expect I need a webserver endpoint. (though I can't find any reference in the Health Connect documentation)

Does anyone have any knowledge of this?

KR

Stephen

EDIT:  from the silence I'm wondering if this in normally handed off to specialist middleware?

Hi, I am new to IRIS and We are planning to setup a CI pipeline on AWS VM deploying the iris data platform container. I am trying to find out which folders needs to be inside the source control and where (exact folder) the updated code needs to be pulled in the container. I would be much obliged if anyone cant point the CI CD related documentation.

Thanks,
Raj

As we all well know, InterSystems IRIS has an extensive range of tools for improving the scalability of application systems. In particular, much has been done to facilitate the parallel processing of data, including the use of parallelism in SQL query processing and the most attention-grabbing feature of IRIS: sharding. However, many mature developments that started back in Caché and have been carried over into IRIS actively use the multi-model features of this DBMS, which are understood as allowing the coexistence of different data models within a single database. For example, the HIS qMS database contains both semantic relational (electronic medical records) as well as traditional relational (interaction with PACS) and hierarchical data models (laboratory data and integration with other systems). Most of the listed models are implemented using SP.ARM's qWORD tool (a mini-DBMS that is based on direct access to globals). Therefore, unfortunately, it is not possible to use the new capabilities of parallel query processing for scaling, since these queries do not use IRIS SQL access.

Meanwhile, as the size of the database grows, most of the problems inherent to large relational databases become right for non-relational ones. So, this is a major reason why we are interested in parallel data processing as one of the tools that can be used for scaling.

In this article, I would like to discuss those aspects of parallel data processing that I have been dealing with over the years when solving tasks that are rarely mentioned in discussions of Big Data. I am going to be focusing on the technological transformation of databases, or, rather, technologies for transforming databases.

Hi Community:

How did Credit Suisse, the VA, and UC Davis advance their digital strategies during the pandemic? Find out on Day 2 of our first-ever InterSystems Virtual Summit. Plus, you’ll hear from our heads of Client Services, Healthcare, and Data Platforms on the ways we’ve adapted, innovated, and built new solutions to help you weather any storm ahead. 

To join us: 

This year's Virtual Summit has more content around Analytics and AI than ever before. We've made this quick video to guide you through the program and put things into context with respect to InterSystems overall strategy for Data & Analytics.

Hi,

I am stuck with simple logic. I have a below string 

set a="<Name>ABC</Name><RollNo>45</RollNo><Name>XYZ</Name><RollNo>66</RollNo><Name>xyz</Name><RollNo>89</RollNo>"

I need logic to replace the values of roll no with "***". Is there any single command which can help in this scanerio.

I need to store this value in database after replace.

Thanks

Hello every one, 

I am a rookie and i am willing to gain some experience on IRIS for Health by doing some development. 

I went through the website and found only an online development environment. 

But I want to take it a step further ahead bu downloading the software for my own and trying something new. 

But, unfortunately I did not find a link to download the IRIS for Health.

I would be pleased if there is any one who has the link to help me out with it. 

Hoping to hear soon. 

Regards. 

Stay Blessed.