All
Accepted answers
Edward Jalbert · Jun 10, 2022 go to post

Thanks David. I was able to use the info from the doc an run a simple query on it.

Edward Jalbert · Jun 1, 2022 go to post

Not sure if this has any value, its pretty primitive. 

You might be able to do simple query operation and write the RawContent out to a file. 

Rough sql sample

SELECT top 10 *
FROM EnsLib_HL7.Message
where DocType like '%ACK%'
and RawContent like '%MSA|AE%'

Edward Jalbert · Oct 2, 2021 go to post

Thanks Jeff,

I did try using <1 but will try =0.

I was able to get around the error by placing the " ' "  not outside the statement.

'(..Length(source.LABRSLTNUMRSLTVAL)>1)&&'(..Length(source.TSTRLTVAL)>1)

Thanks,

Ed

Edward Jalbert · Jul 2, 2019 go to post

Jeff,

Thanks so much for the quick response.  I will take a look at the Message Viewer.  Lucky in a sense that we provide the number I am searching on in a seed file to the sender, hopefully that will help with the dups.

Thanks again for the direction..

Ed

Edward Jalbert · Oct 5, 2018 go to post

Thanks Evgeny,

The link did not come through.

Is there any articles you are aware of in setting up a scenarios or is it in the article?

Thanks again,

Ed

Edward Jalbert · Oct 5, 2018 go to post

Thanks Kate,

At the time of the post we were not using HSPI.  We have an MPI solution and were needing to call out via proxy to query the solution.

We are in the process now of leveraging HSPI.

Thanks,

Ed

Edward Jalbert · Jan 8, 2018 go to post

I would be interested in your approach.

I do not have the latest greatest for VISIO but it looks like in the latest release there is a Data Visualizer, which would allow you to map from Excel to Visio.

Preface I am new to InterSystems so there maybe a way to automatically produce the system documentation like some of the other engines out there.