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

3 votes212 views13 answers
Go hello world
Go
19 votes302 views6 answers
Bill gates
Go
0 vote215 views1 answer
Go slice pop
Go
0 vote225 views1 answer
Colossal god of chaos
Go
0 vote242 views1 answer
Google pay rewrite in flutter
Go
0 vote204 views1 answer
Mongo remove all dbs
Go
0 vote240 views1 answer
How to backup raspberry pi sd card
Go
8 votes282 views4 answers
Golang byte to string
Go
1 vote269 views1 answer
Add google font to wordpress theme
Go
0 vote218 views1 answer
How to tell if you got pygAME
Go