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

0 vote148 views1 answer
Golang build tag
Go
0 vote143 views1 answer
Intersection in go
Go
0 vote127 views2 answers
Pies are good
Go
0 vote140 views1 answer
Google Maps API: Adding letters to my markers on my google map
Go
0 vote142 views2 answers
Link for a search result from google
Go
0 vote146 views1 answer
Gorm array type data postgres
Go
0 vote146 views1 answer
Go copy to array
Go
0 vote177 views1 answer
Go error handling
Go
0 vote84 views1 answer
Zoom map to city with city name google map developer
Go
10 votes117 views1 answer
How to do google search
Go