Hi Georg,
currently, this is not possible directly using AQL. However, technically
it is possible to make a look-up within all archetypes to automatically
retrieve the elements (and their paths) that have a matching
terminology-binding (for example to the snomed code for gender). This
path could then be used within an AQL query which can use the code for
"male". I actually was thinking about building such a tool within
HiGHmed make analytics quers more convenient, though we are still
searching for a developer.
Hope this answers your question,
Birger
--
*Birger Haarbrandt, M. Sc.
Peter L. Reichertz Institut for Medical Informatics (PLRI)
Technical University Braunschweig and Hannover Medical School
Software Architect HiGHmed Project *
Tel: +49 176 640 94 640, Fax: +49 531/391-9502
birger.haarbra...@plri.de
www.plri.de
Am 06.09.2018 um 10:21 schrieb Georg Fette:
Hello,
In AQL it is possible to constrain the value of a node to one of the
codes that are allowed for that value (as specified in the respective
archetype).
To find patients with gender (snomed-ct:248153007) male
(snomed-ct:248153007) I could write something like this:
SELECT e FROMEHR e CONTAINSDEMOGRAPHICS d
WHERE d.items[at0017].value = 'snomed-ct:248153007'
Is it possible to identify the node of an archetype instead of its
path parts (e.g. d.gender or d.items[at0017]) also with a terminology
code, so the query would rather look like something like that:
SELECT e FROMEHR e CONTAINSDEMOGRAPHICS d
WHERE d.items['snomed-ct:263495000'].value = 'snomed-ct:248153007'
I am not very experienced with AQL so the queries are probably already
syntactically wrong.
Greetings
Georg
--
---------------------------------------------------------------------
Dipl.-Inf. Georg Fette Raum: B001
Universität Würzburg Tel.: +49-(0)931-31-85516
Am Hubland Fax.: +49-(0)931-31-86732
97074 Würzburg mail:georg.fe...@uni-wuerzburg.de
---------------------------------------------------------------------
_______________________________________________
openEHR-technical mailing list
openEHR-technical@lists.openehr.org
http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org
_______________________________________________
openEHR-technical mailing list
openEHR-technical@lists.openehr.org
http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org