Appendix

Acknowledgements

Primary Author

  • Chunlan Ma, MD, Ocean Informatics, Australia.

Contributors

This specification benefited from wide formal and informal input from the openEHR and wider health informatics community. The openEHR Foundation would like to recognise the following people for their contributions.

  • Birger Haarbrandt, MSc, Peter L. Reichertz Institut for Medical Informatics (PLRI), Germany

  • Bjørn Næss, DIPS, Norway

  • Borut Fabjan, Program Manager, Better, Slovenia

  • Bostjan Lah, Senior Architect, Better, Slovenia

  • Heath Frankel, Ocean Informatics, Australia

  • Ian McNicoll MD, FreshEHR, UK

  • Luiz Marco-Ruiz, PhD, Norwegian Centre for E-health Research, Norway

  • Matija Polajnar, PhD, Software Engineer, Better, Slovenia

  • Pablo Pazos Gutierrez, Senior engineer, CaboLabs, Uruguay

  • Sebastian Iancu, Architect, Code24, Netherlands

  • Seref Arikan, MEcon, Ocean Informatics UK, Centre for Health Informatics and Multi-professional Education (CHIME) UK

  • Thomas Beale, Ars Semantica UK, openEHR Foundation Management Board

Support

The work reported in this paper has been funded by the following organisations:

  • Ocean Informatics, Australia

  • Better d.o.o., Slovenia (was Marand)

Trademarks

  • 'openEHR' is a trademark of the openEHR Foundation

  • 'Java' is a registered trademark of Oracle Corporation

  • 'Microsoft' and '.Net' are trademarks of the Microsoft Corporation == Tools

Various tools that can be used to work with archetypes and templates, including extracting 'archetype paths' for use in AQL statements, are listed on the openEHR website modelling tools page.

Original Source

The text of this specification was originally posted on the openEHR wiki, and was used by the global openEHR community in that form.

Amendment Record

Issue Details Raiser, Implementer Completed

Release 1.2.0 (unreleased)

Release 1.1.0

1.1.0

SPECQUERY-8 Correct numerous minor typographical and formatting errors. Improve the wording and readability.

S Iancu

04 Feb 2021

SPECQUERY-30 Update (rewrite) grammar to ANTLR4 format.

S Iancu,
T Beale,
T van Hemert

04 Feb 2021

SPECQUERY-33 Add support for NULL.

S Iancu

01 Feb 2021

SPECQUERY-1 Allow name attribute term codes to be used in node predicate (SPECPR-129).

C Ma,
S Iancu

01 Feb 2021

SPECQUERY-27 Add support for DISTINCT.

S Iancu

10 Jan 2021

SPECQUERY-28 Add support for built-in functions.

S Iancu

10 Jan 2021

SPECQUERY-3 Add support for literals (fixed values) in column expression.

D Bosca,
S Iancu

12 Dec 2020

SPECQUERY-7 Add support for NOT CONTAINS.

T Beale,
S Iancu

12 Dec 2020

SPECQUERY-12 Improve terminology support by adding a new TERMINOLOGY function.

L Marco-Ruiz,
B Næss,
H Frankel
B Fabjan,
I McNicoll,
S Iancu

24 Nov 2020

SPECQUERY-25 Add support for aggregate functions like COUNT, SUM, etc (SPECPR-358).

S Iancu

23 Nov 2020

SPECQUERY-17 Add support for LIKE operator (SPECPR-358).

openEHR SEC

09 Nov 2020

SPECQUERY-31 Move AQL examples to a new separate specification.

openEHR SEC

09 Nov 2020

SPECQUERY-16 Add support for LIMIT and OFFSET; deprecate TOP (SPECPR-346).

P Pazos,
S Iancu

05 Nov 2020

Release 1.0.1

1.0.1

SPECQUERY-20 Clarify major keyword documentation and semantics; remove TIMEWINDOW.

openEHR SEC

15 Jun 2020

SPECQUERY-23 Improve introductory text; update section 2.

T Beale

15 Apr 2020

SPECQUERY-19 Clarify use of terminology 'identified path'.

P Pazos,
T Beale

10 Apr 2020

SPECQUERY-14: Correct typographical errors (SPECPR-320, SPECPR-345, SPECPR-212, SPECPR-332, SPECPR-331);
SPECQUERY-15: Add clarifications and fix typographical errors (SPECPR-359);
SPECQUERY-4: Improve documentation of 'matches' operator;
SPECQUERY-2: Clarify the return structure of an AQL query (SPECPR-320).

P Pazos,
B Næss,
S Arikan,
S Iancu,
M Polajnar,
I McNicoll,
T Beale

10 Apr 2020

Release 1.0.0

1.0.0

SPECQUERY-6 Publish original AQL wiki page as formal specification;
Various reformatting, adjustment of headings;
Fix missing square brackets on query example. (SPECPR-236)

openEHR SEC

10 Jan 2017

Add Antlr grammar for AQL

B Lah

13 Jan 2012

Initial Writing, based on openEHR AQL wiki page.

C Ma
H Frankel
T Beale

10 Dec 2008