Ah, okay. Thank you.
Am 06.09.2018 um 10:33 schrieb Birger Haarbrandt:
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
[email protected]
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:[email protected]
---------------------------------------------------------------------
_______________________________________________
openEHR-technical mailing list
[email protected]
http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org
--
---------------------------------------------------------------------
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: [email protected]
---------------------------------------------------------------------
_______________________________________________
openEHR-technical mailing list
[email protected]
http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org
