cabolabs-ehrserver icon indicating copy to clipboard operation
cabolabs-ehrserver copied to clipboard

Published 20 hours ago • verified publisher icon ppazos

[QUERY] Allow querying datavalues by condition

Open ppazos opened this issue 10 years ago • 0 comments

Sample AQL query to be supported

´´´ SELECT obs/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value/magnitude, obs/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value/magnitude FROM EHR [ehr_id/value=$ehrUid] CONTAINS COMPOSITION [openEHR-EHR-COMPOSITION.encounter.v1] CONTAINS OBSERVATION obs [openEHR-EHR-OBSERVATION.blood_pressure.v1] WHERE obs/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value/magnitude >= 140 OR obs/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value/magnitude >= 90 ´´´

ppazos avatar Aug 14 '15 00:08 ppazos