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

4 votes158 views3 answers
Golang convert string to bytes and convert bytes to string
Go
0 vote139 views4 answers
Buffered channels in golang
Go
0 vote133 views1 answer
Golang scan directory
Go
1 vote134 views1 answer
Golang get file md5
Go
0 vote124 views3 answers
`Got permission denied while trying to connect to the Docker daemon socket at unix:///var/run/docker.sock: Post http://%2Fvar%2Frun%2Fdocker.sock/v1.24/images/create?fromImage=mysql&tag=latest: dial unix /var/run/docker.sock: connect: permission
Go
0 vote121 views2 answers
Google chrome path in mac
Go
0 vote130 views1 answer
Collection not getting initiated mongo android
Go
0 vote144 views1 answer
Invalid set index godot
Go
0 vote132 views1 answer
Array of channels golang
Go
0 vote124 views1 answer
Which gopros have the same form factor and port alignment
Go