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 vote125 views4 answers
Hello world in golang
Go
0 vote128 views1 answer
Code:403 google sheet api
Go
2 votes138 views1 answer
Golang read file line by line
Go
3 votes132 views1 answer
Go string to byte array
Go
0 vote137 views1 answer
{google:baseURL}search?q=%s&{google:RLZ}{google:originalQueryForSuggestion}{google:assistedQueryStats}{google:searchFieldtrialParameter}{google:iOSSearchLanguage}{google:searchClient}{google:sourceId}{google:contextualSearchVersion}ie={inputEncod
Go
0 vote127 views1 answer
How do I disable gogy
Go
0 vote115 views1 answer
Golang get file sha256
Go
0 vote124 views2 answers
While loop in golang
Go
0 vote134 views1 answer
Union in go
Go
5 votes123 views3 answers
Go format string
Go