db.c_emp.aggregate([
{
$lookup:
{
from: "c_city",
localField: "city",
foreignField: "city",
as: "city_f"
}
},
{
$lookup:
{
from: "c_dept",
localField: "dept",
foreignField: "deptName",
as: "deptName"
}
},
{
$sort:
{
"city_f.id" : -1,
"deptName.id" : -1
}
}
])
c_city = [{
"_id" : ObjectId("5a9e08c464a9b21d249b272e"),
"id" : 1,
"city" : "北京"
}]
c_dept = [{
"_id" : ObjectId("5a9e0adf64a9b211487319b3"),
"id" : 1,
"deptName" : "java研发组"
}]
利用mongodb左关联把排序字段和顺序拼接到结果集,然后对关联后的字段id进行简单的升降序排列. 目前只想到这种方式,应该还能找到更好的方案