Page Comparison

...

AQL Fragment

Code Block
ehr_path/value matches { C_DV_QUANTITY< list = < ["1"] = < units = <"mmol/L"> magnitude = <\|5.0..6.0\|> > ["2"] = < units = <"mg/dL"> magnitude = <\|90..110\|> > > > }

Clinical Scenario 3

HbA1c > 7.0%

EHR path

o/data[at0001]/events[at0002 and name/value='Any event']/data[at0003]/items[at0013.1]

AQL Fragment

Code Block
ehr_path/value matches { DV_PROPORTION matches { numerator matches {\|>7.0\|} denominator matches {\|100.0\|} } }

OR preferably

Code Block
ehr_path/value matches { DV_PROPORTION matches { numerator matches {\|>7.0\|} type matches {pk_percent} } }

Clinical Scenario 4

Total cholesterol >= 5.0 mmol/L or LDL-C >= 3.0 mmol/L

Total cholesterol EHR path

o/data[at0001]/events[at0002 and name/value='Any event']/data[at0003]/items[at0013.1]

LDL-C EHR path

o/data[at0001]/events[at0002 and name/value='Any event']/data[at0003]/items[at0011.1 and name/value='Fractions']/items[at0013.4 and name/value='LDL-Cholesterol']

AQL Fragment

Code Block

Total cholesterol EHR path/value matches {
     DV_QUANTITY matches {
         units matches {"mmol/L"}
         magnitude matches {|>=5.0|}
     }
 }

 OR

 LDL-C EHR path/value matches {
      DV_QUANTITY matches {
          units matches {"mmol/L"}
          magnitude matches {|>=3.0|}
      }
 }

Clinical Scenario 5

Require all HbA1c values done in 1999

EHR path

o/data/origin

AQL Fragment

Code Block
EHR path/value matches {"^1999"}

OR

Code Block
EHR path/value matches {\|1999-??-??\|}

OR

Code Block
EHR path/value matches {\|1999-01-01..1999-12-31\|}

Clinical Scenario 6

Require all blood glucose values done in the morning of 1st December, 1999

EHR path

o/data/origin

AQL Fragment

Code Block
EHR path/value matches {"^19991201T(((0[0-9])\|10\|11\|) (([0-5][0-9])?([0-5][0-9])?) \|(1200)) $"}

OR

Code Block
EHR path/value matches {\|1999-12-01T00:00:00..1999-12-01T11:59:59\|}

Clinical Scenario 7

Require all blood glucose values done in the morning of December, 1999

EHR path

o/data/origin

AQL Fragment

Code Block
EHR path/value matches {"^199912 (([0-2][1-9])\|10\|20\|30\|31)? (T ((0[0-5])\|10\|11) (([0-5][0-9])?([0-5][0-9])?) ) $"}

OR

Code Block
EHR path/value matches {\|1999-12-ddT00:00:00..1999-12-ddT11:59:59\|}

Clinical Scenario 8

Require all HbA1c values done after 1999

EHR path

o/data/origin

AQL Fragment

Code Block
EHR path/value matches {"^[2-9]\d\d\d"}

OR

Code Block
EHR path/value matches {\|>1999-??-??\|}

Clinical Scenario 9

Require all HbA1c values done before 1999

EHR path

o/data/origin

AQL Fragment

Code Block
EHR path/value matches {"^1\d\d[0-8]"}

OR

Code Block
EHR path/value matches {\|<1999-??-??\|}

Clinical Scenario 10

Requires all reports composed by patient self

AQL Expression

Code Block
SELECT c FROM EHR e[ehr_id=$ehrUid] CONTAINS COMPOSITION c WHERE c/composer matches {PARTY_SELF}

...

Versions Compared

Old Version 5

New Version 6

Key