0
1095
Question Jenna Makin · Oct 27, 2016

Ensemble Event Log

#Ensemble

Hi-

I was wondering whether or not the Ensemble Event Log was accessible using SQL?  If so, what schema and table would that be contained in?

Thanks

Discussion (4)1
Log in or sign up to continue

Comments

Jenna Makin · Oct 27, 2016

The event log is stored in the table Ens_Util.Log 

0
Tirthankar Bachhar · Oct 27, 2016

I would suggest to look at both the below classes,
Ens_Util.IOLog, and Ens_Util.Log

0
Jenna Makin  Oct 27, 2016 to Tirthankar Bachhar

Thanks Bachhar, 

Expanding on this a bit, we also have the need to be able to query the message store for messages we have sent/received from a given interface.  These are all HL7 messages, which means they are stored in EnsLib.HL7.Message. 

I'm assuming there is a way to correlate a message in EnsLib.HL7.Message with either Ens.MessageBody or Ens.MessageHeader where regular Ensemble messages are stored.

What would be the proper way to correlate these?  I looked at the fields in EnsLib.HL7.Message but don't see anything that stands out as obvious connection between the two tables.

0
Jenna Makin  Oct 27, 2016 to Jenna Makin

I found what I was looking for.  I was looking at EnsLib.HL7.Message looking for a way to correlate that to Ens.MessageHeader when I should have been looking from the reverse order.

In Ens.MessageHeader there is a field MessageBodyClassName which contains the name of the class containing the message body.  In this case EnsLib.HL7.Message

There is also a field in Ens.MessageHeader called MessageBodyId which contains the ID of the corresponding message body.

0