現有數據如下
{
"_id" : ObjectId("5992c90beeb45634df1c2be4"),
"name" : "測試數據1",
"status" : {
"product" : [
{
"id" : ObjectId("59a37f7aef887a1d58b59f4f"),
"sort" : 2
},
{
"id" : ObjectId("59a37f7bef887a1d58b59f50"),
"sort" : 54
},
{
"id" : ObjectId("59a3801cef887a1d58b59f55"),
"sort" : 66
}
],
"line":[]
}
},
{
"_id" : ObjectId("599e7dc07780bbfa9bee42a9"),
"name" : "test數據2",
"status" : {
"product" : [
{
"id" : ObjectId("59a37f7aef887a1d58b59f4f"),
"sort" : 1
},
{
"id" : ObjectId("59a37f7bef887a1d58b59f50"),
"sort" : 30
},
{
"id" : ObjectId("59a3801cef887a1d58b59f55"),
"sort" : 60
}
],
"line":[]
}
}
......
我想要把整個集合按照status.product里的id=ObjectId("59a37f7aef887a1d58b59f4f")的數據對應的sort字段進行倒序排序，查詢語句應該怎么寫呢？
Mongodb 如何按照內嵌文檔的某個字段排序？
慕碼人8056858
2019-03-15 06:00:25