Duplicate Compositions from multiple child nodes in containment structure

Openehr: EHRBase via Docker
System: M2 Macbook

I’ve only posted a single composition to this ehr, but it’s returning duplicate compositions which scale with the “AND OBSERVATION’s” in the containment structure.

Note that the composition has 0…* ordinal on all the observation, but I’ve only entered ordinal 0 and 1 in the composition.

How can I do this query without returning back duplicate compositions besides the ordinal 0 and 1 entry which is there for each of these observations. I.e. I should only get back 2 compositions with the same composition uuids instead of any more than that.

I’ve added the flat composition and the AQL, along with an image of the response of repeat compositions below.

FLAT COMPOSITION:

{

"evitals_1_sect/context/start_time": "{% now 'iso-8601', '' %}",
"evitals_1_sect/context/setting|code": "228",
"evitals_1_sect/context/setting|value": "primary medical care",
"evitals_1_sect/composer|name": "Spiderman 2",

"evitals_1_sect/context/case_identification/case_identifier": "{% uuid 'v4' %}",
"evitals_1_sect/context/case_identification/case_started": "{% now 'iso-8601', '' %}",
"evitals_1_sect/context/case_identification/status": "Completed",

"evitals_1_sect/context/healthcare_professional/structured_name_of_a_person/title": "Dr.",
"evitals_1_sect/context/healthcare_professional/structured_name_of_a_person/given_name": "Harry",
"evitals_1_sect/context/healthcare_professional/structured_name_of_a_person/family_name": "Potter",
"evitals_1_sect/context/healthcare_professional/structured_name_of_a_person/suffix": "MD",

"evitals_1_sect/context/healthcare_organization/organisation_name": "Central Hospital of Hogwarts",
"evitals_1_sect/context/healthcare_organization/organisation_identifier|id": "1232",
"evitals_1_sect/context/healthcare_organization/organisation_identifier|type": "Medical Hospital",
"evitals_1_sect/context/healthcare_organization/organisation_identifier|issuer": "Wizarding World",
"evitals_1_sect/context/healthcare_organization/organisation_identifier|assigner": "Umbridge",
"evitals_1_sect/context/healthcare_organization/department_name": "Cardiac Center",
"evitals_1_sect/context/healthcare_organization/department_identifier|id": "{% uuid 'v4' %}",
"evitals_1_sect/context/healthcare_organization/department_identifier|type": "card",
"evitals_1_sect/context/healthcare_organization/department_identifier|issuer": "Hogwarts",
"evitals_1_sect/context/healthcare_organization/department_identifier|assigner": "Albus Dumbledore",

 "evitals_1_sect/evitals/body_temperature:0/temperature|magnitude": 58.4,
"evitals_1_sect/evitals/body_temperature:0/temperature|unit": "Cel",
"evitals_1_sect/evitals/body_temperature:0/time": "{% now 'iso-8601', '' %}",

"evitals_1_sect/evitals/body_temperature:0/language|code": "en",
"evitals_1_sect/evitals/body_temperature:0/language|terminology": "ISO_639-1",
"evitals_1_sect/evitals/body_temperature:0/encoding|code": "UTF-8",
"evitals_1_sect/evitals/body_temperature:0/encoding|terminology": "IANA_character-sets",
"evitals_1_sect/evitals/body_temperature:0/subject|name": "Timothy",

"evitals_1_sect/evitals/body_temperature:1/temperature|magnitude": 24.1,
"evitals_1_sect/evitals/body_temperature:1/temperature|unit": "Cel",
"evitals_1_sect/evitals/body_temperature:1/time": "{% now 'iso-8601', '' %}",

"evitals_1_sect/evitals/body_temperature:1/language|code": "en",
"evitals_1_sect/evitals/body_temperature:1/language|terminology": "ISO_639-1",
"evitals_1_sect/evitals/body_temperature:1/encoding|code": "UTF-8",
"evitals_1_sect/evitals/body_temperature:1/encoding|terminology": "IANA_character-sets",
"evitals_1_sect/evitals/body_temperature:1/subject|name": "Timothy",


"evitals_1_sect/evitals/blood_pressure:0/systolic|magnitude": 21.9,
"evitals_1_sect/evitals/blood_pressure:0/systolic|unit": "mm[Hg]",
"evitals_1_sect/evitals/blood_pressure:0/diastolic|magnitude": 67.1,
"evitals_1_sect/evitals/blood_pressure:0/diastolic|unit": "mm[Hg]",
"evitals_1_sect/evitals/blood_pressure:0/time": "{% now 'iso-8601', '' %}",

"evitals_1_sect/evitals/blood_pressure:0/language|code": "en",
"evitals_1_sect/evitals/blood_pressure:0/language|terminology": "ISO_639-1",
"evitals_1_sect/evitals/blood_pressure:0/encoding|code": "UTF-8",
"evitals_1_sect/evitals/blood_pressure:0/encoding|terminology": "IANA_character-sets",
"evitals_1_sect/evitals/blood_pressure:0/subject|name": "Timothy",

"evitals_1_sect/evitals/blood_pressure:1/systolic|magnitude": 34,
"evitals_1_sect/evitals/blood_pressure:1/systolic|unit": "mm[Hg]",
"evitals_1_sect/evitals/blood_pressure:1/diastolic|magnitude": 67.1,
"evitals_1_sect/evitals/blood_pressure:1/diastolic|unit": "mm[Hg]",
"evitals_1_sect/evitals/blood_pressure:1/time": "{% now 'iso-8601', '' %}",

"evitals_1_sect/evitals/blood_pressure:1/language|code": "en",
"evitals_1_sect/evitals/blood_pressure:1/language|terminology": "ISO_639-1",
"evitals_1_sect/evitals/blood_pressure:1/encoding|code": "UTF-8",
"evitals_1_sect/evitals/blood_pressure:1/encoding|terminology": "IANA_character-sets",
"evitals_1_sect/evitals/blood_pressure:1/subject|name": "Timothy",


"evitals_1_sect/evitals/pulse_heart_beat:0/rate|magnitude": 42.4,
"evitals_1_sect/evitals/pulse_heart_beat:0/rate|unit": "/min",
"evitals_1_sect/evitals/pulse_heart_beat:0/time": "{% now 'iso-8601', '' %}",

"evitals_1_sect/evitals/pulse_heart_beat:0/language|code": "en",
"evitals_1_sect/evitals/pulse_heart_beat:0/language|terminology": "ISO_639-1",
"evitals_1_sect/evitals/pulse_heart_beat:0/encoding|code": "UTF-8",
"evitals_1_sect/evitals/pulse_heart_beat:0/encoding|terminology": "IANA_character-sets",
"evitals_1_sect/evitals/pulse_heart_beat:0/subject|name": "Timothy",

"evitals_1_sect/evitals/pulse_heart_beat:1/rate|magnitude": 29,
"evitals_1_sect/evitals/pulse_heart_beat:1/rate|unit": "/min",
"evitals_1_sect/evitals/pulse_heart_beat:1/time": "{% now 'iso-8601', '' %}",

"evitals_1_sect/evitals/pulse_heart_beat:1/language|code": "en",
"evitals_1_sect/evitals/pulse_heart_beat:1/language|terminology": "ISO_639-1",
"evitals_1_sect/evitals/pulse_heart_beat:1/encoding|code": "UTF-8",
"evitals_1_sect/evitals/pulse_heart_beat:1/encoding|terminology": "IANA_character-sets",
"evitals_1_sect/evitals/pulse_heart_beat:1/subject|name": "Timothy",


"evitals_1_sect/evitals/respiration:0/rate|magnitude": 22.4,
"evitals_1_sect/evitals/respiration:0/rate|unit": "/min",
"evitals_1_sect/evitals/respiration:0/time": "{% now 'iso-8601', '' %}",

"evitals_1_sect/evitals/respiration:0/language|code": "en",
"evitals_1_sect/evitals/respiration:0/language|terminology": "ISO_639-1",
"evitals_1_sect/evitals/respiration:0/encoding|code": "UTF-8",
"evitals_1_sect/evitals/respiration:0/encoding|terminology": "IANA_character-sets",
"evitals_1_sect/evitals/respiration:0/subject|name": "Timothy",

"evitals_1_sect/evitals/respiration:1/rate|magnitude": 14,
"evitals_1_sect/evitals/respiration:1/rate|unit": "/min",
"evitals_1_sect/evitals/respiration:1/time": "{% now 'iso-8601', '' %}",

"evitals_1_sect/evitals/respiration:1/language|code": "en",
"evitals_1_sect/evitals/respiration:1/language|terminology": "ISO_639-1",
"evitals_1_sect/evitals/respiration:1/encoding|code": "UTF-8",
"evitals_1_sect/evitals/respiration:1/encoding|terminology": "IANA_character-sets",
"evitals_1_sect/evitals/respiration:1/subject|name": "Timothy",


"evitals_1_sect/evitals/body_mass_index:0/body_mass_index|magnitude": 61.9,
"evitals_1_sect/evitals/body_mass_index:0/body_mass_index|unit": "kg/m2",
"evitals_1_sect/evitals/body_mass_index:0/time": "{% now 'iso-8601', '' %}",

"evitals_1_sect/evitals/body_mass_index:0/language|code": "en",
"evitals_1_sect/evitals/body_mass_index:0/language|terminology": "ISO_639-1",
"evitals_1_sect/evitals/body_mass_index:0/encoding|code": "UTF-8",
"evitals_1_sect/evitals/body_mass_index:0/encoding|terminology": "IANA_character-sets",
"evitals_1_sect/evitals/body_mass_index:0/subject|name": "Timothy",

"evitals_1_sect/evitals/body_mass_index:1/body_mass_index|magnitude": 90,
"evitals_1_sect/evitals/body_mass_index:1/body_mass_index|unit": "kg/m2",
"evitals_1_sect/evitals/body_mass_index:1/time": "{% now 'iso-8601', '' %}",

"evitals_1_sect/evitals/body_mass_index:1/language|code": "en",
"evitals_1_sect/evitals/body_mass_index:1/language|terminology": "ISO_639-1",
"evitals_1_sect/evitals/body_mass_index:1/encoding|code": "UTF-8",
"evitals_1_sect/evitals/body_mass_index:1/encoding|terminology": "IANA_character-sets",
"evitals_1_sect/evitals/body_mass_index:1/subject|name": "Timothy",


"evitals_1_sect/evitals/body_weight:0/weight|magnitude": 98.7,
"evitals_1_sect/evitals/body_weight:0/weight|unit": "kg",
"evitals_1_sect/evitals/body_weight:0/time": "{% now 'iso-8601', '' %}",

"evitals_1_sect/evitals/body_weight:0/language|code": "en",
"evitals_1_sect/evitals/body_weight:0/language|terminology": "ISO_639-1",
"evitals_1_sect/evitals/body_weight:0/encoding|code": "UTF-8",
"evitals_1_sect/evitals/body_weight:0/encoding|terminology": "IANA_character-sets",
"evitals_1_sect/evitals/body_weight:0/subject|name": "Timothy",

"evitals_1_sect/evitals/body_weight:1/weight|magnitude": 120,
"evitals_1_sect/evitals/body_weight:1/weight|unit": "kg",
"evitals_1_sect/evitals/body_weight:1/time": "{% now 'iso-8601', '' %}",

"evitals_1_sect/evitals/body_weight:1/language|code": "en",
"evitals_1_sect/evitals/body_weight:1/language|terminology": "ISO_639-1",
"evitals_1_sect/evitals/body_weight:1/encoding|code": "UTF-8",
"evitals_1_sect/evitals/body_weight:1/encoding|terminology": "IANA_character-sets",
"evitals_1_sect/evitals/body_weight:1/subject|name": "Timothy",


"evitals_1_sect/evitals/height_length:0/height_length|magnitude": 82.3,
"evitals_1_sect/evitals/height_length:0/height_length|unit": "cm",
"evitals_1_sect/evitals/height_length:0/time": "{% now 'iso-8601', '' %}",

"evitals_1_sect/evitals/height_length:0/language|code": "en",
"evitals_1_sect/evitals/height_length:0/language|terminology": "ISO_639-1",
"evitals_1_sect/evitals/height_length:0/encoding|code": "UTF-8",
"evitals_1_sect/evitals/height_length:0/encoding|terminology": "IANA_character-sets",
"evitals_1_sect/evitals/height_length:0/subject|name": "Timothy",

"evitals_1_sect/evitals/height_length:1/height_length|magnitude": 110,
"evitals_1_sect/evitals/height_length:1/height_length|unit": "cm",
"evitals_1_sect/evitals/height_length:1/time": "{% now 'iso-8601', '' %}",

"evitals_1_sect/evitals/height_length:1/language|code": "en",
"evitals_1_sect/evitals/height_length:1/language|terminology": "ISO_639-1",
"evitals_1_sect/evitals/height_length:1/encoding|code": "UTF-8",
"evitals_1_sect/evitals/height_length:1/encoding|terminology": "IANA_character-sets",
"evitals_1_sect/evitals/height_length:1/subject|name": "Timothy",

"evitals_1_sect/evitals/pulse_oximetry:0/spo|numerator": 79,
"evitals_1_sect/evitals/pulse_oximetry:0/spo|denominator": 100,
"evitals_1_sect/evitals/pulse_oximetry:0/time": "{% now 'iso-8601', '' %}",

"evitals_1_sect/evitals/pulse_oximetry:0/language|code": "en",
"evitals_1_sect/evitals/pulse_oximetry:0/language|terminology": "ISO_639-1",
"evitals_1_sect/evitals/pulse_oximetry:0/encoding|code": "UTF-8",
"evitals_1_sect/evitals/pulse_oximetry:0/encoding|terminology": "IANA_character-sets",
"evitals_1_sect/evitals/pulse_oximetry:0/subject|name": "Timothy",

"evitals_1_sect/evitals/pulse_oximetry:1/spo|numerator": 89,
"evitals_1_sect/evitals/pulse_oximetry:1/spo|denominator": 100,
"evitals_1_sect/evitals/pulse_oximetry:1/time": "{% now 'iso-8601', '' %}",

"evitals_1_sect/evitals/pulse_oximetry:1/language|code": "en",
"evitals_1_sect/evitals/pulse_oximetry:1/language|terminology": "ISO_639-1",
"evitals_1_sect/evitals/pulse_oximetry:1/encoding|code": "UTF-8",
"evitals_1_sect/evitals/pulse_oximetry:1/encoding|terminology": "IANA_character-sets",
"evitals_1_sect/evitals/pulse_oximetry:1/subject|name": "Timothy",

"evitals_1_sect/language|code": "en",
"evitals_1_sect/language|terminology": "ISO_639-1",
"evitals_1_sect/territory|code": "IN",
"evitals_1_sect/territory|terminology": "ISO_3166-1"

}

