I'm simply fumbling around in my never ending quest to find holistic queries that answer basic questions.  Right now I'm querying the registry.  I don't have SQL access to the buses or hsaccess and we have dozens of edges so that isn't convenient  Since the ATNA log is 600+ million rows and takes hours and hours to query (and decypher), HSREG is really my only option.

Looks like it's something to do with our custom consent.  I don't completely understand it, but if I limit the SourceConfigName to HS.Hub.MPIManager it obviously eliminates the duplicates.

Very good info, thanks!  However,

"Missing or Invalid Document"

also

"No matches were found for HEOV_architecture (.000429s)"

I found that half of them have a value in the RequestId column and the other half don't.  All other columns are identical.  What is the cause/reason for this?

Good to hear ;)

I think that is the literal meaning but I'm wondering what it means functionally, what triggers this "mode".

edit: obviously the answer is "Pix or PDQ events", I guess I'm just trying to understand this table better.  I'm not really sure what answer I'm looking for.

It looks  like "ExportRecords" coincides with an external request and "ViewRecords" is a clinical viewer request.

*wish I could post an answer*

I found the following in HS.Message.PatientSearchRequest.cls:

 /// Search modes user - regular patient lookup, admin - mpi patient lookup no consent applied,
/// clinician -- mpi patient lookup, no consent applied, limited to patients with a pre-existing relationship with the clinician
Property SearchMode As %String(DISPLAYLIST = ",User,Admin,Clinician,Participation,AuditReport,PIXPDQ", VALUELIST = ",user,admin,clinician,participation,AuditReport,PIXPDQ") [ InitialExpression = "user" ];

Still not sure what PIXPDQ means but I assume it's for non-clinicalviewer searches.

We are an HIE so I cannot simulate a search from within an EHR system.

Can you think of anything I could query on the Registry to do this?  Something endpoint-agnostic?  For instance, I've discovered this seems to work pretty well for searches without having to worry about ATNA event types and the performance issues related to the size:

SELECT TimeProcessed, LastName, FirstName, DOB, AssigningAuthority, MPIID, MRN, SearchMode, RequestingUser, SAMLData_Organization, SessionId
FROM Ens.MessageHeader h LEFT JOIN HS_Message.PatientSearchRequest m
ON h.MessageBodyId = m.id
WHERE h.Invocation = 1
AND h.MessageBodyClassName = 'HS.Message.PatientSearchRequest'
ORDER BY SessionId DESC

I appreciate your input so far.

"The combined results are about to be loaded into the clinical viewer."

What about searches from directly within participant EHR systems?   Users that are not using the clinical viewer? ie "on demand" customers.  Or other protocols, XDSb, XCA, etc.  Also would this exclude patient searches like a PIX query before a document registration?

Ahhh, thanks.

What about the date format? Can you confirm that it's only looking for YYYYMMDD?

Finally fixed, hooray!

Well Chrome now blocked Backspace for navigation, so no risk of leaving the page, but this bug still persists. If you backspace past the last character the text entry box no longer has focus.