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

2 votes117 views1 answer
Good test case
Go
0 vote114 views1 answer
Create Windows to go workspace with cmd
Go
0 vote105 views1 answer
Onion omega location of files on sd
Go
0 vote107 views1 answer
Iterate over struct slice golang
Go
19 votes246 views3 answers
Local mongodb url
Go
2 votes112 views1 answer
Do animals go to heaven
Go
0 vote108 views1 answer
Package is not in GOROOT (/usr/local/go/src/) - golang
Go
471 votes232 views10 answers
Gme stock
Go
251 votes233 views6 answers
Live stock price gme
Go
0 vote123 views1 answer
Invalid set index godot
Go