AQL:

{
“q”: “SELECT DISTINCT c/archetype_details/template_id/value AS template, c/uid/value AS composition_name, c/context/start_time/value AS composition_datetime, c/context/setting/value as setting, c/composer/name as composer, ot/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/magnitude as body_temp_val, ot/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/units as body_temp_units, ot/data[at0002]/events[at0003]/time as body_temp_time, op/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value/magnitude as bp_systolic_value, op/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value/units as bp_systolic_units, op/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value/magnitude as bp_diastolic_value, op/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value/units as bp_diastolic_units, op/data[at0001]/events[at0006]/time as bp_time, oh/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/magnitude as heart_rate_value, oh/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/units as heart_rate_units, oh/data[at0002]/events[at0003]/time as heart_rate_time, orr/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/magnitude as respiration_rate_value, orr/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/units as respiration_rate_units, orr/data[at0001]/events[at0002]/time as respiration_rate_time, ox/data[at0001]/events[at0002]/data[at0003]/items[at0006]/value/numerator as pulse_oximeter_numerator, ox/data[at0001]/events[at0002]/data[at0003]/items[at0006]/value/denominator as pulse_oximeter_denominator, ox/data[at0001]/events[at0002]/time as pulse_oximeter_time, ohe/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/magnitude as height_value, ohe/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/units as height_units, ohe/data[at0001]/events[at0002]/time as height_time FROM EHR e[ehr_id/value=‘{% response ‘body’, ‘req_cce838af0c9e43228128eb8841d62647’, ‘b64::JC5laHJfaWQudmFsdWU=::46b’, ‘never’, 60 %}’] CONTAINS COMPOSITION c[openEHR-EHR-COMPOSITION.encounter.v1] CONTAINS (OBSERVATION ot[openEHR-EHR-OBSERVATION.body_temperature.v2] AND OBSERVATION op[openEHR-EHR-OBSERVATION.blood_pressure.v2] AND OBSERVATION oh[openEHR-EHR-OBSERVATION.pulse.v2] AND OBSERVATION orr[openEHR-EHR-OBSERVATION.respiration.v2] AND OBSERVATION ox[openEHR-EHR-OBSERVATION.pulse_oximetry.v1] AND OBSERVATION ohe[openEHR-EHR-OBSERVATION.height.v2]) WHERE c/archetype_details/template_id/value = ‘eVitals_1_Sect’ ORDER BY c/context/start_time DESC”
}

