我是ArangoDB和AQL的新手,我的问题与嵌套数组值有关 . 我不知道是否有办法可以做到(或者即使我的查询被有效写入)
为了简短起见,我有2个收藏 . 一个用于“医生”,一个用于“指示” . 每次我的病人看医生进行咨询时,他/她的症状列表都记录在指征集合中 . 但是,之前的诊断可能是由另一位医生做出的 . 在这种情况下,我的AQL语法如下所示:
FOR p in Patients
FILTER p._key=="cad010117"
RETURN {
"name" : CONCAT(p.pfname, " ", p.plastname),
"consultations" : (
FOR i in Indications
FILTER i.pat_id == p._key
FOR d in Physicians
FILTER i.ind_consul_doc == d._key
RETURN {
"Doctor" : CONCAT(d.dtitle, " ", d.dfirstname, " ", d.dlastname),
"Consult Date" : i.ind_consul_dt,
"Symptoms" : i.symptoms[*],
"Past Diagnoses" : i.diagnosis[* RETURN {
"Condition" : CURRENT.diag,
"Diagnosed on" : CURRENT.diag_dt,
"Diagnosed by" : CURRENT.diag_doc
}
]
}
)
我的相应结果:
[
{
"name": "Alfred Jeffries",
"consultations": [
{
"Doctor": "Dr Anthony Garcia",
"Consult Date": "22nd Jun 2016",
"Symptoms": [
{
"type": "hyperpyrexia",
"details": "Temperature: 101",
"duration": "3d"
},
{
"type": "anxiety",
"details": "Severe",
"duration": "1w"
},
{
"type": "mania",
"details": "Moderate",
"duration": "1w"
},
{
"type": "diaphoresis",
"details": "Increased sweating during the day only",
"duration": "3d"
}
],
"Past Diagnoses": [
{
"Condition": "Bipolar Disorder",
"Diagnosed on": "6th Jul 2016",
"Diagnosed by": "dc666555"
}
]
}
]
我的问题是,对于返回的Past Diagnoses数组,diag_doc字段(我的"Indications"集合中诊断数组中的值)对应于进行诊断的医生的"Physicians"集合中的_key值 . 使用AQL返回diag_doc的完整详细信息的最佳方法是什么?先感谢您 .
PS:我正在使用ArangoDB 3.1.12
1 回答
您可以使用子查询从
Physicians
集合中检索数据: