How to query in MongoDB query results?

Question

MongoDB

Hello.
I read a lot of things, but there was no understanding, and no. And the request is very popular.
Step1: Get a list of guids of all organizations with the specified conditions

db.organizations.find({
    docStatus: {
        $ne: "delete"
    },
    isAuthorized: true
}, {
    _id: 0,
    guid: 1
})

Step2: Looking for users whose org field matches the guids of the previous request, and the status is active:true

db.users.find({
org:"guid_из_шаг1", active:true
})

How to solve this problem with one simple request?

Answer 1

db.users.aggregate({$match: {active:true}},
{$lookup:
{ from: "org", localField: "org.id", foreignField: "guid", as: "org"},
{$unwind: "$org"},
{$match: {"org.docStatus": {$ne: "delete"}, "org.isAuthorized": true},
{$group: { _id: "$_id"}})

Answer 2

https://docs.mongodb.com/manual/reference/operator...
https://docs.mongodb.com/manual/reference/operator...
https://docs.mongodb.com/manual/reference/ operator...
In general, Monga is not intended for this... You need to choose a database for the task, and not follow the fashion...