Question
· Nov 23, 2023
SQL Query in BPL

I'm pretty new to ensemble.I'm working on a BPL process where I need to retrieve a result set from an SQL activity, loop over the results, and call a web service. I'm having trouble passing the request parameter(Labtype) into the SQL query for the WHERE condition .Can any one suggest how to loop over the result set as well.Any suggestions on how I can achieve it?

0 7
0 268

I am using the event logger from CSP gateway with level "v9r" enabled, in order to dump the raw content of some HTTP requests.

I would like to decode the body response data, when it's in binary form. AFAIK the event logger will convert characters outside the 32-127 range (EBCDIC) to the "\xff" notation (where ff is a hexadecimal value). Here is an example :

0 4
0 275

Hi Community,

I am attempting to create a new table by executing a SELECT statement that involves joining multiple tables. However, I encountered an error during execution: '( expected, AS found^Combined AS.' I would also like to create a cube based on this SQL table. However, during the cube creation process, I am prompted to specify a source class, and I'm unsure which class to use as it requires an existing class. Could you please help me identify the issue with the table creation, and provide guidance on selecting the appropriate source class for the cube creation?"

0 1
0 90

Hi,

I am trying to connect to another server using %Net.HttpRequest.

I keep getting this error : SSL23_GET_SERVER_HELLO:unsupported protocol.

My guess is that the site I am reaching for uses TLS1.3 which is not supported in 2016, But I cant right now ask my client to upgrade.

Is it possible to override this ? install some kind of a patch or a more recent version of openssl on the server ?

Thanks

Amiram

0 2
0 116
Question
· Sep 20, 2022
Linux and links

If I create a link does root use it? (it’s in profile.d dir)

I'm trying to use a shortcut for a filepath as such: anyone have any thoughts?

PROCAUTO = /JRNDSK/ProcAuto_share

yet in the application it isn't recognizing it.

Here’s the scenario. (link is in place) that my manager thinks maybe an issue.

0 4
0 222

I would like to define an advanced filter within my pivot table that allows me to look at diagnosis codes, or at procedure codes - but I do not want to hard code values within the pivot table definition (get the %OR defined).

I would like to be able to allow my dashboard user to chose what specific diagnosis codes or procedure codes they are interested in. So for example one user may want to look for # of patients with cancer dx or patients who have had a radiation procedure.

How can I accomplish this OR feature using dashboard filters?

0 2
0 381
Question
· Feb 6, 2023
irissqlcli install

Hi,

I'd like to try out irissqlcli.

My server, that has IRIS installed on it, is SUSE (SUSE Linux Enterprise Server 15 SP1).

How do install this product from GitHub? Detailed instructions would be great!

It would be best if I can download the software from GitHub and then get pip to install from that downloaded file repo.

The recommended:

pip install -U irissqlcli

does not work and comes back with "

0 7
0 234
Question
· Apr 17, 2023
Refreshing Combo

Hi Guys

How can I refresh a dataCombo after saving a new element in it?

I've the following dataCombo and after saving a new element I would like to fresh and reload that data in it?

0 1
0 146
Question
· May 25, 2023
Using <IMAGE> sample

Hi Guys,

is there any sample I can use for Images, I'm just looking for a very simple one where I can have an upload control to upload images & image control to show them?

Thanks

0 12
0 168

We need to generate a PDF file from an HL7 message as it passes through an Ensemble production. Looking for examples, tutorials, documentation aligned to our scenario.

We are currently using Ensemble (so can't use InterSystems Reports at the moment). Thinking Zen reports...

We can get from HL7 to XML OK, following Introduction to InterSystems Health Connect - YouTube (see c.1:11:00-1:13:00)

0 1
0 97

Currently I have a program that is going to be used to compare global nodes between namespaces. Using nested FOR statements I am stepping through global nodes and comparing between the namespaces, if the global values are different I then parse the node comparing each delimited segment.

This is working.

I want to now be able to set what global I am in as a variable to expand on this concept.

Program architecture

0 3
0 210

Hello,

I have a problem attempting to store a base 64 encode stream into the OBX:5 field of a HL7 message, by using the StoreFieldStreamBase64 method.

I'm using a transformer to input the contents of a pdf within a stream container (Ens.StreamContainer). The output is a HL7 message (EnsLib.HL7.Message 2.5:ORU_R01).

The transformer is being used in a business process.

This is the code used in the transformer to encode the stream to base 64:

0 2
0 250

We have a machine that serves 4 instances of Cache on VMS systems, one of them is password protected and works fine as they all do. we decided we wanted something beefier and copied it to a server, well all but the one you have to login to works so 3 of the 4 do. and the odd part is I can no longer get to the management page from anywhere on any machine, http://localhost/csp/bin/Systems/Module.cxw I get a 404.8 error, I have tried adjusting security and same thing. and a server availability error.

0 4
0 214