mongodb A表不在B表内
db.storageDirectory.aggregate([
{
"$addFields": {
"myId": {
"$toString": "$_id"
}
}
},
{
$match: {
fid: {
$ne: ""
}
}
},
{
$lookup: {
from: "storageFile",
localField: "myId",
foreignField: "storageDirectoryId",
as: "file_docs"
}
},
{
$match: {
'file_docs.md5': {
$exists: false
}
}
},
{
$project: {
wwww: 1
}
}
]);