Hi Georg, I'm about to slightly disagree with Birger (or at least clarify!!) but it is taking me longer and I need to be offline for a bit!! Watch this space!
It is definitely possible to search on SNOMED terms both on the name and value attributes of the Element. What is more tricky is using the subsumption capablities of a terminology like SNOMED *(which is what I think Birger was saying). - that requires coordination between AQL and the underlying terminology server. This has been done by individual implementers but not in a generic way to date. Back soon with more details!! Ian Dr Ian McNicoll mobile +44 (0)775 209 7859 office +44 (0)1536 414994 skype: ianmcnicoll email: i...@freshehr.com twitter: @ianmcnicoll Co-Chair, openEHR Foundation ian.mcnic...@openehr.org Director, freshEHR Clinical Informatics Ltd. Director, HANDIHealth CIC Hon. Senior Research Associate, CHIME, UCL On Thu, 6 Sep 2018 at 09:21, Georg Fette <georg.fe...@uni-wuerzburg.de> wrote: > 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 FROM EHR e CONTAINS DEMOGRAPHICS 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 FROM EHR e CONTAINS DEMOGRAPHICS 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
