Re: AQL FROM & CONTAINS with many entries

Sun, 01 Oct 2017 12:44:05 -0700

OK, makes sense! Please excuse me for stating the obvious :)

Birger


Pablo Pazos <pablo.pa...@cabolabs.com> hat am 1. Oktober 2017 um 21:21 geschrieben:

Thanks, my goal besides understanding the syntax is to improve the current spec, so I'm testing some use cases against the AQL spec instead of using specific implementations.

Cheers,
Pablo.

On Oct 1, 2017 3:33 PM, "Birger Haarbrandt" <birger.haarbra...@plri.de> wrote:

Hi Pablo,

I hope I understood correctly:

select
a_a/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value,
a_b/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value 
from EHR e
contains COMPOSITION a
contains (
OBSERVATION a_a[openEHR-EHR-OBSERVATION.body_temperature.v1] and
OBSERVATION a_b[openEHR-EHR-OBSERVATION.blood_pressure.v1])

this should be the right way to express the query. I think an account for EHRSCAPE could be of help if you want to dig deeper into AQL. 

Cheers,

Birger


Pablo Pazos <pablo.pa...@cabolabs.com> hat am 1. Oktober 2017 um 17:52 geschrieben:

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!

_______________________________________________
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
_______________________________________________
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

Reply via email to