用java操作，
條件：keyID=111111111111且point=A的所有record
這里的point是在remark里面的，而且只顯示point=A和相應的city，其它的B,C都不要
{
"tempList": [
{
"_id": ObjectId("5a6afcfce9ec67213fca393d8"),
"keyID": "111111111111",
"price": 123,
"remark": [
{
"city": "beijing",
"point": "A"
},
{
"city": "shanghai",
"point": "A"
},
{
"city": "guangzhou",
"point": "C"
}
]
},
{
"_id": ObjectId("5a6afcfce2121fca393d8"),
"keyID": "111111111111",
"price": 456,
"remark": [
{
"city": "beijing",
"point": "A"
},
{
"city": "shanghai",
"point": "B"
},
{
"city": "guangzhou",
"point": "C"
}
]
},
{
"_id": ObjectId("5a6afcfce9e32577223d8"),
"keyID": "222222222222",
"price": 789,
"remark": [
{
"city": "beijing",
"point": "A"
},
{
"city": "shanghai",
"point": "B"
},
{
"city": "guangzhou",
"point": "C"
}
]
}
]
}
===============================查詢結果應該如下=================================
{
"tempList": [
{
"_id": ObjectId("5a6afcfce9ec67213fca393d8"),
"keyID": "111111111111",
"price": 123,
"remark": [
{
"city": "beijing",
"point": "A"
},
{
"city": "shanghai",
"point": "A"
}
]
},
{
"_id": ObjectId("5a6afcfce2121fca393d8"),
"keyID": "111111111111",
"price": 456,
"remark": [
{
"city": "beijing",
"point": "A"
}
]
}
]
}
uj5u.com熱心網友回復：
先全部選出來，在條件選擇，eg.foreach ($data as $key => $value) {
foreach ($value['remark'] as $k => $v) {
if ($v['point']!='A') {
unset($data[$key]['remark'][$k]);
}
}
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/98156.html
標籤：MongoDB