Here is the content I’d like to suggest for addition to AQL spec. The spec becomes a a bit repetitive if this is replaces 3.10.2 but I need to explain various things to expand the argument so I can live with it. Comments are welcome. 3.10.2 FROM The FROM clause defines the scope of the query in te…

BTW I don’t disagree with anything in @Seref ’s original post, which is nice and clear, apart from possibly this: [image] Seref: The CONTAINS keyword that establishes a structural constraint between EHR instances and COMPOSITION instances therefore implies COMPOSITION instances accessible from …

Wre are not talking about the AQL specification wer are talking about how that AQL specification applies to a specific RM, in our cae the openEHR RM - as you can see from Seref and Bjorn’s examples there are legitimate varying interpreatations of how it should be applied - is EHR e optional, what ex…

[image] ian.mcnicoll: I’d like to test that statement with experienced implementers - the success of openEHR to data has been because of the great work that you have done on model representation but I know there has already been significant pushback in a similar way around Expressions. I feel we…

[image] ian.mcnicoll: I would like a much clearer answer from implementers on where/how BMM has value before committing much more resource in that direction. Well, I said it before, I understand both @Seref and @thomas.beale perspective, and I don’t think that they are clashing. @Seref text a…

[image] thomas.beale: If I read this literally, it implies that the use of ‘CONTAINS’ in an AQL query ‘establishes’ something about the model Leaving a typo aside, (an EHR instance, not and EHR instance…), that sentence is not about the model. Please note the repeated use of instances in tha…

We’ve had openEHR in production 6 years now and AQL for 5 years without using or for many years not even knowing about BMM. BMM is certainly not critical for us to understand how to execute AQL on openEHR data. The last years we’ve implemented a BMM parser and the possibility to validate our models…

[image] Seref: I’m assuming RM ( and potentially + demographics) and describing what CONTAINS means in the context of a query when that query is run on data (instances) that is based on openEHR types (RM+demographics) That assumption allows me to define query semantics without referring to any m…

[image] thomas.beale: That seems to imply that AQL is a language specific to the openEHR RM. But it should be a query language applicable to any archetyped data based on any reference model - the semantics are the same. I think it is quite clear that we disagree on this one :slight_smile: At…

[image] Seref: which is what DIPS, Better, Ocean, Ethercis and EhrBase have done without anybody putting this into any spec in the last 10(?) years. That’s a very good point Seref. You took the word out of my mouth.

That implies that people are implementing some kind of generic rm-neutral aql processors which is certainly not true for ethercis and I assume ehrbase. I think Bjørn and seref are both saying that this is not how their CDRs work.

AQL: Formal definition of FROM clause

Specifications AQL

sebastian.iancu (Sebastian Iancu) 26 February 2020 08:29 65

I was referring (hinting) to our (openEHR) row/result-set or whatever that type-name we will have in our specification (because we should have those types specified, including json-schema, xsd).

Topic		Replies	Views
AQL - the simplest possible question? AQL aql	34	1666	7 September 2023
Practical approach to FOLDER OPTs Ask IEB	36	1024	14 November 2022
EHRs with different system_id in the same server? RM	39	1084	7 November 2024
Aql teaser 1 for implementers AQL aql	32	1034	30 March 2020
Safety features in AQL: subject AQL aql	104	2476	28 November 2019
AQL to retrieving data for an element with cardinality 0..* AQL	50	1353	6 December 2022
[EHRbase] Storing and querying data without an standalone archetype Platform aql , ehrbase	39	925	17 April 2024
How accurately do we model "copied" data? Clinical	42	1484	27 August 2025
Missing rule in AOM 1.4 for non-unique sibling nodeIds Specifications	42	968	8 April 2024
Aql: clarify types supported by relational operators AQL aql	23	974	19 February 2020

AQL: Formal definition of FROM clause

Related topics