AQL queries and one-many relationships

2009-02-24 Thread john.ryan-br...@csiro.au
Hello. I am currently investigating AQL and would like to know how the following queries would be answered by a conformant AQL query engine. I understand that the structure of AQL query results are not standardized yet in the AQL specifications, so if the spec cannot give a definitive answer

OpenEHR'ED

2009-02-24 Thread Derek Meyer
/openehr-technical_lists.openehr.org/attachments/20090224/ed73607b/attachment.vcf

AQL queries and one-many relationships

2009-02-24 Thread Greg Caulton
My assumption was that the 'contains openEHR-EHR-COMPOSITION.encounter.v1' will restrict the result set to be in this case blood pressure observations that were recorded on an encounter note (or any document identified as such). If I make up an archetype called assessment you could have the

AW: OpenEHR'ED

2009-02-24 Thread William E Hammond
An HTML attachment was scrubbed... URL: http://lists.openehr.org/mailman/private/openehr-technical_lists.openehr.org/attachments/20090224/e06f8446/attachment.html -- next part -- A non-text attachment was scrubbed... Name: dmeyer.vcf Type: application/octet-stream Size

AQL queries and one-many relationships

2009-02-24 Thread Greg Caulton
Sorry, I was trying to use an example to explain that in SQL one would have a cartesian join if you have select t1.* from t1, t2 but in AQL the examples I have seen suggest that select o from c1, o1 would be an implict join I'll leave the AQL discussions to someone more versed with it