@ian – we have implemented the query you wrote: “select c from EHR e contains FOLDER f contains COMPOSITION c where c…..”
You might even write: “select c from EHR e contains FOLDER f contains FOLDER child_folder contains COMPOSITION c where c…..” We made a restriction such that the COMPOSITION c MUST be referenced in FOLDER f and not any sub-folder. This was needed to avoid circular references and explosion in the result set. Vennlig hilsen Bjørn Næss Product owner DIPS ASA Mobil +47 93 43 29 10<tel:+47%2093%2043%2029%2010> From: openEHR-technical <openehr-technical-boun...@lists.openehr.org> On Behalf Of Ian McNicoll Sent: mandag 20. august 2018 11:22 To: For openEHR technical discussions <openehr-technical@lists.openehr.org> Subject: Re: AQL on specific list of compositions Yup but AQL is so cool for this kind of thing :) I still want to do Select c FROM EHR Contains folder x contains composition c since logically folder x contains compositions. Ian Dr Ian McNicoll mobile +44 (0)775 209 7859 office +44 (0)1536 414994 skype: ianmcnicoll email: i...@freshehr.com<mailto:i...@freshehr.com> twitter: @ianmcnicoll [https://docs.google.com/uc?export=download&id=0BzLo3mNUvbAjUmNWaFZYZlZ5djg&revid=0BzLo3mNUvbAjRzZKc0JpUXl2SkRtMDJ0bkdUcUQxM2dqSVdrPQ] Co-Chair, openEHR Foundation ian.mcnic...@openehr.org<mailto:ian.mcnic...@openehr.org> Director, freshEHR Clinical Informatics Ltd. Director, HANDIHealth CIC Hon. Senior Research Associate, CHIME, UCL On Mon, 20 Aug 2018 at 10:14, Thomas Beale <thomas.be...@openehr.org<mailto:thomas.be...@openehr.org>> wrote: Well if you have access to a Folder, you don't need to do an AQL query, you can just retrieve the Folder structure and recurse through it, picking up direct refs to VERSIONED_COMPOSITIONs. Creating Folders from the data on the other hand requires writing some queries that look for admissions and discharges, matching them up, and generating a Folder for each pair, named after the institution and/or dates of the stay. A bit messy, but not hard to do, if one wants to post hoc add Folders to 'old' EHRs that never had them. - thomas On 20/08/2018 10:07, Ian McNicoll wrote: > Thanks Thomas, > > What are your thoughts on the AQL example I foolishly guessed at :( > and that Seref quite correctly rejected!! > > How would/should we do... > > Select all compositions referenced by Folder x. _______________________________________________ openEHR-technical mailing list openEHR-technical@lists.openehr.org<mailto: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
