anscii/gist:8040820

Last active December 31, 2015 20:29

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/anscii/8040820.js"></script>
Save anscii/8040820 to your computer and use it in GitHub Desktop.

Download ZIP

Count mongo subarrays with subarray field matching for all possible _ids

Raw

gistfile1.js

db.tag_ru.aggregate({ $unwind: '$items'},     { $match: { "items.type":"news"}},     { $group: {_id: '$_id', count: {$sum: 1}}}, {$group: {_id:null, cnt:{$sum:"$count"} } } )

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment