Include relation in mongo query

db.user.aggregate([
    { $project: { "userId": 1, "userKeyEncrypted": 1, "uuid":1, "roles": 1, "passwordHash": 1, "disabled": 1, companyRefs: { $let: { vars: { refParts: { $objectToArray: "$$ROOT.company" }}, in: "$$refParts.v" } } } },
    { $match: { "companyRefs": { $exists: true } } },
    { $project: { "userId": 1, "userKeyEncrypted": 1, "uuid":1, "roles": 1, "passwordHash": 1, "disabled": 1, "companyRef": { $arrayElemAt: [ "$companyRefs", 1 ] } } },
    { $lookup: { from: "company", localField: "companyRef", foreignField: "_id", as: "company_data" } },
    { $project: { "userId": 1, "userKeyEncrypted": 1, "uuid":1, "roles": 1, "passwordHash": 1, "disabled": 1,  "companyUuid": { $arrayElemAt: [ "$company_data.uuid", 0 ] } } }
])

Source: stackoverflow.com

Similar codes

-1 vote717 views1 answer
Welcome Firebase Hosting Setup Complete You're seeing this because you've successfully setup Firebase Hosting. Now it's time to go build something extraordinary! OPEN HOSTING DOCUMENTATION
Go
1 vote432 views1 answer
I got guns in my head and they won't go
Go
0 vote420 views2 answers
How to set status code golang http
Go
0 vote389 views1 answer
Go concurrent execution of f with parameter i. Tasks are independent and don't return any value.
Go
1 vote385 views1 answer
Golang flagset check to see if arg is available but has no value
Go
0 vote365 views2 answers
Pies are good
Go
4 votes398 views2 answers
Go maps
Go
0 vote410 views1 answer
Bootstrap remove placeholder on input
Go
31 votes569 views5 answers
Nokia stock
Go
6 votes404 views3 answers
Go pointers
Go