You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When executing a specific AQL query in the Cohort-Explorer, the results include more details than specified. Running the same query directly in OpenEHR Studio or a REST API client (e.g., Insomnia) returns the correct results. This indicates a potential issue with how Conhort-Explorer processes or filters AQL query results.
AQL Query in OpenEHR Studio:
AQL Query in Query Builder:
Observed Behavior:
While OpenEHR Studio returned only the specified columns, Cohort-Explorer returns additional data beyond the specified columns. See a segment below:
Configuration information
I have attached the pom.xml file for your reference to provide context on the dependencies and environment used in the project.
Steps to reproduce
Execute the following AQL query in the Cohort-Explorer: SELECT c/content[openEHR-EHR-EVALUATION.problem_diagnosis.v1,'Primärcode']/data[at0001]/items[at0002,'Kodierte Diagnose']/value/value AS Kodierte_Diagnose, c/content[openEHR-EHR-EVALUATION.problem_diagnosis.v1,'Primärcode']/data[at0001]/items[at0002]/value/defining_code/code_string AS Kodierte_Diagnose_code_string FROM EHR e CONTAINS COMPOSITION c
Observe the results returned by Cohort-Explorer.
Execute the same query in OpenEHR Studio or a REST API client (e.g., Insomnia).
`{
"aql": "SELECT c/content[openEHR-EHR-EVALUATION.problem_diagnosis.v1,'Primärcode']/data[at0001]/items[at0002,'Kodierte Diagnose']/value/value AS Kodierte_Diagnose, c/content[openEHR-EHR-EVALUATION.problem_diagnosis.v1,'Primärcode']/data[at0001]/items[at0002]/value/defining_code/code_string AS Kodierte_Diagnose_code_string FROM EHR e CONTAINS COMPOSITION c WHERE c/name/value = 'Diagnose'"
} pom.txt
`
Please let me know if you need any additional information.
The text was updated successfully, but these errors were encountered:
When executing a specific AQL query in the Cohort-Explorer, the results include more details than specified. Running the same query directly in OpenEHR Studio or a REST API client (e.g., Insomnia) returns the correct results. This indicates a potential issue with how Conhort-Explorer processes or filters AQL query results.
AQL Query in OpenEHR Studio:
AQL Query in Query Builder:
Observed Behavior:
While OpenEHR Studio returned only the specified columns, Cohort-Explorer returns additional data beyond the specified columns. See a segment below:
pseudonym diagnose/sekundärcode:0/diagnosesicherheit|code diagnose/primärcode:0/kodierte_diagnose|value diagnose/sekundärcode:0/kodierte_diagnose|code diagnose/sekundärcode:0/kodierte_diagnose|value diagnose/context/case_identification/case_identifier diagnose/context/report_id/_name
Configuration information
I have attached the pom.xml file for your reference to provide context on the dependencies and environment used in the project.
Steps to reproduce
Execute the following AQL query in the Cohort-Explorer:
SELECT c/content[openEHR-EHR-EVALUATION.problem_diagnosis.v1,'Primärcode']/data[at0001]/items[at0002,'Kodierte Diagnose']/value/value AS Kodierte_Diagnose, c/content[openEHR-EHR-EVALUATION.problem_diagnosis.v1,'Primärcode']/data[at0001]/items[at0002]/value/defining_code/code_string AS Kodierte_Diagnose_code_string FROM EHR e CONTAINS COMPOSITION c
Observe the results returned by Cohort-Explorer.
Execute the same query in OpenEHR Studio or a REST API client (e.g., Insomnia).
`{
"aql": "SELECT c/content[openEHR-EHR-EVALUATION.problem_diagnosis.v1,'Primärcode']/data[at0001]/items[at0002,'Kodierte Diagnose']/value/value AS Kodierte_Diagnose, c/content[openEHR-EHR-EVALUATION.problem_diagnosis.v1,'Primärcode']/data[at0001]/items[at0002]/value/defining_code/code_string AS Kodierte_Diagnose_code_string FROM EHR e CONTAINS COMPOSITION c WHERE c/name/value = 'Diagnose'"
}
pom.txt
`
Please let me know if you need any additional information.
The text was updated successfully, but these errors were encountered: