Check if all elements present in an array

Question

I am trying to find whether all elements of the array are found inside an array in a MongoDB database using mongoose.

If my data in MongoDB is -

{
  row: "A",
  reserve: [1,2,3]
}

and if my query data is -

{
  row: "A",
  arr: [1,2] // I want it to return result
}

and if my query data is

{
  row: "A",
  arr: [1,2,4] // I want it to return null
}

I want to update the data but it is updating every time

Reserved.updateOne({row: "A", reserve: {$in: arr}, {
  $push: {
    reserve: arr
  }
}, (err, result) => {
  // ...
});

Please help me.

Try this db.collection.aggregate([ { $project: { reserve: { $filter: { input: "$reserve", cond: { $in: [ "$$this", [ 1, 2 ] ] } } } } } ]) — Ashh
– Ashh, Commented Oct 14, 2018 at 16:51
I want to use findOne because I am using updateOne for updating data. — Rupesh
– Rupesh, Commented Oct 14, 2018 at 16:53
I am using updateOne for updating data not clear what you are asking — Ashh
– Ashh, Commented Oct 14, 2018 at 16:55
Try this db.collection.updateOne({ row: "A", reserve: { $all: arr } }) — Ashh
– Ashh, Commented Oct 14, 2018 at 17:02

Ashh · Accepted Answer · 2018-10-15 16:17:11Z

2

You can use $all operator to match all the elements from the array.

From the docs

The $all operator selects the documents where the value of a field is an array that contains all the specified elements.

db.collection.updateOne({ "row": "A", "reserve": { "$all": array }})

or even with find query

db.collection.find({ "row": "A", "reserve": { "$all": array }})

answered Oct 15, 2018 at 16:17

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

Comments

vizsatiz · Accepted Answer · 2018-10-14 17:09:47Z

0

You can use the $all operator (link). Something like:

db.collection.updateOne(
        {
          row: "A",
          reserve: { $all: array } 
        }
)

Hope this helps !!

answered Oct 14, 2018 at 17:09

vizsatiz

2,2111 gold badge21 silver badges44 bronze badges