Hi all, another question about AQL and CONTAINS.
Most of the AQL samples use just one branch in the FROM clause, like:
EHR CONTAINS COMPOSITION CONTAINS OBSERVATION.
I'm wondering what would be the correct FROM notation when more than one
ENTRY is needed. Some examples below.
SELECT o1/data[...]/.../value, o2/..., ....
FROM
COMPOSITION c [archid] CONTAINS OBSERVATION o1 [archid2],
COMPOSITION c [archid] CONTAINS OBSERVATION o2 [archid3],
COMPOSITION c [archid] CONTAINS OBSERVATION o3 [archid4]
WHERE ...
SELECT o1/data[...]/.../value, o2/..., ....
FROM
COMPOSITION c [archid]
CONTAINS OBSERVATION o1 [archid2] AND
CONTAINS OBSERVATION o2 [archid3] AND
CONTAINS OBSERVATION o3 [archid4]
WHERE ...
Thanks!
--
Ing. Pablo Pazos GutiƩrrez
e: [email protected]
p: +598 99 043 145
skype: cabolabs
<http://cabolabs.com/>
http://www.cabolabs.com
https://cloudehrserver.com
Subscribe to our newsletter <http://eepurl.com/b_w_tj>
_______________________________________________
openEHR-technical mailing list
[email protected]
http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org