Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

wrong number of Collums number in aql request with 2 columns with the same path #263

Closed
stefanspiska opened this issue Jun 16, 2020 · 0 comments · Fixed by #290
Closed
Assignees
Labels
bug Something isn't working

Comments

@stefanspiska
Copy link
Contributor

The query
Select o0/data[at0001]/events[at0002]/data[at0003]/items[at0022]/items[at0005]/value/defining_code, o1/data[at0001]/events[at0002]/data[at0003]/items[at0022]/items[at0005]/value/defining_code from EHR e contains COMPOSITION c2[openEHR-EHR-COMPOSITION.report.v1]contains SECTION s3[openEHR-EHR-SECTION.adhoc.v1]contains (OBSERVATION o0[openEHR-EHR-OBSERVATION.symptom_sign_screening.v0] and OBSERVATION o1[openEHR-EHR-OBSERVATION.symptom_sign_screening.v0]) where e/ehr_id/value = '9216af0e-1989-4dd2-a79e-0f300044c8a4'

returns only one row. where
Select o0/data[at0001]/events[at0002]/data[at0003]/items[at0022]/items[at0005]/value/defining_code as a, o1/data[at0001]/events[at0002]/data[at0003]/items[at0022]/items[at0005]/value/defining_code as b from EHR e contains COMPOSITION c2[openEHR-EHR-COMPOSITION.report.v1]contains SECTION s3[openEHR-EHR-SECTION.adhoc.v1]contains (OBSERVATION o0[openEHR-EHR-OBSERVATION.symptom_sign_screening.v0] and OBSERVATION o1[openEHR-EHR-OBSERVATION.symptom_sign_screening.v0]) where e/ehr_id/value = '9216af0e-1989-4dd2-a79e-0f300044c8a4'

correctly returns two

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants