Hi, We want to store the time the composition is stored in the CDR (ehrBase). Is it possible to store and extract the audit details class which stores this information in time_committed . If so can you please provide the flat json and the aql for the same. Note, we do not want to store the comp…

On Better CDR you can do SELECT c/name/value as compName, vo/uid/value as identifier, v/uid/value as versionId, v/preceding_version_uid/value as previousVersionId FROM EHR e CONTAINS VERSIONED_OBJECT vo CONTAINS VERSION v[all_versions] CONTAINS COMPOSITION c ORDER BY identifier ASC,…

Extract audit details (time committed) in AQL?

Implementation Platform

ian.mcnicoll (Ian McNicoll) 9 January 2023 15:58 3

Also see AQL query for compositions that have been created/updated within a time period

Topic		Replies	Views
AQL query for compositions that have been created/updated within a time period Platform ehrbase	12	1157	11 October 2024
Setting audit_change_type value in compositions Platform	6	138	26 August 2024
AQL VersionedObject Grammar Technical (archive)	4	35	22 July 2011
AQL fetch issue when Two different templates has same archetype in version 23 AQL template , aql , ehrbase , archetype	11	694	20 January 2023
Queries on multiple Evaluations in a Composition Implementation	9	435	14 February 2024
AQL - Querying observations of various types in compositions AQL aql	4	119	2 September 2024
AQL: Support to join two composition on ehrid AQL	3	529	28 November 2022
Cannot query all compositions of an EHR only with identifier "c" Platform	5	903	18 January 2023
Facing issue in AQL when queried across different templates across different archetypes Platform ehrbase , aql	11	498	1 February 2023
AQL on versioned compositions Technical (archive)	6	51	2 November 2018

Extract audit details (time committed) in AQL?

Related topics