Thanks Bjorn That feels logical and the restriction to one layer of folders make sense. I appreciate that under the hood 'CONTAINS' is implemented differently but it feels natural to think in terms of logical containment.
Ian Dr Ian McNicoll mobile +44 (0)775 209 7859 office +44 (0)1536 414994 skype: ianmcnicoll email: i...@freshehr.com twitter: @ianmcnicoll Co-Chair, openEHR Foundation ian.mcnic...@openehr.org Director, freshEHR Clinical Informatics Ltd. Director, HANDIHealth CIC Hon. Senior Research Associate, CHIME, UCL On Tue, 21 Aug 2018 at 08:54, Bjørn Næss <b...@dips.no> wrote: > @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 <+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 > twitter: @ianmcnicoll > > > > Co-Chair, openEHR Foundation 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> > 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 > > 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