...
- type of constraint ADL (cADL): this type of right operand can be a value list or a value range. Examples can be found from value list or value range section. Value range is not supported in the current AQL grammar. URI: can be either terminology URI or EHR URI, or some other URIS. Only terminology URI is supported in the current AQL grammar.Below is an example with matches a string value list:
Code Block SELECT o/data[at0002]/events[at0003]/data/items[at0015]/items[at0018]/name FROM Ehr [uid=$ehrUid] CONTAINS Composition c CONTAINS Observation o[openEHR-EHR-OBSERVATION.microbiology.v1] WHERE o/data[at0002]/events[at0003]/data/items[at0015]/items[at0018]/items[at0019]/items[at0021]/name/defining_code/code_string matches {'18919-1', '18961-3', '19000-9'} - URI: can be either terminology URI or EHR URI, or some other URIS. Only terminology URI is supported in the current AQL grammar. An example with matches a terminology URI is shown below:
Code Block SELECT e/ehr_status/subject/external_ref/id/value, diagnosis/data/items[at0002.1]/value FROM EHR e CONTAINS Composition c[openEHR-EHR-COMPOSITION.problem_list.v1] CONTAINS Evaluation diagnosis[openEHR-EHR-EVALUATION.problem-diagnosis.v1] WHERE c/name/value='Current Problems' ANDdiagnosis/data/items[at0002.1]/value/defining_code matches { terminology://Snomed-CT/hierarchy?rootConceptId=50043002 } - embedded AQL query: means an AQL query statement, i.e. embedded query, within the curly braces. Embedded query is not supported in the current AQL grammar. It looks like:
.Code Block matches {SELECT ... FROM .. WHERE}
...
| Code Block |
|---|
WHERE composition/context/start_time > '19860101' // a complete date. AQL grammar identifies it as a string value. WHERE composition/context/start_time < "120000+0930" // ISO8601 time. AQL grammar identifies it as a string value. WHERE composition/context/start_time <= '1986-01-01' // complete calendar date in ISO8601 extended format. AQL grammar identifies this value as a date value. |
Intervals of Ordered Primitive Types
...
Other Built-in Types
URI
URI leaf data is enclosed within curly braces after "matches" operator. URI can be expressed as a normal URI described in http://www.ietf.org/rfc/rfc3986.txt. URI is not case sensitive. In AQL, a URI can be either terminology URI or EHR URI.
...