Response I’m getting:

Incase there are issues viewing the AQL properly:

{
“q”: “SELECT DISTINCT c/archetype_details/template_id/value AS template,
c/uid/value AS composition_name,
c/context/start_time/value AS composition_datetime,
c/context/setting/value as setting,
c/composer/name as composer,
c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.case_identification.v0, ‘Case Identification’]/items[at0001]/value/value AS Case_Identifier,
c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.case_identification.v0, ‘Case Identification’]/items[at0002]/value/value as Case_Started,
c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.case_identification.v0, ‘Case Identification’]/items[at0003]/value/value as Case_Status,
c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_professional_parent.v1, ‘Healthcare Professional’]/items[openEHR-EHR-CLUSTER.structured_name.v1]/items[at0001]/value/value as HC_ProTitle,
c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_professional_parent.v1, ‘Healthcare Professional’]/items[openEHR-EHR-CLUSTER.structured_name.v1]/items[at0002]/value/value as HC_ProGivenName,
c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_professional_parent.v1, ‘Healthcare Professional’]/items[openEHR-EHR-CLUSTER.structured_name.v1]/items[at0005]/value/value as HC_ProFamName,
c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_professional_parent.v1, ‘Healthcare Professional’]/items[openEHR-EHR-CLUSTER.structured_name.v1]/items[at0006]/value/value as HC_ProSuffix,
c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0001]/value/value as HC_OrgName,
c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0002]/value/id as HC_OrgIDNo,
c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0002]/value/type as HC_OrgIDType,
c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0002]/value/issuer as HC_OrgIDIssuer,
c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0002]/value/assigner as HC_OrgIDAssigner,
c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0005]/value/value as HC_OrgDepName,
c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0006]/value/id as HC_OrgDepIDNo,
c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0006]/value/type as HC_OrgDepIDType,
c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0006]/value/issuer as HC_OrgDepIDIssuer,
c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0006]/value/assigner as HC_OrgDepIDAssigner,
ot/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/magnitude as body_temp_val,
ot/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/units as body_temp_units,
ot/data[at0002]/events[at0003]/time as body_temp_time,
op/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value/magnitude as bp_systolic_value,
op/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value/units as bp_systolic_units,
op/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value/magnitude as bp_diastolic_value,
op/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value/units as bp_diastolic_units,
op/data[at0001]/events[at0006]/time as bp_time,
oh/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/magnitude as heart_rate_value,
oh/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/units as heart_rate_units,
oh/data[at0002]/events[at0003]/time as heart_rate_time,
orr/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/magnitude as respiration_rate_value,
orr/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/units as respiration_rate_units,
orr/data[at0001]/events[at0002]/time as respiration_rate_time,
ox/data[at0001]/events[at0002]/data[at0003]/items[at0006]/value/numerator as pulse_oximeter_numerator,
ox/data[at0001]/events[at0002]/data[at0003]/items[at0006]/value/denominator as pulse_oximeter_denominator,
ox/data[at0001]/events[at0002]/time as pulse_oximeter_time,
ohe/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/magnitude as height_value,
ohe/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/units as height_units,
ohe/data[at0001]/events[at0002]/time as height_time FROM EHR e[ehr_id/value=‘{% response ‘body’, ‘req_cce838af0c9e43228128eb8841d62647’, ‘b64::JC5laHJfaWQudmFsdWU=::46b’,
‘never’, 60 %}’]
CONTAINS COMPOSITION c[openEHR-EHR-COMPOSITION.encounter.v1]
CONTAINS (OBSERVATION ot[openEHR-EHR-OBSERVATION.body_temperature.v2] AND
OBSERVATION op[openEHR-EHR-OBSERVATION.blood_pressure.v2] AND
OBSERVATION oh[openEHR-EHR-OBSERVATION.pulse.v2] AND
OBSERVATION orr[openEHR-EHR-OBSERVATION.respiration.v2] AND
OBSERVATION ox[openEHR-EHR-OBSERVATION.pulse_oximetry.v1] AND
OBSERVATION ohe[openEHR-EHR-OBSERVATION.height.v2])
WHERE c/archetype_details/template_id/value = ‘eVitals_1_Sect’ ORDER BY c/context/start_time DESC”
}

