mongodb java 子查询_mongodb子查询

let pipeline = [{

$lookup: {

from: "user_person",

localField: "cardnumber",

foreignField: "cardnumber",

as: "right_person"

}

},

{"$unwind":"$right_person"},//查处满足条件的子文档

{

$match: {//这儿是将子文档展示出来，否则查处的结果满足子文档的其中之一，子文档的值都会显示出来

"right_person.state":1

}

},

{

$match: {

$or: [{

"IDcard": userIDCard

},

{

"right_person.ownerIDCard": userIDCard

},

{

"right_person.userIDCard": userIDCard

}

]

}

},

// {

// $project:{"inventory_docs.Knowledge_QuestionType":1,"inventory_docs.Knowledge_QuestionDetail":1,"_id":0,"Cat_Name":1} //获取想要的字段

// }

]