System: EHRbase Version: v0.32.0 I’ve come across two problems that probably are closely related. I was doing some tests and I created a single archetype containing the full structure I needed. That is, a COMPOSITION, which includes an OBSERVATION, which includes several ELEMENT. [image] I know …

[image] damoca: And finally, if we really believe in semantic interoperability, we should be able to locate any structure by its term_binding, no matter where it is located in one or multiple archetypes. This is very important, thinking about the strength of querying children’s of codes using…

Do you use term bindings for that ?

[image] SevKohler: This is very important, thinking about the strength of querying children’s of codes using e.g. a term server. Exactly, in theory AQL supports a function to query subsets (or even an ECL expression). But I don’t know if any provider implements this. Archetype Query…

[image] damoca: In the data instance, the code goes into the name attribute of the RM class. I could be inside the mapping of the DV_TEXT, or a defining_code of a DV_CODED_TEXT. Yeah but what about e.g. DV_ORDINAL answers, the only real consistent solution here is using term_mapping tbh (if i…

The symbol of the DV_ORDINAL is a DV_CODED_TEXT, so you should be able to filter the values that you are looking for in the WHERE clause. I thought I was brave enough by wanting to search ELEMENTs by its term mapping, since we should be careful with the context where those elements are used. I can’…

[image] siljelb: codes We provide the keys i.e. rubrics - which are either archetype text fields from archetype terms, or may be something adjusted from that - to LOINC.org and they give us provisional codes (which are proper LOINC codes, i.e. NNNNN-N numerics), and then they review later. So…

It was in a previous message :+1:

I speak of the DV_ORDINAL answers, why shouldn’t you not query on answers ? There are other examples, also then you will have term mappings + a coding in the DV_CODED_TEXT name, also sometimes you have atcodes as answers you annotate term mappings. I mean both are ok, but i rather like to have my …

[image] SevKohler: I speak of the DV_ORDINAL answers, why shouldn’t you not query on answers ? I did not say that you cannot query them, I said that probably you first need to query the question (the container ELEMENT), and then filter the answers you need in the WHERE clause. :wink:

[EHRbase] Storing and querying data without an standalone archetype

Implementation Platform

Topic		Replies	Views
LOCATABLE name with a SNOMED code Archetype Designer	18	1241	18 March 2024
Inconsistency in REST API Create EHR implementations -needs spec clarification? ITS	27	959	9 October 2024
AQL: querying data from several archetypes AQL aql	9	837	9 September 2023
Generic modeling and issues for querying Technical (archive)	9	39	21 September 2018
openEHR REST APIs - Release 0.9.0 / invitation for comments Technical (archive)	25	88	20 February 2018
How to make mappings easier to query and to document in openEHR Terminology	33	717	19 April 2024
AQL: Expected result with repeating structures Implementers (archive)	9	47	6 May 2017
AQL to retrieving data for an element with cardinality 0..* AQL	50	1574	6 December 2022
Modeling generic concepts, considerations for querying Clinical (archive)	17	111	10 October 2017
Querying an openEHR CDR with SQL, Cypher, and GraphQL? Yes, it’s possible. Implementation aql	24	221	12 August 2026

[EHRbase] Storing and querying data without an standalone archetype

Related topics