Can you send the whole Resultset- I can’t see the duplicates in the screenshot

BTW change your /time AQL to point to the date value itself to simplify the Resultset a little

orr/data[at0001]/events[at0002]/time/value as respiration_rate_time,

As I’m a new user I can’t attach the file, and there is a character limit here.

There are 64 compositions with the same composition uuid

This is a limited response body:
{
“q”: “SELECT DISTINCT c/archetype_details/template_id/value AS template, c/uid/value AS composition_name, c/context/start_time/value AS composition_datetime, c/context/setting/value as setting, c/composer/name as composer, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.case_identification.v0, ‘Case Identification’]/items[at0001]/value/value AS Case_Identifier, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.case_identification.v0, ‘Case Identification’]/items[at0002]/value/value as Case_Started, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.case_identification.v0, ‘Case Identification’]/items[at0003]/value/value as Case_Status, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_professional_parent.v1, ‘Healthcare Professional’]/items[openEHR-EHR-CLUSTER.structured_name.v1]/items[at0001]/value/value as HC_ProTitle, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_professional_parent.v1, ‘Healthcare Professional’]/items[openEHR-EHR-CLUSTER.structured_name.v1]/items[at0002]/value/value as HC_ProGivenName, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_professional_parent.v1, ‘Healthcare Professional’]/items[openEHR-EHR-CLUSTER.structured_name.v1]/items[at0005]/value/value as HC_ProFamName, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_professional_parent.v1, ‘Healthcare Professional’]/items[openEHR-EHR-CLUSTER.structured_name.v1]/items[at0006]/value/value as HC_ProSuffix, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0001]/value/value as HC_OrgName, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0002]/value/id as HC_OrgIDNo, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0002]/value/type as HC_OrgIDType, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0002]/value/issuer as HC_OrgIDIssuer, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0002]/value/assigner as HC_OrgIDAssigner, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0005]/value/value as HC_OrgDepName, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0006]/value/id as HC_OrgDepIDNo, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0006]/value/type as HC_OrgDepIDType, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0006]/value/issuer as HC_OrgDepIDIssuer, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0006]/value/assigner as HC_OrgDepIDAssigner, ot/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/magnitude as body_temp_val, ot/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/units as body_temp_units, ot/data[at0002]/events[at0003]/time as body_temp_time, op/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value/magnitude as bp_systolic_value, op/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value/units as bp_systolic_units, op/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value/magnitude as bp_diastolic_value, op/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value/units as bp_diastolic_units, op/data[at0001]/events[at0006]/time as bp_time, oh/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/magnitude as heart_rate_value, oh/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/units as heart_rate_units, oh/data[at0002]/events[at0003]/time as heart_rate_time, orr/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/magnitude as respiration_rate_value, orr/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/units as respiration_rate_units, orr/data[at0001]/events[at0002]/time as respiration_rate_time, ox/data[at0001]/events[at0002]/data[at0003]/items[at0006]/value/numerator as pulse_oximeter_numerator, ox/data[at0001]/events[at0002]/data[at0003]/items[at0006]/value/denominator as pulse_oximeter_denominator, ox/data[at0001]/events[at0002]/time as pulse_oximeter_time, ohe/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/magnitude as height_value, ohe/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/units as height_units, ohe/data[at0001]/events[at0002]/time as height_time FROM EHR e[ehr_id/value=‘7a6634a0-6e13-4760-a71b-5fa94f199525’] CONTAINS COMPOSITION c[openEHR-EHR-COMPOSITION.encounter.v1] CONTAINS (OBSERVATION ot[openEHR-EHR-OBSERVATION.body_temperature.v2] AND OBSERVATION op[openEHR-EHR-OBSERVATION.blood_pressure.v2] AND OBSERVATION oh[openEHR-EHR-OBSERVATION.pulse.v2] AND OBSERVATION orr[openEHR-EHR-OBSERVATION.respiration.v2] AND OBSERVATION ox[openEHR-EHR-OBSERVATION.pulse_oximetry.v1] AND OBSERVATION ohe[openEHR-EHR-OBSERVATION.height.v2]) WHERE c/archetype_details/template_id/value = ‘eVitals_1_Sect’ ORDER BY c/context/start_time DESC”,
“columns”: [
{
“path”: “/archetype_details/template_id/value”,
“name”: “template”
},
{
“path”: “/uid/value”,
“name”: “composition_name”
},
{
“path”: “/context/start_time/value”,
“name”: “composition_datetime”
},
{
“path”: “/context/setting/value”,
“name”: “setting”
},
{
“path”: “/composer/name”,
“name”: “composer”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.case_identification.v0,‘Case Identification’]/items[at0001]/value/value”,
“name”: “Case_Identifier”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.case_identification.v0,‘Case Identification’]/items[at0002]/value/value”,
“name”: “Case_Started”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.case_identification.v0,‘Case Identification’]/items[at0003]/value/value”,
“name”: “Case_Status”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_professional_parent.v1,‘Healthcare Professional’]/items[openEHR-EHR-CLUSTER.structured_name.v1]/items[at0001]/value/value”,
“name”: “HC_ProTitle”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_professional_parent.v1,‘Healthcare Professional’]/items[openEHR-EHR-CLUSTER.structured_name.v1]/items[at0002]/value/value”,
“name”: “HC_ProGivenName”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_professional_parent.v1,‘Healthcare Professional’]/items[openEHR-EHR-CLUSTER.structured_name.v1]/items[at0005]/value/value”,
“name”: “HC_ProFamName”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_professional_parent.v1,‘Healthcare Professional’]/items[openEHR-EHR-CLUSTER.structured_name.v1]/items[at0006]/value/value”,
“name”: “HC_ProSuffix”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1,‘Healthcare Organization’]/items[at0001]/value/value”,
“name”: “HC_OrgName”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1,‘Healthcare Organization’]/items[at0002]/value/id”,
“name”: “HC_OrgIDNo”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1,‘Healthcare Organization’]/items[at0002]/value/type”,
“name”: “HC_OrgIDType”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1,‘Healthcare Organization’]/items[at0002]/value/issuer”,
“name”: “HC_OrgIDIssuer”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1,‘Healthcare Organization’]/items[at0002]/value/assigner”,
“name”: “HC_OrgIDAssigner”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1,‘Healthcare Organization’]/items[at0005]/value/value”,
“name”: “HC_OrgDepName”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1,‘Healthcare Organization’]/items[at0006]/value/id”,
“name”: “HC_OrgDepIDNo”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1,‘Healthcare Organization’]/items[at0006]/value/type”,
“name”: “HC_OrgDepIDType”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1,‘Healthcare Organization’]/items[at0006]/value/issuer”,
“name”: “HC_OrgDepIDIssuer”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1,‘Healthcare Organization’]/items[at0006]/value/assigner”,
“name”: “HC_OrgDepIDAssigner”
},
{
“path”: “/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/magnitude”,
“name”: “body_temp_val”
},
{
“path”: “/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/units”,
“name”: “body_temp_units”
},
{
“path”: “/data[at0002]/events[at0003]/time”,
“name”: “body_temp_time”
},
{
“path”: “/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value/magnitude”,
“name”: “bp_systolic_value”
},
{
“path”: “/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value/units”,
“name”: “bp_systolic_units”
},
{
“path”: “/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value/magnitude”,
“name”: “bp_diastolic_value”
},
{
“path”: “/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value/units”,
“name”: “bp_diastolic_units”
},
{
“path”: “/data[at0001]/events[at0006]/time”,
“name”: “bp_time”
},
{
“path”: “/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/magnitude”,
“name”: “heart_rate_value”
},
{
“path”: “/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/units”,
“name”: “heart_rate_units”
},
{
“path”: “/data[at0002]/events[at0003]/time”,
“name”: “heart_rate_time”
},
{
“path”: “/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/magnitude”,
“name”: “respiration_rate_value”
},
{
“path”: “/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/units”,
“name”: “respiration_rate_units”
},
{
“path”: “/data[at0001]/events[at0002]/time”,
“name”: “respiration_rate_time”
},
{
“path”: “/data[at0001]/events[at0002]/data[at0003]/items[at0006]/value/numerator”,
“name”: “pulse_oximeter_numerator”
},
{
“path”: “/data[at0001]/events[at0002]/data[at0003]/items[at0006]/value/denominator”,
“name”: “pulse_oximeter_denominator”
},
{
“path”: “/data[at0001]/events[at0002]/time”,
“name”: “pulse_oximeter_time”
},
{
“path”: “/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/magnitude”,
“name”: “height_value”
},
{
“path”: “/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/units”,
“name”: “height_units”
},
{
“path”: “/data[at0001]/events[at0002]/time”,
“name”: “height_time”
}
],
“rows”: [
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
29.0,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
14.0,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
79.0,
100.0,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
82.3,
“cm”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
}
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
29.0,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
14.0,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
79.0,
100.0,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
110.0,
“cm”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
}
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
29.0,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
14.0,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
89.0,
100.0,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
82.3,
“cm”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
}
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
29.0,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
14.0,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
89.0,
100.0,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
110.0,
“cm”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
}
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
29.0,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
22.4,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
79.0,
100.0,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
82.3,
“cm”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
}
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
29.0,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
22.4,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
79.0,
100.0,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
110.0,
“cm”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
}
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
29.0,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
22.4,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
89.0,
100.0,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
82.3,
“cm”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
}
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
29.0,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
22.4,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
89.0,
100.0,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
110.0,
“cm”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
}
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
42.4,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
14.0,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
79.0,
100.0,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
82.3,
“cm”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
}
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
42.4,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
14.0,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
79.0,
100.0,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
110.0,
“cm”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
}
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
42.4,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
14.0,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
89.0,
100.0,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
82.3,
“cm”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
}
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
42.4,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
14.0,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
89.0,
100.0,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
110.0,
“cm”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
}
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
42.4,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
22.4,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
79.0,
100.0,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
82.3,
“cm”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
}
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
42.4,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
22.4,
“/min”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
79.0,
100.0,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
},
110.0,
“cm”,
{
“_type”: “DV_DATE_TIME”,
“value”: “2023-12-12T08:03:21.371Z”
}
]

]

}

