db.book.aggregate([
{
$match:{
sign_status: "xfinish"
}
},{
$lookup: {
from: "user",
localField: "user_id",
foreignField: "_id",
as: "user"
}
},
{
$lookup: {
from: "chapter",
localField: "_id",
foreignField: "book_id",
as: "chapter"
}
}
,
{
$unwind:{
path:"$chapter",
preserveNullAndEmptyArrays: true,
}
},
{
$group:{
_id:{id:"$_id",name:"$name",chpater_book:"$chapter.book_id",penname:"$user.penname",username:"$user.name",signType:"$sign_type",attribute:"$attribute",finish_time:"$finish_time",wordCont:"$word_count"},
count2:{$sum:1}
}
}
]
)
1306
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
