Mongoose - Return object only if condition matches all the objects in array

Question

Description:

I want to only return if all the objects in the array match the condition. Now, it's returning the object if at least one condition matches in the array of objects.

If you guys have any more queries regarding this question. I will answer please ask!

Input:

[
   {
      "_id":"4",
      "intends":[
         {
            "_id":"1",
            "status":"Packed"
         },
         {
            "_id":"2",
            "status":"Packed"
         }
      ]
   },
   {
      "_id":"5",
      "intends":[
         {
            "_id":"3",
            "status":"Packed"
         },
         {
            "_id":"4",
            "status":"Created"
         }
      ]
   }
]

Current Output:

[
   {
      "_id":"4",
      "intends":[
         {
            "_id":"1",
            "status":"Packed"
         },
         {
            "_id":"2",
            "status":"Packed"
         }
      ]
   },
   {
      "_id":"5",
      "intends":[
         {
            "_id":"3",
            "status":"Packed"
         },
         {
            "_id":"4",
            "status":"Created"
         }
      ]
   }
]

Expected Output:

[
   {
      "_id":"4",
      "intends":[
         {
            "_id":"1",
            "status":"Packed"
         },
         {
            "_id":"2",
            "status":"Packed"
         }
      ]
   }
]

I have tried:

db.collection.find({intends.status: "Packed"})
db.collection.find({intends: {$elemMatch: {status: "Packed"}}})

so you need records of when every value of intends has status Packed? — cmgchess
– cmgchess, Commented Mar 8, 2022 at 13:56
FYI, Have also tried with $elemMatch... Please check the updated question. — dinesh oz
– dinesh oz, Commented Mar 8, 2022 at 14:14
updated answer. use ne instead of nin since you are only searching one value — cmgchess
– cmgchess, Commented Mar 8, 2022 at 14:24

cmgchess · Accepted Answer · 2022-03-08 14:22:30Z

4

A possible solution using $elemMatch, $nin and $not.
The $elemMatch, $nin part will give all elements where there is at least one element with status not "Packed". So the $not will reverse it and give elements where every status is "Packed"

db.collection.find({
  intends: {
    "$not": {
      "$elemMatch": {
        status: {
          "$nin": [
            "Packed"
          ]
        }
      }
    }
  }
})

demo

UPDATE Since here just checking 1 value use $ne instead of $nin

db.collection.find({
  intends: {
    $not: {
      $elemMatch: {
        status: {
          $ne: "Packed"
        }
      }
    }
  }
})

demo

edited Mar 8, 2022 at 14:22

answered Mar 8, 2022 at 14:17

cmgchess

10.3k42 gold badges55 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

1sina1 · Accepted Answer · 2022-03-08 14:27:05Z

0

using aggregation $redact and $allElementsTrue

test it at mongoPlayground

db.collection.aggregate([
  {
    "$redact": {
      "$cond": [
        {
          "$allElementsTrue": {
            "$map": {
              "input": "$intends",
              "as": "intend",
              "in": {
                "$eq": [
                  "$$intend.status",
                  "Packed"
                ]
              }
            }
          }
        },
        "$$KEEP",
        "$$PRUNE"
      ]
    }
  }
])

answered Mar 8, 2022 at 14:27

1sina1

1,0968 silver badges13 bronze badges

Collectives™ on Stack Overflow

Mongoose - Return object only if condition matches all the objects in array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related