I’ve tried doing:
orr/data[at0001]/events[at0002]/time/value as respiration_rate_time

But it returns null.

I’ve settled with:
orr/data[at0001]/events[at0002]/time as respiration_rate_time

which returns the json segment of the DV_TIME segment because of that issue.

If there is any fix to that, would also appreciate some help.

Ok I had an issue with the time aql before, but it seems to be working now.
Thanks

The duplicate response is still appearing though

1 Like

Again there at 64 compositions with the same composition uuids
Updated response body:

{
“q”: “SELECT DISTINCT c/archetype_details/template_id/value AS template, c/uid/value AS composition_name, c/context/start_time/value AS composition_datetime, c/context/setting/value as setting, c/composer/name as composer, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.case_identification.v0, ‘Case Identification’]/items[at0001]/value/value AS Case_Identifier, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.case_identification.v0, ‘Case Identification’]/items[at0002]/value/value as Case_Started, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.case_identification.v0, ‘Case Identification’]/items[at0003]/value/value as Case_Status, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_professional_parent.v1, ‘Healthcare Professional’]/items[openEHR-EHR-CLUSTER.structured_name.v1]/items[at0001]/value/value as HC_ProTitle, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_professional_parent.v1, ‘Healthcare Professional’]/items[openEHR-EHR-CLUSTER.structured_name.v1]/items[at0002]/value/value as HC_ProGivenName, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_professional_parent.v1, ‘Healthcare Professional’]/items[openEHR-EHR-CLUSTER.structured_name.v1]/items[at0005]/value/value as HC_ProFamName, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_professional_parent.v1, ‘Healthcare Professional’]/items[openEHR-EHR-CLUSTER.structured_name.v1]/items[at0006]/value/value as HC_ProSuffix, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0001]/value/value as HC_OrgName, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0002]/value/id as HC_OrgIDNo, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0002]/value/type as HC_OrgIDType, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0002]/value/issuer as HC_OrgIDIssuer, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0002]/value/assigner as HC_OrgIDAssigner, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0005]/value/value as HC_OrgDepName, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0006]/value/id as HC_OrgDepIDNo, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0006]/value/type as HC_OrgDepIDType, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0006]/value/issuer as HC_OrgDepIDIssuer, c/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1, ‘Healthcare Organization’]/items[at0006]/value/assigner as HC_OrgDepIDAssigner, ot/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/magnitude as body_temp_val, ot/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/units as body_temp_units, ot/data[at0002]/events[at0003]/time/value as body_temp_time, op/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value/magnitude as bp_systolic_value, op/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value/units as bp_systolic_units, op/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value/magnitude as bp_diastolic_value, op/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value/units as bp_diastolic_units, op/data[at0001]/events[at0006]/time/value as bp_time, oh/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/magnitude as heart_rate_value, oh/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/units as heart_rate_units, oh/data[at0002]/events[at0003]/time/value as heart_rate_time, orr/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/magnitude as respiration_rate_value, orr/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/units as respiration_rate_units, orr/data[at0001]/events[at0002]/time/value as respiration_rate_time, ox/data[at0001]/events[at0002]/data[at0003]/items[at0006]/value/numerator as pulse_oximeter_numerator, ox/data[at0001]/events[at0002]/data[at0003]/items[at0006]/value/denominator as pulse_oximeter_denominator, ox/data[at0001]/events[at0002]/time/value as pulse_oximeter_time, ohe/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/magnitude as height_value, ohe/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/units as height_units, ohe/data[at0001]/events[at0002]/time/value as height_time FROM EHR e[ehr_id/value=‘7a6634a0-6e13-4760-a71b-5fa94f199525’] CONTAINS COMPOSITION c[openEHR-EHR-COMPOSITION.encounter.v1] CONTAINS (OBSERVATION ot[openEHR-EHR-OBSERVATION.body_temperature.v2] AND OBSERVATION op[openEHR-EHR-OBSERVATION.blood_pressure.v2] AND OBSERVATION oh[openEHR-EHR-OBSERVATION.pulse.v2] AND OBSERVATION orr[openEHR-EHR-OBSERVATION.respiration.v2] AND OBSERVATION ox[openEHR-EHR-OBSERVATION.pulse_oximetry.v1] AND OBSERVATION ohe[openEHR-EHR-OBSERVATION.height.v2]) WHERE c/archetype_details/template_id/value = ‘eVitals_1_Sect’ ORDER BY c/context/start_time DESC”,
“columns”: [
{
“path”: “/archetype_details/template_id/value”,
“name”: “template”
},
{
“path”: “/uid/value”,
“name”: “composition_name”
},
{
“path”: “/context/start_time/value”,
“name”: “composition_datetime”
},
{
“path”: “/context/setting/value”,
“name”: “setting”
},
{
“path”: “/composer/name”,
“name”: “composer”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.case_identification.v0,‘Case Identification’]/items[at0001]/value/value”,
“name”: “Case_Identifier”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.case_identification.v0,‘Case Identification’]/items[at0002]/value/value”,
“name”: “Case_Started”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.case_identification.v0,‘Case Identification’]/items[at0003]/value/value”,
“name”: “Case_Status”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_professional_parent.v1,‘Healthcare Professional’]/items[openEHR-EHR-CLUSTER.structured_name.v1]/items[at0001]/value/value”,
“name”: “HC_ProTitle”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_professional_parent.v1,‘Healthcare Professional’]/items[openEHR-EHR-CLUSTER.structured_name.v1]/items[at0002]/value/value”,
“name”: “HC_ProGivenName”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_professional_parent.v1,‘Healthcare Professional’]/items[openEHR-EHR-CLUSTER.structured_name.v1]/items[at0005]/value/value”,
“name”: “HC_ProFamName”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_professional_parent.v1,‘Healthcare Professional’]/items[openEHR-EHR-CLUSTER.structured_name.v1]/items[at0006]/value/value”,
“name”: “HC_ProSuffix”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1,‘Healthcare Organization’]/items[at0001]/value/value”,
“name”: “HC_OrgName”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1,‘Healthcare Organization’]/items[at0002]/value/id”,
“name”: “HC_OrgIDNo”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1,‘Healthcare Organization’]/items[at0002]/value/type”,
“name”: “HC_OrgIDType”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1,‘Healthcare Organization’]/items[at0002]/value/issuer”,
“name”: “HC_OrgIDIssuer”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1,‘Healthcare Organization’]/items[at0002]/value/assigner”,
“name”: “HC_OrgIDAssigner”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1,‘Healthcare Organization’]/items[at0005]/value/value”,
“name”: “HC_OrgDepName”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1,‘Healthcare Organization’]/items[at0006]/value/id”,
“name”: “HC_OrgDepIDNo”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1,‘Healthcare Organization’]/items[at0006]/value/type”,
“name”: “HC_OrgDepIDType”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1,‘Healthcare Organization’]/items[at0006]/value/issuer”,
“name”: “HC_OrgDepIDIssuer”
},
{
“path”: “/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.healthcare_provider_parent.v1,‘Healthcare Organization’]/items[at0006]/value/assigner”,
“name”: “HC_OrgDepIDAssigner”
},
{
“path”: “/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/magnitude”,
“name”: “body_temp_val”
},
{
“path”: “/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/units”,
“name”: “body_temp_units”
},
{
“path”: “/data[at0002]/events[at0003]/time/value”,
“name”: “body_temp_time”
},
{
“path”: “/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value/magnitude”,
“name”: “bp_systolic_value”
},
{
“path”: “/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value/units”,
“name”: “bp_systolic_units”
},
{
“path”: “/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value/magnitude”,
“name”: “bp_diastolic_value”
},
{
“path”: “/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value/units”,
“name”: “bp_diastolic_units”
},
{
“path”: “/data[at0001]/events[at0006]/time/value”,
“name”: “bp_time”
},
{
“path”: “/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/magnitude”,
“name”: “heart_rate_value”
},
{
“path”: “/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value/units”,
“name”: “heart_rate_units”
},
{
“path”: “/data[at0002]/events[at0003]/time/value”,
“name”: “heart_rate_time”
},
{
“path”: “/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/magnitude”,
“name”: “respiration_rate_value”
},
{
“path”: “/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/units”,
“name”: “respiration_rate_units”
},
{
“path”: “/data[at0001]/events[at0002]/time/value”,
“name”: “respiration_rate_time”
},
{
“path”: “/data[at0001]/events[at0002]/data[at0003]/items[at0006]/value/numerator”,
“name”: “pulse_oximeter_numerator”
},
{
“path”: “/data[at0001]/events[at0002]/data[at0003]/items[at0006]/value/denominator”,
“name”: “pulse_oximeter_denominator”
},
{
“path”: “/data[at0001]/events[at0002]/time/value”,
“name”: “pulse_oximeter_time”
},
{
“path”: “/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/magnitude”,
“name”: “height_value”
},
{
“path”: “/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value/units”,
“name”: “height_units”
},
{
“path”: “/data[at0001]/events[at0002]/time/value”,
“name”: “height_time”
}
],
“rows”: [
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
“2023-12-12T08:03:21.371Z”,
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
“2023-12-12T08:03:21.371Z”,
29.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
14.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
79.0,
100.0,
“2023-12-12T08:03:21.371Z”,
82.3,
“cm”,
“2023-12-12T08:03:21.371Z”
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
“2023-12-12T08:03:21.371Z”,
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
“2023-12-12T08:03:21.371Z”,
29.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
14.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
79.0,
100.0,
“2023-12-12T08:03:21.371Z”,
110.0,
“cm”,
“2023-12-12T08:03:21.371Z”
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
“2023-12-12T08:03:21.371Z”,
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
“2023-12-12T08:03:21.371Z”,
29.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
14.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
89.0,
100.0,
“2023-12-12T08:03:21.371Z”,
82.3,
“cm”,
“2023-12-12T08:03:21.371Z”
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
“2023-12-12T08:03:21.371Z”,
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
“2023-12-12T08:03:21.371Z”,
29.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
14.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
89.0,
100.0,
“2023-12-12T08:03:21.371Z”,
110.0,
“cm”,
“2023-12-12T08:03:21.371Z”
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
“2023-12-12T08:03:21.371Z”,
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
“2023-12-12T08:03:21.371Z”,
29.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
22.4,
“/min”,
“2023-12-12T08:03:21.371Z”,
79.0,
100.0,
“2023-12-12T08:03:21.371Z”,
82.3,
“cm”,
“2023-12-12T08:03:21.371Z”
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
“2023-12-12T08:03:21.371Z”,
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
“2023-12-12T08:03:21.371Z”,
29.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
22.4,
“/min”,
“2023-12-12T08:03:21.371Z”,
79.0,
100.0,
“2023-12-12T08:03:21.371Z”,
110.0,
“cm”,
“2023-12-12T08:03:21.371Z”
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
“2023-12-12T08:03:21.371Z”,
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
“2023-12-12T08:03:21.371Z”,
29.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
22.4,
“/min”,
“2023-12-12T08:03:21.371Z”,
89.0,
100.0,
“2023-12-12T08:03:21.371Z”,
82.3,
“cm”,
“2023-12-12T08:03:21.371Z”
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
“2023-12-12T08:03:21.371Z”,
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
“2023-12-12T08:03:21.371Z”,
29.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
22.4,
“/min”,
“2023-12-12T08:03:21.371Z”,
89.0,
100.0,
“2023-12-12T08:03:21.371Z”,
110.0,
“cm”,
“2023-12-12T08:03:21.371Z”
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
“2023-12-12T08:03:21.371Z”,
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
“2023-12-12T08:03:21.371Z”,
42.4,
“/min”,
“2023-12-12T08:03:21.371Z”,
14.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
79.0,
100.0,
“2023-12-12T08:03:21.371Z”,
82.3,
“cm”,
“2023-12-12T08:03:21.371Z”
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
“2023-12-12T08:03:21.371Z”,
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
“2023-12-12T08:03:21.371Z”,
42.4,
“/min”,
“2023-12-12T08:03:21.371Z”,
14.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
79.0,
100.0,
“2023-12-12T08:03:21.371Z”,
110.0,
“cm”,
“2023-12-12T08:03:21.371Z”
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
“2023-12-12T08:03:21.371Z”,
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
“2023-12-12T08:03:21.371Z”,
42.4,
“/min”,
“2023-12-12T08:03:21.371Z”,
14.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
89.0,
100.0,
“2023-12-12T08:03:21.371Z”,
82.3,
“cm”,
“2023-12-12T08:03:21.371Z”
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
“2023-12-12T08:03:21.371Z”,
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
“2023-12-12T08:03:21.371Z”,
42.4,
“/min”,
“2023-12-12T08:03:21.371Z”,
14.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
89.0,
100.0,
“2023-12-12T08:03:21.371Z”,
110.0,
“cm”,
“2023-12-12T08:03:21.371Z”
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
“2023-12-12T08:03:21.371Z”,
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
“2023-12-12T08:03:21.371Z”,
42.4,
“/min”,
“2023-12-12T08:03:21.371Z”,
22.4,
“/min”,
“2023-12-12T08:03:21.371Z”,
79.0,
100.0,
“2023-12-12T08:03:21.371Z”,
82.3,
“cm”,
“2023-12-12T08:03:21.371Z”
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
“2023-12-12T08:03:21.371Z”,
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
“2023-12-12T08:03:21.371Z”,
42.4,
“/min”,
“2023-12-12T08:03:21.371Z”,
22.4,
“/min”,
“2023-12-12T08:03:21.371Z”,
79.0,
100.0,
“2023-12-12T08:03:21.371Z”,
110.0,
“cm”,
“2023-12-12T08:03:21.371Z”
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
“2023-12-12T08:03:21.371Z”,
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
“2023-12-12T08:03:21.371Z”,
42.4,
“/min”,
“2023-12-12T08:03:21.371Z”,
22.4,
“/min”,
“2023-12-12T08:03:21.371Z”,
89.0,
100.0,
“2023-12-12T08:03:21.371Z”,
82.3,
“cm”,
“2023-12-12T08:03:21.371Z”
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
“2023-12-12T08:03:21.371Z”,
21.9,
“mm[Hg]”,
67.1,
“mm[Hg]”,
“2023-12-12T08:03:21.371Z”,
42.4,
“/min”,
“2023-12-12T08:03:21.371Z”,
22.4,
“/min”,
“2023-12-12T08:03:21.371Z”,
89.0,
100.0,
“2023-12-12T08:03:21.371Z”,
110.0,
“cm”,
“2023-12-12T08:03:21.371Z”
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
“2023-12-12T08:03:21.371Z”,
34.0,
“mm[Hg]”,
67.1,
“mm[Hg]”,
“2023-12-12T08:03:21.371Z”,
29.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
14.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
79.0,
100.0,
“2023-12-12T08:03:21.371Z”,
82.3,
“cm”,
“2023-12-12T08:03:21.371Z”
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
“2023-12-12T08:03:21.371Z”,
34.0,
“mm[Hg]”,
67.1,
“mm[Hg]”,
“2023-12-12T08:03:21.371Z”,
29.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
14.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
79.0,
100.0,
“2023-12-12T08:03:21.371Z”,
110.0,
“cm”,
“2023-12-12T08:03:21.371Z”
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
“2023-12-12T08:03:21.371Z”,
34.0,
“mm[Hg]”,
67.1,
“mm[Hg]”,
“2023-12-12T08:03:21.371Z”,
29.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
14.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
89.0,
100.0,
“2023-12-12T08:03:21.371Z”,
82.3,
“cm”,
“2023-12-12T08:03:21.371Z”
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
“2023-12-12T08:03:21.371Z”,
34.0,
“mm[Hg]”,
67.1,
“mm[Hg]”,
“2023-12-12T08:03:21.371Z”,
29.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
14.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
89.0,
100.0,
“2023-12-12T08:03:21.371Z”,
110.0,
“cm”,
“2023-12-12T08:03:21.371Z”
],
[
“eVitals_1_Sect”,
“71c0359a-2d6a-4a27-9e1d-7ecf1f571a9d::local.ehrbase.org::1”,
“2023-12-12T08:03:21.371Z”,
“primary medical care”,
“Spiderman 2”,
“9650b62c-91eb-4458-b0af-81a2fb49cf78”,
“2023-12-12T08:03:21.371Z”,
“Completed”,
“Dr.”,
“Harry”,
“Potter”,
“MD”,
“Central Hospital of Hogwarts”,
“1232”,
“Medical Hospital”,
“Wizarding World”,
“Umbridge”,
“Cardiac Center”,
“de8b460c-96b3-4643-be7f-f1bfccd090b8”,
“card”,
“Hogwarts”,
“Albus Dumbledore”,
24.1,
“Cel”,
“2023-12-12T08:03:21.371Z”,
34.0,
“mm[Hg]”,
67.1,
“mm[Hg]”,
“2023-12-12T08:03:21.371Z”,
29.0,
“/min”,
“2023-12-12T08:03:21.371Z”,
22.4,
“/min”,
“2023-12-12T08:03:21.371Z”,
79.0,
100.0,
“2023-12-12T08:03:21.371Z”,
82.3,
“cm”,
“2023-12-12T08:03:21.371Z”
]
]
}

