That definitely sounds like a bug as we shouldn’t be matching reports to different patients. If you’re not dealing with live data is there any chance you can put a screenshot of a copy of your form_clinical_notes table here as well as a copy of the entire DiagnosticReport FHIR endpoint result that is giving you the mismatched patient? That’d be helpful to try and isolate why this is happening for you.
Also please give me a screenshot after executing the following query for the form table which will show the patient ids for the specific form_clinical_notes table.
(SELECT
id AS form_id,
encounter
,pid AS form_pid
FROM
forms WHERE forms.id IN (SELECT DISTINCT form_id FROM form_clinical_notes)
)