12345678910 |
- db.coin.aggregate([
- {$match: {status: 'indoor'}},
- {$group: {_id: "overall", amount: {$sum: "$coin.amount"}, count: {$sum: 1}}}
- ], {allowDiskUse: true}).saveAsView("coin-overall-view")
- db.person.aggregate([
- {$match: {personType: 'privotal', "person.ownerId": {$exists: true}}},
- {$group: {_id: {_id: "$_id", personId: "$person._id", ownerId: "$person.ownerId"}}}
- ], {allowDiskUse: true}).saveAsView("person-owner-view")
|