and closer to your test aql
{
"meta": {
"_type": "RESULTSET",
"_created": "2020-07-30T17:06:34.382Z",
"_executed_aql": "select a_a from EHR e contains COMPOSITION a contains ACTION a_a[openEHR-EHR-ACTION.service.v0] where a_a/ism_transition/current_state/defining_code/code_string = '526'\n"
},
"q": "select a_a from EHR e contains COMPOSITION a contains ACTION a_a[openEHR-EHR-ACTION.service.v0] where a_a/ism_transition/current_state/defining_code/code_string = '526'\n",
"columns": [
{
"name": "#0",
"path": "/"
}
],
"rows": [
[
{
"_type": "ACTION",
"name": {
"_type": "DV_TEXT",
"value": "Service"
},
"archetype_details": {
"_type": "ARCHETYPED",
"archetype_id": {
"_type": "ARCHETYPE_ID",
"value": "openEHR-EHR-ACTION.service.v0"
},
"rm_version": "1.0.4"
},
"archetype_node_id": "openEHR-EHR-ACTION.service.v0",
"language": {
"_type": "CODE_PHRASE",
"terminology_id": {
"_type": "TERMINOLOGY_ID",
"value": "ISO_639-1"
},
"code_string": "en"
},
"encoding": {
"_type": "CODE_PHRASE",
"terminology_id": {
"_type": "TERMINOLOGY_ID",
"value": "IANA_character-sets"
},
"code_string": "UTF-8"
},
"subject": {
"_type": "PARTY_SELF"
},
"protocol": {
"_type": "ITEM_TREE",
"name": {
"_type": "DV_TEXT",
"value": "Tree"
},
"archetype_node_id": "at0015",
"items": [
{
"_type": "ELEMENT",
"name": {
"_type": "DV_TEXT",
"value": "Receiver identifier"
},
"archetype_node_id": "at0018",
"value": {
"_type": "DV_TEXT",
"value": "3f74c2e6-2ae0-4680-b8b2-c6daec8f9309"
}
}
]
},
"time": {
"_type": "DV_DATE_TIME",
"value": "2020-07-30T16:59:02.097Z"
},
"description": {
"_type": "ITEM_TREE",
"name": {
"_type": "DV_TEXT",
"value": "Tree"
},
"archetype_node_id": "at0001",
"items": [
{
"_type": "ELEMENT",
"name": {
"_type": "DV_TEXT",
"value": "Service name"
},
"archetype_node_id": "at0011",
"value": {
"_type": "DV_TEXT",
"value": "Orthopaedics"
}
}
]
},
"ism_transition": {
"_type": "ISM_TRANSITION",
"current_state": {
"_type": "DV_CODED_TEXT",
"value": "planned",
"defining_code": {
"_type": "CODE_PHRASE",
"terminology_id": {
"_type": "TERMINOLOGY_ID",
"value": "openehr"
},
"code_string": "526"
}
},
"careflow_step": {
"_type": "DV_CODED_TEXT",
"value": "Service request sent",
"defining_code": {
"_type": "CODE_PHRASE",
"terminology_id": {
"_type": "TERMINOLOGY_ID",
"value": "local"
},
"code_string": "at0026"
}
}
}
}
],
[
{
"_type": "ACTION",
"name": {
"_type": "DV_TEXT",
"value": "Service"
},
"archetype_details": {
"_type": "ARCHETYPED",
"archetype_id": {
"_type": "ARCHETYPE_ID",
"value": "openEHR-EHR-ACTION.service.v0"
},
"rm_version": "1.0.4"
},
"archetype_node_id": "openEHR-EHR-ACTION.service.v0",
"language": {
"_type": "CODE_PHRASE",
"terminology_id": {
"_type": "TERMINOLOGY_ID",
"value": "ISO_639-1"
},
"code_string": "en"
},
"encoding": {
"_type": "CODE_PHRASE",
"terminology_id": {
"_type": "TERMINOLOGY_ID",
"value": "IANA_character-sets"
},
"code_string": "UTF-8"
},
"subject": {
"_type": "PARTY_SELF"
},
"protocol": {
"_type": "ITEM_TREE",
"name": {
"_type": "DV_TEXT",
"value": "Tree"
},
"archetype_node_id": "at0015",
"items": [
{
"_type": "ELEMENT",
"name": {
"_type": "DV_TEXT",
"value": "Receiver identifier"
},
"archetype_node_id": "at0018",
"value": {
"_type": "DV_TEXT",
"value": "3f74c2e6-2ae0-4680-b8b2-c6daec8f9309"
}
}
]
},
"time": {
"_type": "DV_DATE_TIME",
"value": "2020-07-30T16:59:07.381Z"
},
"description": {
"_type": "ITEM_TREE",
"name": {
"_type": "DV_TEXT",
"value": "Tree"
},
"archetype_node_id": "at0001",
"items": [
{
"_type": "ELEMENT",
"name": {
"_type": "DV_TEXT",
"value": "Service name"
},
"archetype_node_id": "at0011",
"value": {
"_type": "DV_TEXT",
"value": "Dermatology clinic"
}
}
]
},
"ism_transition": {
"_type": "ISM_TRANSITION",
"current_state": {
"_type": "DV_CODED_TEXT",
"value": "planned",
"defining_code": {
"_type": "CODE_PHRASE",
"terminology_id": {
"_type": "TERMINOLOGY_ID",
"value": "openehr"
},
"code_string": "526"
}
},
"careflow_step": {
"_type": "DV_CODED_TEXT",
"value": "Service request sent",
"defining_code": {
"_type": "CODE_PHRASE",
"terminology_id": {
"_type": "TERMINOLOGY_ID",
"value": "local"
},
"code_string": "at0026"
}
}
}
}
],
[
{
"_type": "ACTION",
"name": {
"_type": "DV_TEXT",
"value": "Service"
},
"archetype_details": {
"_type": "ARCHETYPED",
"archetype_id": {
"_type": "ARCHETYPE_ID",
"value": "openEHR-EHR-ACTION.service.v0"
},
"rm_version": "1.0.4"
},
"archetype_node_id": "openEHR-EHR-ACTION.service.v0",
"language": {
"_type": "CODE_PHRASE",
"terminology_id": {
"_type": "TERMINOLOGY_ID",
"value": "ISO_639-1"
},
"code_string": "en"
},
"encoding": {
"_type": "CODE_PHRASE",
"terminology_id": {
"_type": "TERMINOLOGY_ID",
"value": "IANA_character-sets"
},
"code_string": "UTF-8"
},
"subject": {
"_type": "PARTY_SELF"
},
"protocol": {
"_type": "ITEM_TREE",
"name": {
"_type": "DV_TEXT",
"value": "Tree"
},
"archetype_node_id": "at0015",
"items": [
{
"_type": "ELEMENT",
"name": {
"_type": "DV_TEXT",
"value": "Receiver identifier"
},
"archetype_node_id": "at0018",
"value": {
"_type": "DV_TEXT",
"value": "3f74c2e6-2ae0-4680-b8b2-c6daec8f9309"
}
}
]
},
"time": {
"_type": "DV_DATE_TIME",
"value": "2020-07-30T16:59:10.117Z"
},
"description": {
"_type": "ITEM_TREE",
"name": {
"_type": "DV_TEXT",
"value": "Tree"
},
"archetype_node_id": "at0001",
"items": [
{
"_type": "ELEMENT",
"name": {
"_type": "DV_TEXT",
"value": "Service name"
},
"archetype_node_id": "at0011",
"value": {
"_type": "DV_TEXT",
"value": "Physiotherapy"
}
}
]
},
"ism_transition": {
"_type": "ISM_TRANSITION",
"current_state": {
"_type": "DV_CODED_TEXT",
"value": "planned",
"defining_code": {
"_type": "CODE_PHRASE",
"terminology_id": {
"_type": "TERMINOLOGY_ID",
"value": "openehr"
},
"code_string": "526"
}
},
"careflow_step": {
"_type": "DV_CODED_TEXT",
"value": "Service request sent",
"defining_code": {
"_type": "CODE_PHRASE",
"terminology_id": {
"_type": "TERMINOLOGY_ID",
"value": "local"
},
"code_string": "at0026"
}
}
}
}
]
]
}