public static AQLQuery PatientLaborData(PatientListParameter patientList) { return(new AQLQuery("PatientLaborData", $@"SELECT e/ehr_id/value as PatientID, c/context/start_time/value as Befunddatum, y/items[at0001]/value/value as FallID, a/items[at0001]/value/id as LabordatenID, a/items[at0029]/value/defining_code/code_string as MaterialID, a/items[at0029]/value/value as Material_l, a/items[at0015]/value/value as ZeitpunktProbenentnahme, a/items[at0034]/value/value as ZeitpunktProbeneingang, d/items[at0024]/value/value as Keim_l, d/items[at0024]/value/defining_code/code_string as KeimID, d/items[at0001,'Nachweis']/value/value as Befund, d/items[at0001,'Nachweis']/value/defining_code/code_string as BefundCode, d/items[at0001,'Quantitatives Ergebnis']/value/magnitude as Viruslast, l/data[at0001]/events[at0002]/data[at0003]/items[at0101]/value/value as Befundkommentar FROM EHR e CONTAINS COMPOSITION c CONTAINS (CLUSTER y[openEHR-EHR-CLUSTER.case_identification.v0] and OBSERVATION l[openEHR-EHR-OBSERVATION.laboratory_test_result.v1] CONTAINS (CLUSTER a[openEHR-EHR-CLUSTER.specimen.v1] and CLUSTER b[openEHR-EHR-CLUSTER.laboratory_test_panel.v0] CONTAINS (CLUSTER d[openEHR-EHR-CLUSTER.laboratory_test_analyte.v1]))) WHERE c/name/value = 'Virologischer Befund' AND e/ehr_id/value MATCHES { patientList.ToAQLMatchString() } ORDER BY a/items[at0015]/value/value ASC")); }
public static AQLQuery PatientStay(PatientListParameter patientList) { return(new AQLQuery("PatientStay", $@"SELECT e/ehr_id/value as PatientID, i/items[at0001]/value/value as FallID, h/data[at0001]/items[at0004]/value/value as Beginn, h/data[at0001]/items[at0005]/value/value as Ende, h/data[at0001]/items[at0006]/value/value as Bewegungsart_l, s/items[at0027]/value/value as StationID, s/items[at0029]/value/value as Raum, f/items[at0024]/value/value as Fachabteilung, f/items[at0024]/value/defining_code/code_string as FachabteilungsID FROM EHR e CONTAINS COMPOSITION c[openEHR-EHR-COMPOSITION.event_summary.v0] CONTAINS (CLUSTER i[openEHR-EHR-CLUSTER.case_identification.v0] AND ADMIN_ENTRY h[openEHR-EHR-ADMIN_ENTRY.hospitalization.v0] CONTAINS (CLUSTER s[openEHR-EHR-CLUSTER.location.v1] AND CLUSTER f[openEHR-EHR-CLUSTER.organization.v0])) WHERE c/name/value = 'Patientenaufenthalt' AND i/items[at0001]/name/value = 'Zugehöriger Versorgungsfall (Kennung)' AND e/ehr_id/value MATCHES {patientList.ToAQLMatchString()} ORDER BY e/ehr_id/value ASC, h/data[at0001]/items[at0004]/value/value ASC")); }
public static AQLQuery PatientSymptom_US(PatientListParameter patientList) { return(new AQLQuery("PatientSymptom_US", $"SELECT e/ehr_id/value as PatientenID, a/data[at0001]/items[at0002]/value/value as UnbekanntesSymptom, a/ data[at0001]/items[at0005]/value/value as AussageFehlendeInfo FROM EHR e CONTAINS COMPOSITION c CONTAINS EVALUATION a[openEHR-EHR-EVALUATION.absence.v2] WHERE c/archetype_details/template_id='Symptom' and e/ehr_id/value matches { patientList.ToAQLMatchString() }")); }
public static AQLQuery PatientSymptom_AS(PatientListParameter patientList) { return(new AQLQuery("PatientSymptom_AS", $"SELECT e/ehr_id/value as PatientenID, a/data[at0001]/items[at0002]/value/value as AusschlussAussage, a/ data[at0001]/items[at0003]/value/value as Diagnose FROM EHR e CONTAINS COMPOSITION c CONTAINS EVALUATION a[openEHR-EHR-EVALUATION.exclusion_specific.v1] WHERE c/archetype_details/template_id='Symptom' and e/ehr_id/value matches { patientList.ToAQLMatchString() }")); }
public static AQLQuery PatientSymptom_VS(PatientListParameter patientList) { return(new AQLQuery("PatientSymptom_VS", $"SELECT e/ehr_id/value as PatientenID, a/data[at0190]/events[at0191]/data[at0192]/items[at0001]/value/value as NameDesSymptoms, a/data[at0190]/events[at0191]/data[at0192/items[at0151]/value/value as Lokalisation, a/ data[at0190]/events[at0191]/data[at0192]/items[at0152]/value/value as Beginn, a/ data[at0190]/events[at0191]/data[at0192]/items[at0021]/value/value as Schweregrad, a/ data[at0190]/events[at0191]/data[at0192]/items[at0161] as Rueckgang FROM EHR e CONTAINS COMPOSITION c CONTAINS OBSERVATION a[openEHR-EHR-OBSERVATION.symptom_sign.v0] WHERE c/archetype_details/template_id='Symptom' and e/ehr_id/value matches { patientList.ToAQLMatchString() }")); }
public static AQLQuery CasesWithResults(PatientListParameter patientList) { return(new AQLQuery("CasesWithResults", $"SELECT DISTINCT e/ehr_id/value as PatientID, m/items[at0001]/value/value AS FallID, c/uid/value as UID FROM EHR e CONTAINS COMPOSITION c CONTAINS CLUSTER m[openEHR-EHR-CLUSTER.case_identification.v0] WHERE c/name/value = 'Mikrobiologischer Befund' AND e/ehr_id/value matches { patientList.ToAQLMatchString() } order by m/items[at0001]/value/value asc")); }
public ActionResult <List <LabDataModel> > Patient_Labordaten_Ps([FromBody] PatientListParameter parameter) { _logger.LogInformation("CALLED Patient_Labordaten_Ps with parameters: PatientIDs: {patList}", parameter.ToAQLMatchString()); try { return(_patientInformation.Patient_Labordaten_Ps(parameter)); } catch (Exception e) { _logger.LogWarning("CALLED Patient_Labordaten_Ps:" + e.Message); return(ErrorHandling(e)); } }