Request for getting Audit/Reporting info.
The ask is for a count of inbound messages by distinct identifier.
My challenge is getting the unique identifer out of the RawContent column in the EnsLib_HL7 table.
Wondering if a temp table can be created to store the value then do a join?
In the below example I am wanting to use the 999998 value in the PID.