Hey Community,

We are really looking for your feedback on a new offering - HealthShare Message Transformation Services. 
It went live on AWS Marketplace where you can try it for free!

We launched a related challenge on GM where you can get points for giving it a try and a "thank you" prize to everyone who leaves feedback in comments to this post.  


0 0 32

When I'm asked questions about SQL, I like Intersystems staff at the WRC, generally ask about the Query Plan.  My feeling is that even before you run a query you should examine the results of Show Plan to confirm that the code is going to give me the results in the manner I would expect.  If I expect it to leverage an index and I see that it is not then I go back and look at what I might have done incorrectly and try to re-write the query to get the index behavior I'm looking for.  To that end, there's a poll below to ask you if think moving the Show Plan button as the first button would be

0 0 47

Hi! I am working on a project where I use record map to transform a flat file and split it into two output text file and in the future will need to split four output files.

I only want to use one  target business operations instead of multiple. Is there a way to set the output file and the target folder path in my business process class?

Any advice on how I can achieve this or is this possible? Thanks!


0 5 75

Hello everyone,


I have a question and if you have some code, it would be lovely.


I had to create a connector which is biredictionnal. What does I mean by this?

I have to send ADT to an certain ip +port by TCP but I have to receive query A19 by this same ip+port.

Is it possible to create such a connector that can do both?


I read about pipe but i think it's too low-leveled .






0 6 75

Hi InterSystems Architects,


Please may I know the relationship between 

1. Menus, Workflows, Workflow Items, Components, Code Tables, etc 

Detailed relationship diagrams, how each element in each of the above are related to another. 

2. When I extracted the data. I see ID number, but they aren't unique or related. I wanted to build a relationship between them myself in the absence of documents but I am missing the critical unique primary key of each and how they are referred in another table.

1 2 59

Hello All

I'm running into an issue performing UPDATES that I'm not getting on INSERTS. It's probably obvious, but I'm just not seeing it and could use a little help.

I'm going over an HL7 message and depending upon varying criteria, the relevent variables will get items added to them like the following:

Set patientId = pRequest.GetValueAt("PID:3")
Set sqlColumns = sqlColumns_",patient_id"
Set sqlValues = sqlValues_",?"
Set par($i(p)) = patientId

After compiling the variables, I check to see if accession number is found in the table.

0 14 148

Hello All,

InterSystems Certification has designed another certification exam and we need input from our community to help validate the exam topics. Here's your chance to have your say in the knowledge, skills, and abilities that a certified InterSystems CCR Technical Implementation Specialist should possess. 

Here's the exam title and the definition:

InterSystems CCR Technical Implementation Specialist

A development professional who:

0 0 121

Hi all,

is there a way to remove a specific property path from a DICOM document created within Ensemble/IRIS for Health etc. I had a look at class EnsLib.DICOM.Document to see if there is something like RemoveAt.

The reason for my question resides in the need to filter certain fields for specific DICOM devices. Maybe you have an idea?

best regards,

0 2 39

Hi anyone has created the user roles for UCR pls share details like if we want to create following roles what access rights should be give to each role.

UCR Admin - This user can stop/start productions, can enable/disable services, can run sql queries, can make changes in facility registries, assigning authority and other configuration.

UCR Developer - This user can add new services in the production but can not make any change in the registires and other configuraiton

2 0 66

We need to upgrade from Healthshare 2016.2 to HealthConnect latest but we are too far behind the current version to do an upgrade in situ.

So I need to create a new instance of HealthConnect and the copy across all the database definitions, namespaces and classes.

I know its possible to script this stuff and pull all the definitions out of the old Healthshare system and then apply them to the new HealthConnect instance.

0 3 85

(2021.1.0 isn't an option in the Product dropdown, but that's the version of HS I'm asking about!)

In the past I've used HS.Util.Installer.InstallBusDemo() to set up a local HealthShare environment (registry, edges, access gateway, etc.)  I don't see an equivalent in HealthShare 2021.1.  I tried importing the bits and pieces from a lower version but always seem to be missing something.  Is there an equivalent utility to do a local setup in HS 2021.1?




0 2 74

I've poked through the class documentation and globals and I can't seem to find what I'm looking for, namely a mechanism that will give me the PropName key and value for each of the Items in an EnsLib.HL7.SearchTable definition. Is there some sort of query that will turn the list of Items in the XData SearchSpec section into a key/value pair of some sort?

For example:

0 1 49

I am trying to populate a table using the sql Data Import Wizard. The input file is a tab delimited text file. But the import keeps failing with a 104 error showing validation for the columns which use %Library.TimeStamp and %Boolean datatypes is failing. Yet when I insert values into the table through a SQL insert command, the values get saved correctly in the table.

For the TimeStamp format in the wizard form, I am choosing YYYY-MM-DD-HH:MI:SS because  there was no option for this format: YYYY-MM-DD HH:MM:SS. 

0 4 65

I am working on tweaking our current patient load process. The roster input is in text pipe delimited format, parsed out and transforms it to a standard HS.Message.PatientSearchRequest, and send to business process for patient matching. Result is transformed into a standard ADT HL7 message using EnsLib.HL.Message class. I would like to know if there is another class I can use that will transform my output to a text flat file pipe delimited instead of HL7 format? any advice on how to do this is greatly appreciated.



0 2 100


We have a need to track Database changes over time - down to the SQL level of granularity if possible. Such as: User xyz runs routine ^abc and we get something similar to a changelog that tells us: table A had this value updated, insert, update etc....

Is that possible using IRIS level tools (Audit Log, Journal File, etc...) , is there a way to convert the global sets and kills from the journals into SQL level changes?


1 3 150