@Thomas I realized we have a similar issue with multiple occurrences of structured items.
For instance, an OPT: ... CLUSTER 0..* at1234 - ELEMENT at1235 - ELEMENT at1236 Could have an instance: ... CLUSTER at1234 - ELEMENT at1235 - ELEMENT at1236 CLUSTER at1234 - ELEMENT at1235 - ELEMENT at1236 Then querying for "SELECT .... WHERE ../path_to_at1235/value > X AND .../path_to_1236/value = Y" will return data even if both ELEMENTs referenced by the paths are contained in different CLUSTER instances. An AQL exercise would be how to get the CLUSTER which contains ELEMENTs that comply with conditions on more than one ELEMENT inside them and there are many occurrences of the same CLUSTER, so CLUSTER and children will have the same paths. Not sure how to express that considering that depends on instances not on the model. Maybe is something that should be handled by the CONTAINS operator? I believe it was Ian that said the CONTAINS should be evaluated against instances, not against the template. If that is the case, I think that will also solve the issue explained on my first message. Any ideas? On Sun, Sep 16, 2018 at 11:34 PM Pablo Pazos <[email protected]> wrote: > Solution is easy, just created specific structures for the results of some > test that I needed to store and query so I have different node ids on each > analyte. That will allow me to query, create some CDS rules and some fancy > indicators for reports :) > > On Sun, Sep 16, 2018 at 7:36 AM Karsten Hilbert <[email protected]> > wrote: > >> > openEHR data representation and querying are founded upon this >> > fundamental principle - store how you like, query how you like. >> >> OK, as long as "store how you like" does not impede >> "query how you like", the principle seems reasonable. >> >> Karsten >> >> _______________________________________________ >> openEHR-technical mailing list >> [email protected] >> >> http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org >> > > > -- > *Ing. Pablo Pazos Gutiérrez* > [email protected] > +598 99 043 145 > skype: cabolabs > Subscribe to our newsletter <http://eepurl.com/b_w_tj> > <https://cabolabs.com/> > http://www.cabolabs.com > https://cloudehrserver.com > > -- *Ing. Pablo Pazos Gutiérrez* [email protected] +598 99 043 145 skype: cabolabs Subscribe to our newsletter <http://eepurl.com/b_w_tj> <https://cabolabs.com/> http://www.cabolabs.com https://cloudehrserver.com
_______________________________________________ openEHR-technical mailing list [email protected] http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org
