I'm wanting to write a query in SQL that will return a row with a count for each day for a given month or year for a specific operation or configname. The following is a start but I'm not finding what I want in the documentation to parse out the TimeLogged field of the table. Nay help is appreciated.

SELECT count(TimeLogged), ConfigName
FROM Ens_Util.Log
where TimeLogged like '2021-07%'
and ConfigName = 'operation_Name'
group by TimeLogged

0 2
0 148

I'm close with this but I'm not sure how to grab JUST the GT1.3 data. I know I can do a substring but finding the 3rd | is a tad tricky. I've not been this deep in SQL for 15 years.

SELECT SUBSTRING(hm.RawContent, (CHARINDEX('GT1',hm.RawContent)), 50) as NameDesc
FROM Ens.MessageHeader as em, EnsLib_HL7.Message as hm
where em.Status = 'Suspended'
and em.MessageBodyId = hm.id

I expect it should flow like this...

SELECT UNIQUE SUBSTRING(RawContent, (FIND 3RD PIPE),(FIND 4TH PIPE) as NameDesc ....

0 1
0 206

I have vendors asking for verification that messages for locations are coming through to them. I can get generic ADT_A01 type of numbers in Activity. I'd really like to get some good SQL queries that can give me a count of MSH.4s (for example) for a day for X Operation. I'm not sure which table to look at for that information.

0 1
0 217

I'm trying to create a new Record Map but I keep getting a ZEN Exception error. I actually go this to work the very first time I did it and have a record map. But I need to do more.

I'm working on my local machine so I can grab a CSV (or txt in this case as it's pipe delimited) from the local directory. I pick the file I want to use but when I click OK i get a popup and the following error:

0 1
0 330

I'm trying to convert a CSV inbound to an HL7 MFN^M16 outbound. I know I'm using book information as the CSV but I don't think that matters. Please let me know if that's incorrect.

My service is reading the file in just fine and when I don't have a DLT transformer the raw message passes through to outbound file folder just fine. However, when I include a basic DLT that simply copies a couple of fields over I get the "Ens.StreamContainer" error. Everything also seems to be good in the Record Mapper.

0 4
0 2.6K