I'm doing a query in SQL and I need to sort my data by some non-repeated field.


Unfortunately, my data is grouped in a way that I cannot guarantee that any column will not have repeated data, so one solution would be to take the row number.


Also, the Cache is not accepting Row_Number () in my querry and I would like to know if there is another solution to return line numbers or some way to add this function to the Cache.


Best regards.

0 7 424

This is the first InterStstems  programming contest that we participated in! Come check out and vote for us!

The overbooking management system combines the unique conditions of the hotel, such as room prices, order channels, customer needs (etc...). System uses machine learning algorithms (such as: KNN/ES-RNN...) to accurately predict the daily no-show and occupancy rate of the hotel, and further combines with the revenue equation to find the best largest room sales volume, which can significantly increase the hotel marginal revenue.

0 2 97



I am looking for examples of implementations of a more robust forgot username and forgot password implementation.  Does anyone have one to share, even just a link to the page so I can see how it works, or screenshots?  We would like to implement a secure system for requesting username and resetting password.

0 2 94

Data transformations can be changed in Management portal, but the modifications are not synced with visual studio code. Classes are synced from VSCode to Iris. VSCode can take care of the git repository.

I am curious to know how people are developing data transformations on Iris with VSCode? Are you editing the DT classes with VSCode and forget about the UI? Are you exporting from management portal the files to VSCode directory? Are you using a source control hook?

Thank you


0 1 207

Hi Team,

I have a requirement to delete the Ensemble interfaces , as per User request. I would like to write a routine for that and once I execute, it should remove the interface components through code.
Could you please provide code samples for the following actions ?

  • Deleting an individual rule from a rule class
  • Deleting a class from Ensemble
  • Deleting a Host (Service/Operation/Process) from the Production.

Appreciate the help.



0 6 124

Hi everybody,

Is there any functionality I could use that triggers real time user-defined code on certain audit events? Right now I am interested in triggering such code on a routine modification event, like the one below. I do know how to access this record programmatically, via %SYS.Audit.

Thanks in advance,

0 8 148

First of all thanks for your time and help reading this question:

We would need some help:

The use case is: to add a rule inside a EnsLib.HL7.MsgRouter.RoutingEngine, where we iterate in a EnsLib.HL7.Message to find a specified value inside all OBXs segments. It should return a Boolean

Is there any recommended way, or standard function inside Ensemble, that we could use, without having to develop a new function?


We have read:

0 5 105


I am trying to figure out if we can extend a business process in IRIS. My Use Case is that I am developing RESTful Interfaces and my each REST Interface needs to go through certain processes before getting to the actual action.  

e.g. I have 2 REST Interfaces, GetPatient and GetEncounter. Both of these need to invoke "GetToken" Business Operation to go to the Authentication server to get an authentication token before they go ahead and hit the Business Operation to Get the data i.e. Patient or Encounter.  

1 1 85

We are developing some containarized cloud application level iris instances and using CPF Merge to do a lot of the initial buildout for the iris instance (i.e.  create databases, namespaces, map globals/routines, ecp setup, etc...)

I am trying to figure out how to get package mappings into a namespace config, via cpf merge if possible... ?


This is the document I am working from to develop the cpf merge file -

0 0 75


When for any particular reason I need to update a record and don't want to pull the triggers, the keyword %NOTRIGGER can be used. But I've been trying to do the same when I change the row using the object approach, but I can't find it. Anyone knows if it's possible to avoid pulling triggers when working with objects?

Sadly, the utility "DISABLE^%NOTRIGGER" doesn't seem to exist ;-)

Thank you,

0 2 103


We would need some help,

Our aim is to send an image as binary data using a REST Service

Currently we do the following:

1 We get from the external system a binary image in our REST Operation

2 We encode it to Base64

set linea=""
    while (tResponse.Data.AtEnd = 0) {
        set linea = linea_$system.Encryption.Base64Encode(tResponse.Data.Read(57))

3 We send it to the Process in a Response Message:

0 4 285

Use case: small in-house hospital systems that query patient demographics via SQL.  The new PAS being implemented in the near future will only support query/response via HL7.  SQL access is available but intended for reporting so up to 24 hours behind.

Probably the easiest option is to set up a database in Ensemble and keep it up to date via standard ADT feed.  This is going to have quite a large footprint and has a risk of getting out of sync.

0 0 106


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 168


When wanting to use VS-Code for server-side editing.. - In VS-code I can right click on a server item (eg a class) to see a set of menu options including 'Server Source Control... ' and 'Server Command Menu...' at the bottom.

I noticed that these options are somewhat connected to my server-side source control hooks class that inherits from %Studio.SourceControl.Base, however, I am seeing different behavior between my custom subclass of this, and, the provided %Atelier.SourceControl subclass.

0 1 216

So I've got the IRIS AMI spun up in AWS EC2; it seems to be running fine.  

I've added an EBS volume to it for persistent storage, and now I'm pondering how to make it actually do something useful.  

What's the best way to do deploy code to this instance?  I can think of a few ways to do it, but what's the least painful way?  Push my code to an S3 bucket and figure out how to load it at system start?  Github project?  

0 2 82

Hello all,

I have a problem where one of our 3rd party systems is only able to accept HL7 messages with UTF-8 encoding but the originating messages have Windows 1252 encoding. Does anyone know a way in which I can change the encoding for the entire message from Windows 1252 to UTF-8? I have only been able to find the CONVERT method to change individual charachters but we would like to change the entire HL7 message encoding.


0 1 114
alvin tao · Mar 5

What are the differences among HealthShare Health Connect HL7 Interface Specialist, InterSystems IRIS Core Solutions Developer Specialist and HealthShare Unified Care Record Technical Specialist these 3 certifications? And what are the prerequizites for these 3 exams?

0 3 142
Jian Li · Nov 20, 2020
validate logon

When I log in to the management portal page, I want to know where to verify whether the user name and password information I entered are correct, and how to handle it in the program. Is it handled through routine? Or is there a Dispatch Class to handle?

0 0 112