<filename>src/main/resources/queries/Diagnose.json
{
  "q": "SELECT x/data[at0001]/items[at0002]/value/value as diagnosis, x/data[at0001]/items[at0077]/value/value as time FROM EHR e CONTAINS COMPOSITION c CONTAINS EVALUATION x[openEHR-EHR-EVALUATION.problem_diagnosis.v1] where e/ehr_id/value = $ehr_id order by x/data[at0001]/items[at0077]/value/value desc",
  "offset": 0,
  "fetch": 20,
  "query_parameters": {
    "ehr_id": "__set_by_testehr__"
  }
}