$unwind empty array

by

With MongoDB 3.2 version and newer, the $unwind operator now has some options where in particular the preserveNullAndEmptyArrays option will solve this.

If this option is set to true and if the path is null, missing, or an empty array, $unwind outputs the document. If false, $unwind does not output a document if the path is null, missing, or an empty array. In your case, set it to true:

db.collection.aggregate([
    { "$unwind": {
        "path": "$solved",
        "preserveNullAndEmptyArrays": true
    } },
    { "$group": {
        "_id": "$_id",
        "login": { "$first": "$login" },
        "solved": { "$sum": "$solved.points" }
    } }
])

More Related Contents:

  1. Group result by 15 minutes time interval in MongoDb
  2. Moongoose aggregate $match does not match id’s
  3. Find in Double Nested Array MongoDB
  4. Check if every element in array matches condition
  5. MongoDB nested lookup with 3 levels
  6. How to aggregate sum in MongoDB to get a total count?
  7. MongoDB : Aggregation framework : Get last dated document per grouping ID
  8. Get a count of total documents with MongoDB when using limit
  9. Include all existing fields and add new fields to document
  10. Matching ObjectId to String for $graphLookup
  11. mongodb count num of distinct values per field/key
  12. Rounding to 2 decimal places using MongoDB aggregation framework
  13. What’s the $unwind operator in MongoDB?
  14. Mongodb Explain for Aggregation framework
  15. MongoDB aggregation comparison: group(), $group and MapReduce
  16. Mongodb aggregation lookup with conditions
  17. How to get back the Original document back after aggregation
  18. How to aggregate by year-month-day on a different timezone
  19. MongoDB lookup when foreign field is an array of objects
  20. Poor lookup aggregation performance
  21. $skip and $limit in aggregation framework
  22. Get n-th element of an array in MongoDB
  23. How do I rename fields when performing search/projection in MongoDB?
  24. $unwind an object in aggregation framework
  25. Mongodb Aggregation Framework | Group over multiple values?
  26. mongodb aggregation framework match by nested documents
  27. count array occurrences across all documents with mongo
  28. MongoDB to Use Sharding with $lookup Aggregation Operator
  29. $project in $lookup mongodb
  30. Return actual type of a field in MongoDB

Leave a Comment