Hi everyone, how do you run multiple quires?

I have tried couple of different ways, but not working.

 SET sql = 2

    Set sql(1) = "UPDATE QUERY"

    Set sql(2) = "UPDATE QUERY"

    Set sqlStatement=##class(%SQL.Statement).%New()

    Set sc1=sqlStatement.%Prepare(.sql)

    If $$$ISOK(sc1)     {

       Set tResult = sqlStatement.%Execute()    





0 4
0 108

Hi Guys,

I know that there a way to view global content from the Terminal rather the SMP but I can't remember the command, I think it's something like D ^Global or something !?


0 6
0 231

Hi everyone,

We are trying to verify a signature against a certificate without success.

Apologies in advanced if my post lack info.

I've added the cert under the X509 credentials under the management portal (alias Cert).

The code snippet that we are using to verify the cert:

0 4
0 188

Hi Guys,

I'm using the below code to export to excel and it's working fine for one client but not for another and both clients are running the same version of IE 11.

for the second client the code generates an empty xlsx file and when I try to open it it says file corupted although data exits in the resultset, so is there a flag or setting needs be done in the client server or IE?    


0 1
0 173

I have been struggling trying to understand "Response From" and "Response Target Config Names" as I am trying to track down Orphaned messages.  I have noticed that when a Business Rule, or Business Process sends to a File Based Operation, there is always a NULL value response being returned. I am thinking these NULL values are causing some of the orphaned message problems we are seeing.


0 2
0 152

I have a Business Service that reads a file from a folder and sends it as a string to a Business Process. In the business process, I need to add a string to the end of the file string that is coming into the Business Process. I am trying to do this in object script in studio and I am struggling to figure out how to add the string to the end of the other string. I am still new to studio and object script I have been reading up on the documentation and I am not sure what is the best way to accomplish this.

0 6
0 176


How do I run a CSP page from within VS Code.

Secondly I have installed an extension called "Live Server" which will run .html pages within VS Code. Have any of you made use of this extension and if so can you specify that .csp pages are html pages?

If I press F5 in VS Code (just as you would in Cache Studio) in order to view a csp page when I press F5 in vs code it tries to open


without the csp page name

0 6
2 484

Hi all,

I am looking for a best practise approach for providing an ITI-41 based webservice to allow a subsystem to send a provide and register document set transaction via webservice route the request to a registry and loop back the response from the repository to the originating service. Since we need to use Ensemb le 2017.2 I am looking for a best practise to takle that reuirement. As for health connect I could prove a webservice wich supports the named IHE transaction and route it to the registry quite simple. Anyway how would you cope with this requirement under Ensemble?

0 1
0 79
Rochdi Badis · Apr 10
SQL query confusion

Hi Guys,

I'm a bit confused where if I run a query trough SMP I don't get any result which should be true but if I run the same query from a classmethod I get a query result which shouldn’t be even if I pass any gibberish parameter into my class method because I'm sure there should be any data? see attached  



0 7
0 145
Rochdi Badis · Oct 14, 2021
Lock the Modal View

Hi Guys,

I'm using a Modal Group but whenever I click outside it the Modal gets minimised, so How can I change the view so that whenever pops up the view get locked until I'm finished with my modal then click exit to endModal ?




0 3
0 198

Hi Guys,

I've the below tablePane and for some reason when it's populated always the last row is selected by default, I've many tablePanes defined the same way but none of them has the last row selected when populate, so not sure why this grid is doing this? 

0 3
0 124

Hello Community,

I am still pretty new to Ensemble, Cashé, or ObjectScript. My question is this how can I tell when a file was finished and read fully? Currently, I have an EnsLib.FilePassthroughService reads a file from a designated file path and moves it to an archive file path. I need to set up an alert or a notification that can tell me once the file has been read in its entirety and has been moved out of its current file path.

0 3
0 83

Hello communty.

I searched a way to transform a HL7 Message to Persistent. I found a way how to create Data Transformation from Mangment Portal -> Data Transformation Interface. But my task is to create somthing similar to that tool in my web site interface. And the question is: Is There way to create something like new instance of Data Transformation class "Ens.DataTransformDTL" using object script?

Thank you!

0 2
0 77

Good morning,

We would appreciate your support:


Developing an integration to perform a "Query / Retrieve" circuit with DICOM medical imaging studies, we would need the following:

Options of invocation of the DICOM TCP service that has been published for this integration, alternatives to the command line option.

Specifically we have read: Receive DICOM document with an embedded PDF and metadata.

0 3
0 124
Smythe Smythee · Mar 30
Data transformation

Hi Team,

I am trying to call  Datetime in CUSTOM.Training.Functions class please refer the below line.

<assign value='##class(CUSTOM.Training.Functions).DateTime(source.{PIDgrpgrp().PIDgrp.PID:7.1})' property='target.{PID:7.1}' action='set' />

My Datetime method 

ClassMethod DateTime(DateTime As %Integer)
Set Year = msg.SetValueAt(,"PIDgrpgrp().PIDgrp.PID:7.1","set")
Q Year

0 3
0 101