Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Operator

Meaning

Example

=

Equal

No Format
name/value = $nameValue

>

Greater than

No Format
o/data[at0001]/.../data[at0003]/items[at0004]/value/value >140

>=

Greater than or equal to

No Format
o/data[at0001]/..../data[at0003]/items[at0004]/value/value >=140

<

Smaller than

No Format
o/data[at0001]/.../data[at0003]/items[at0004]/value/value <160

<=

Smaller than or equal to

No Format
o/data[at0001]/.../data[at0003]/items[at0004]/value/value <=160

!=

not equals to

No Format
c/archetype_details/template_id/value != ''

Advanced AQL operatorsoperators 

 
matches

matches operator is used in WHERE clause. It has left expression. This operator needs left operand and right operand. Left operand is an AQL identified path. Right operand is enclosed within curly braces. Right operand of matches operator has three forms:

  1. type of constraint ADL (cADL): this type of matches right operand can be a value list , a value range,

These advanced operators are not yet supported by the grammar. The operator syntax is borrowed from ADL specifications. These are proposed to improve the richness and flexibility of AQL so that AQL syntax supports more complicated query scenarios.

...

This is an example of a terminology URI:

...

Image Modified

...

  EHR URI

to be continued... 

...

Value range leaf data is enclosed within curly braces after matches operator. It is only used in AQL WHERE clause to specify a criteria within a range. The syntax is similar as intervals of ordered primitive types (detailed in Section 4.5.2) in , adl.pdf. Some examples:

Code Block
matches {|3.0..5.0|} // means 3.0 <= x <=5.0
matches {|<8|}       // means x<8 x<8

AQL structure

Overview

AQL structure has been briefly introduced in Section 2.2. This section introduces AQL structure in details.

...