I think you are encountering a ‘known issue’ with AQL and other query languages that my tech colleagues would explain as being a cartesian product’. It is not a bug as such just a consequence of the way that querying engines handle arrays within arrays

Better AQL has a custom Squash() function

“When you data model has arrays nested within the arrays, the result set is a cartesian product. Usually you group values by a specific key on the client side, but SQUASH allows you to group it by the key within the result set itself.“

There is discussion with SEC about making SQUAH() or similar, part of the AQL spec.

@birger.haarbrandt - any plans for EhrBase ot support Squash()?

In the meantime AFAIK, there is not much you can do other than to post-process, or run your queries slightly differently to minimise the issue.

Hey @ian.mcnicoll,

at the moment this is not on the roadmap. I think we should standardize Squash for AQL as part of the spec and if enough people demand it, we can take a look :slight_smile:

2 Likes

I think for situations where vital summaries and reports with multiple data points need to be presented it would be a good feature to have. The work arounds seem to defeat the benefit of AQL, as it just ends up being json parsing and prevents additional filteration (via where clauses) efficiently…

Also a general observation with single vital point retrieval is that it takes between 1.3-1.4 seconds to give a response on a local machine server (with 10 compositions on db), even with multiple tries. I haven’t tested this with large numbers of composition data (1000+), but 1.3-1.4 seconds feels kind of long for this small a db. I doubt it is the processing delay of my machine, as its not an old machine.

Hi Vishnu,

performance sounds questionable indeed. In any case, the new version of EHRbase with all new AQL engine will become available within the first quarter next year.

We will check with other users and then we will discuss how to bring squash on the roadmap for later next year. I agree that it will be beneficial for such situations,

I appreciate the responses @birger.haarbrandt and @ian.mcnicoll.
Looking forward to the newer releases.

Bumping this topic, tried to do

Select count(e/ehr_id/value) from EHR e contains COMPOSITION c contains OBSERVATION o [openEHR-EHR-OBSERVATION.age_assertion.v1] and EVALUATION problem [openEHR-EHR-EVALUATION.problem_diagnosis.v1]
and got the same issue, I’m assuming I’ll have to do all query paths from composition.

Also tried

WHERE o/subject/external_ref/id/value=problem/subject/external_ref/id/value

to solve the issue but that isn’t supported

Hey @yampeku,

could you elaborate which issue try to resolve? Especially the WHERE clause you tried confuses me. So would be good to have some clarification so we can reproduce.

Oh sure, by putting both the evaluation and the observation in the contains produces the issue described on this post (getting extra compositions). I’m not aware of the squash function being implemented, so I was trying to solve it in another way. What I tried to accomplish was to reduce the possible returned combinations by passing and extra condition with the subject (essentially turning the query into a join). This gives me the error “Bad request: Not implemented: only primitive operands are supported”

Ah, got it! We considered Sub-Selects, but this is way down the road I’m afraid. So apologies for not having a solution for now, we still have to determine how we can put Squash on the roadmap.

1 Like

I would definitely support adding Squash() but it would be best if we got this properly part of the AQL spec.

1 Like