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

19 votes455 views3 answers
Mongodb localhost uri
Go
0 vote197 views1 answer
Import cryptocurrency price data into google sheets
Go
2 votes204 views1 answer
Golang read file line by line
Go
0 vote181 views1 answer
Ec2_group tags
Go
3 votes227 views1 answer
How to exclude words in google search
Go
0 vote184 views1 answer
How to add extension logo of chrome
Go
5 votes210 views2 answers
Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.6.1:compile (default-compile) on project a2: Compilation failure [ERROR] No compiler is provided in this environment. Perhaps you are running on a JRE rather than a JDK?
Go
0 vote181 views1 answer
Basic go code
Go
0 vote210 views1 answer
How to backup raspberry pi sd card
Go
0 vote269 views2 answers
How to put youtube in Google Chrome console
Go