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 vote242 views1 answer
Golang time difference in milliseconds
Go
-1 vote200 views1 answer
Cost of goods sold is the expense recorded on the income statement once inventory is sold to a third party
Go
0 vote168 views1 answer
Netlogo walls
Go
0 vote205 views1 answer
Gorm array type data postgres
Go
0 vote178 views1 answer
Golang type enum
Go
0 vote188 views1 answer
Microsoft OneNote vs google keep
Go
4 votes255 views4 answers
Is Grepper good?
Go
3 votes191 views1 answer
How to hack google
Go
0 vote184 views1 answer
Set in go
Go
3 votes196 views1 answer
Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.20.1:test (default-test) on project upload
Go