Skip to content

Problem with AQL on other_context extension cluster #185

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

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

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