MongoDB: find and findOne with nested array filtering

by

I’ll TL;DR since this turned out to be a hell of a ride. I’ve tried $elemMatch, I’ve tried $redact (also with $$CURRENT and $$ROOT), I’ve tried $map, I’ve tried the aggregation framework, I’ve tried $project.

You can read all about it here: https://www.devsbedevin.net/mongodb-find-findone-with-nested-array-filtering-finally/

TL;DR

The solution seems to be to use the aggregation framework to filter the array and override the comments property with the results. This is simpler than it sounds:

db.getCollection('posts').aggregate(
    {$match: {"author.id": authorId}},
    {$addFields : {"comments":{$filter:{ // We override the existing field!
        input: "$comments",
        as: "comment",
        cond: {$eq: ["$$comment.state.deleted", false]}
    }}}}
);

The result:

{
  "author": {},
  "message": "This is post1",
  "comments": [
    {
      "message": "Im number 1!!!",
      "state": {
        "deleted": false
      }
    },
    {
      "message": "tHIS IS GREAT!",
      "state": {
        "deleted": false
      }
    },
    {
      "message": "I can type better than you guys",
      "state": {
        "deleted": false
      }
    }
  ]
},
{
  "author": {},
  "message": "This is post 2",
  "comments": [
    {
      "message": "I wanna have your children",
      "state": {
        "deleted": false
      }
    }
  ]
}

More Related Contents:

  1. $in requires an array as a second argument, found: missing
  2. How to Update Multiple Array Elements in mongodb
  3. MongoDB – Query on the last element of an array?
  4. Querying MongoDB to match in the first item in an array
  5. Does MongoDB’s $in clause guarantee order
  6. $lookup on ObjectId’s in an array
  7. Return only matched sub-document elements within a nested array
  8. MongoDB: How do I update a single subelement in an array, referenced by the index within the array?
  9. Converting string to date in mongodb
  10. MongoDB Regex Search on Integer Value
  11. Check if every element in array matches condition
  12. MongoDB Duplicate Documents even after adding unique key
  13. MongoDB nested lookup with 3 levels
  14. Aggregation filter after $lookup
  15. MongoDB Full and Partial Text Search
  16. Matching ObjectId to String for $graphLookup
  17. Mongodb Join on _id field from String to ObjectId
  18. Mongodb aggregation lookup with conditions
  19. How to get back the Original document back after aggregation
  20. Mongo sort on a calculated condition
  21. MongoDB update multiple records of array [duplicate]
  22. MongoDB lookup when foreign field is an array of objects
  23. Search on multiple collections in MongoDB
  24. Updating nested array inside array mongodb [duplicate]
  25. Removing the array element in mongoDB based on the position of element
  26. count array occurrences across all documents with mongo
  27. Can you have mongo $push prepend instead of append?
  28. $project in $lookup mongodb
  29. Mongodb, aggregate query with $lookup
  30. Return the last “true” value for each group

Leave a Comment