Skip to content

Problem with AQL on other_context extension cluster #185

@dileep-ehr

Description

@dileep-ehr

EHRC - Complaints.zip
Please see the attached template set. We have added a custom cluster to extend the context information (openEHR-EHR-CLUSTER.ehrc_metadata.v0).
While building the AQL, if we include this in CONTAINS we get '204 No Content'.

{"aql":"select a/uid/value as uid, a/composer/name as author, a/name/value as concept, a/context/start_time/value as date_created, c/items[at0001]/value/magnitude as confidentialLeve FROM EHR e[ehr_id/value ='{{ehrId}}' ] CONTAINS COMPOSITION a[openEHR-EHR-COMPOSITION.encounter.v1] CONTAINS EVALUATION b[openEHR-EHR-EVALUATION.medication_summary.v0] AND CLUSTER c[openEHR-EHR-CLUSTER.ehrc_metadata.v0]"
}

We are able to get the result properly if we remove the cluster from CONTAINS and give full path in the AQL

{"aql":"select a/uid/value as uid, a/composer/name as author, a/name/value as concept, a/context/start_time/value as date_created, a/context/other_context[at0001]/items[openEHR-EHR-CLUSTER.ehrc_metadata.v0]/items[at0001]/value/magnitude as confidentialLeve FROM EHR e[ehr_id/value ='{{ehrId}}' ] CONTAINS COMPOSITION a[openEHR-EHR-COMPOSITION.encounter.v1] CONTAINS EVALUATION b[openEHR-EHR-EVALUATION.medication_summary.v0]"
}

We have tried different options for the CONTAINS, but are getting the same results

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions