db.test.aggregate(
[
// Stage 1
{
$match: {
result: 1
}
},
// Stage 2
{
$group: {
_id: "$name",
formats: { $addToSet: "$format"}
}
},
// Stage 3
{
$project: {
name: "$name",
pdf: {$setIsSubset: [["pdf"], "$formats"]},
htm: {$setIsSubset: [["htm"], "$formats"]},
xml: {$setIsSubset: [["xml"], "$formats"]}
}
}
]
);