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

0 vote417 views1 answer
Go ticker
Go
0 vote428 views1 answer
Fragment shader using alpha godot
Go
0 vote413 views1 answer
How to remove element from backing array slice golang
Go
1 vote403 views1 answer
Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.12.4:test (default-test) on project mockito-course: There are test failures.
Go
0 vote438 views1 answer
ValueError: numpy.ufunc size changed, may indicate binary incompatibility. Expected 216 from C header, got 192 from PyObject
Go
0 vote401 views1 answer
Google calendar remove a goal
Go
-1 vote353 views1 answer
Golang copy struct
Go
5 votes424 views1 answer
Golang array syntax
Go
1 vote398 views1 answer
Golang jwt example
Go
0 vote438 views1 answer
Pymongo ping
Go