Topic The following and quite simple AQL will be evaluated with different datasets (A,B,C,D) using either AND or OR . For each case we have defined alternative and possible resultsets. Look at the examples. Which of the answers do you expect? Are there something missing? Base AQL to be used for…

[image] bna: composition o1, o2 e1, e2 Is this 2 compositions or a single composition with all 4 archetypes, sorry being dumb :frowning:

[image] bna: composition o1, o2 e1, e2 I don’t understand what this construction means - does it mean a Composition containing 4 Entries (i.e. 2 x Obs, 2 x Evals)?

Hi I will rewrite this post with the syntax and formalism learned from @Seref . Give me a day :thinking:

@bna here it is (bah, I realised I included C in the select. I won’t make a difference here though…) [image] A: AND TPQ [image] A: OR TPQ [image] B: AND TPQ [image] B: OR TPQ [image] C: AND TPQ EMPTY SET C: OR TPQ [image] D: AND TPQ [image] D: OR TPQ [image] The permutative behavi…

I understand the FROM clause as a pattern matcher to filter the total database to obtain the dataset on which the WHERE, then the SELECT are run. Under this logic, SELECT o, e FROM composition c CONTAINS (observation o OR evaluation e) applied to instance structure A would mean the following execut…

AQL - what do you expect as results for these example

Specifications AQL

ian.mcnicoll (Ian McNicoll) 16 November 2020 15:43 5

I’m glad I was not the only one who was bit confused - Nordic minimalism?

Questions on AQL CONTAINS formalism

Topic		Replies	Views
Aql teaser 4 for implementers AQL aql	2	364	4 March 2020
Questions on AQL CONTAINS formalism AQL	7	187	12 September 2024
Aql teaser 3 for implementers AQL aql	17	482	6 March 2020
AQL teaser 2 for implementers AQL aql	10	377	6 March 2020
AQL - same logical AQL with different syntax AQL aql	7	539	25 February 2020
Aql teaser 1 for implementers AQL aql	32	1034	30 March 2020
AQL - the simplest possible question? AQL aql	34	1668	7 September 2023
What should AQL return in this case? Technical (archive)	7	1	20 August 2012
AQL across compositions with different Root Archetype Id AQL	13	690	22 February 2022
[openEHR SEC] AQL FROM & CONTAINS with many entries Technical (archive)	6	1	1 October 2017

AQL - what do you expect as results for these example

Related topics