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 vote318 views1 answer
Csgo broken fang
Go
0 vote345 views1 answer
How to go through child in firebase Unity
Go
17 votes486 views5 answers
Golang convert int to string
Go
0 vote337 views1 answer
How to make history super interesting
Go
1 vote368 views2 answers
How to diagnose horizontal scroll that will not go away on mobile site
Go
0 vote388 views1 answer
Rss news google
Go
0 vote320 views1 answer
Array of string golang
Go
0 vote311 views1 answer
Golang http stop redirection
Go
2 votes354 views1 answer
Golang read file line by line
Go
2 votes336 views1 answer
How good test case should be
Go