Also see this, just in case it may help clarify relevant Qs: https://github.com/serefarikan/aql-discussion
On Sunday, October 1, 2017, Pablo Pazos <pablo.pa...@cabolabs.com> wrote: > 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: pablo.pa...@cabolabs.com > <javascript:_e(%7B%7D,'cvml','pablo.pa...@cabolabs.com');> > 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 openEHR-technical@lists.openehr.org http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org