我在Couchbase中有以下json作为条目:
{
"messageType": "TRANS",
"failCount": 0,
"workOrderDetailMap": {
"10873": {
"requestDate": "20160715151239",
"id": 10873,
"responseDate": "20160715151305",
"responseCode": 0,
"status": "SUCCESS",
"resultDocuments": [
"xyz"
]
}
}
}
我想resultCode
通过N1QL查询获取字段:
Select * from myproject where workOrderDetailMap.responseCode = 0;
我得到0个结果。
我怎样才能做到这一点 ?
你需要
select * from myproject where workOrderDetailMap.`10873`.responseCode = 0;
如果您需要忽略10873:
select * from myproject where object_values(workOrderDetailMap)[0].responseCode = 0;
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句