MongoDB group by array inner-elements

by

What framework are you using? This is not MongoDB shell and looks like some weird wrapper around MapReduce. In that case $unwind would not be available, and you need it for user in the aggregation framework. Here’s what you want in the mongo shell:

db.articles.aggregate([
  {$match: { class_date: { $gte: date } } },
  {$project: { _id: 0, class_artist: 1 } },
  {$unwind: "$class_artist" },
  {$group: { _id: "$class_artist", tags: { $sum: 1 } }},
  {$project: { _id: 0,class_artist: "$_id", tags: 1 } },
  {$sort: { tags: -1 } }
])

So efficiently:

  1. Filter by date because you already set a var for the last 7 days
  2. Project only the field(s) we need { We need only one! }
  3. Unwind the array so we now have a record for every array element in every document
  4. Group on the Artist from the expanded documents
  5. Project into a document format you can use as group messed around with _id
  6. Sort the results in reverse order to see the top tagged first

And the great thing about aggregation is you can gradually build up those stages to see what is going on.

Shake and bake into your own driver implmentation or ODM framework as required.

More Related Contents:

  1. Retrieve only the queried element in an object array in MongoDB collection
  2. Update MongoDB field using value of another field
  3. Get names of all keys in the collection
  4. How to filter array in subdocument with MongoDB [duplicate]
  5. Does MongoDB’s $in clause guarantee order
  6. MongoDB: Combine data from multiple collections into one..how?
  7. Multiple join conditions using the $lookup operator
  8. Conditional $sum in MongoDB
  9. Return only matched sub-document elements within a nested array
  10. Converting string to date in mongodb
  11. MongoDB Full and Partial Text Search
  12. Mongodb Join on _id field from String to ObjectId
  13. Mongo sort on a calculated condition
  14. MongoDB sort documents by array elements
  15. How to return array of string with mongodb aggregation
  16. How to return just the nested documents of an array from all documents
  17. MongoDB: Calculate dwell time between every status value change
  18. MongoDB: how to parse date in 3.6 mongoDb version?
  19. Using stored JavaScript functions in the Aggregation pipeline, MapReduce or runCommand
  20. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  21. convert iso date to timestamp in mongo query
  22. Remove Duplicates from MongoDB
  23. Using $slice operator to get last element of array
  24. Mongodb aggregation $group, restrict length of array
  25. How to access overall document count during arithmetic aggregation expression
  26. Geospatial $near within current document field value
  27. Mongodb aggregation pipeline how to limit a group push
  28. Mongodb concat int and string
  29. mongodb aggregate query isn’t returning proper sum on using $sum
  30. MongoDB aggregate within daily grouping [duplicate]

Leave a Comment