...
| Code Block |
|---|
SELECT e/ehr_id/value
FROM EHR e CONTAINS COMPOSITION c[openEHR-EHR-COMPOSITION.administrative_encounter.v1]
CONTAINS ADMIN_ENTRY admission[openEHR-EHR-ADMIN_ENTRY.admission.v1]
WHERE NOT EXISTS c/content[openEHR-EHR-ADMIN_ENTRY.discharge.v1]
|
...
| Code Block |
|---|
SELECT c/uid/value, instruction FROM EHR e [ehr_id/value=$ehrid] CONTAINS COMPOSITION c CONTAINS INSTRUCTION instruction[openEHR-EHR-INSTRUCTION.referral.v1] WHERE EXISTS instruction/links[target='ehr://327000002/87284370-2D4B-4e3d-A3F3-F303D2F4F34B@latest_trunk_version'] |
...
- current-date(): a build-in function returning the current date value in ISO date string format.
- current-date-time(): a build-in function returning the current date time value in ISO date/time string format.
- max: a build-in function returning the max value out of an expression.
Advanced operators
...
- .