Hi Community,

I seek your assistance for below scenario.

Scenario-1: How to add filter or where clause while displaying data with listing fields ( I have not used Custom SQL listing to display this data).

For below table, I have created a Cube Student and I have created listing fields of the columns mentioned in the table. Also I have created the pivot and I am able to create the same table as shown below.

0 0
0 27


In Studio there was a function to open and edit *.Lut and *.HL7 files.
Is this also possible in VSCode? If so, how must this be set?

Kind regards

0 0
0 24


I'm migration an existing integration to InterSystems. The upstream (external) system calls a JSON web service hosted in the interface engine, which converts the JSON data received to an HL-7 messages to send to the downstream system. I'm looking for direction and example of how to do the equivalent in InterSystems, so the the upstream system only has to modify the URL of the web service they call.

I suppose in IS we'll need to create a business service that is a JSON web service? How to access the JSON data (parameters in the web service call) in the Transformation?

0 0
0 22

A new source is sending us CCDs with templates in the structuredBody section that are either just being ignored or being saved in the wrong data type. Ex notes being saved under the Encounters fields. We would like to use the Notes.xsl (out-of-the-box) to transform a certain template section into a Document SDA. Could you tell me how that can be accomplished?

0 0
0 5