Mongo Query:
The following query should provide the list of all projects owned by deactivated users and the completed timestamp of runs in each of those projects:
rs.slaveOk();
DBQuery.shellBatchSize = 2000;
db.users.aggregate([
{ "$match": {"deactivatedFlag" : true} },
{
$lookup: {
from: "projects",
localField: "_id",
foreignField: "ownerId",
as: "project"
}
},
{"$unwind": "$project"},
{
$lookup: {
from: "runs",
localField: "project._id",
foreignField: "projectId",
as: "runs"
}
},
{
$project: {
"_id": 1,
"loginId.id": 1,
"created": 1,
"project.name": 1,
"project._id": 1,
"project.created": 1,
"project.isArchived": 1,
"runs.completed":1
}
}
]).pretty()
Comments
0 comments
Please sign in to leave a comment.