Template
single collection
multiple collections
mgodatagen
update
indexe
explain
Stage
Database
bson
mgodatagen
[]
Query
db.collection.aggregate([{$group:{_id:"$party1.partyRole"}},{"$match":{_id:{$ne:null}}},{"$count":"count"},{"$unionWith":{"coll":"collection","pipeline":[{"$documents":[{"count":0}]}]}},{"$limit":1}])
Result