AQL using regexes in the matches operator (discussion)

Owned by Pablo Pazos
13-Dec-2019
2 min read

These examples were removed from the current spec since use regular expressions in the matches operator, which is not specified in the rest of the spec, and not supported by the current AQL grammar.

[cols="1,4a",options="header",separator=¦] |=== ¦*Clinical Scenario 5* ¦Require all HbA1c values done in 1999 ¦*Total cholesterol EHR path* ¦`o/data/origin` ¦*AQL Fragment + (alt 1)* ¦ ---- EHR path/value matches {"^1999"} ---- ¦*AQL Fragment + (alt 2)* ¦ ---- EHR path/value matches {|1999-??-??|} ---- ¦*AQL Fragment + (alt 3)* ¦ ---- EHR path/value matches {|1999-01-01..1999-12-31|} ---- |=== [cols="1,4a",options="header",separator=¦] |=== ¦*Clinical Scenario 6* ¦Require all blood glucose values done in the morning of 1st December, 1999 ¦*EHR path* ¦`o/data/origin` ¦*AQL Fragment + (alt 1)* ¦ ---- EHR path/value matches {"^19991201T(((0[0-9])|10|11|)(([0-5][0-9])?([0-5][0-9])?)|(1200))$"} ---- ¦*AQL Fragment + (alt 2)* ¦ ---- EHR path/value matches {|1999-12-01T00:00:00..1999-12-01T11:59:59|} ---- |=== [cols="1,4a",options="header",separator=¦] |=== ¦*Clinical Scenario 7* ¦Require all blood glucose values done in the morning of December, 1999 ¦*EHR path* ¦`o/data/origin` ¦*AQL Fragment + (alt 1)* ¦ ---- 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])?))$"} ---- ¦*AQL Fragment + (alt 2)* ¦ ---- EHR path/value matches {|1999-12-ddT00:00:00..1999-12-ddT11:59:59|} ---- |=== [cols="1,4a",options="header",separator=¦] |=== ¦*Clinical Scenario 8* ¦Require all HbA1c values done after 1999 ¦*EHR path* ¦`o/data/origin` ¦*AQL Fragment + (alt 1)* ¦ ---- EHR path/value matches {"^[2-9]\d\d\d"} ---- ¦*AQL Fragment + (alt 2)* ¦ ---- EHR path/value matches {|>1999-??-??|} ---- |=== [cols="1,4a",options="header",separator=¦] |=== ¦*Clinical Scenario 9* ¦Require all HbA1c values done before 1999 ¦*EHR path* ¦`o/data/origin` ¦*AQL Fragment + (alt 1)* ¦ ---- EHR path/value matches {"^1\d\d[0-8]"} ---- ¦*AQL Fragment + (alt 2)* ¦ ---- EHR path/value matches {|<1999-??-??|} ---- |===