How to check if Object is NOT in array in mongoDb?

Question

I want to push Object in members array, if it's not there. is there way to check if Object is not in array in mongodb?

{
 _id: 1111,
 members:[
 {user_id: 11},
 {user_id: 12},
 {user_id: 13}
 ]
}

So I want to check if:

newUser = {user_id: 14}

is not in members array, if not - push it there. Stuck with it. Thank you in advance for help.

You can try db.collection.update( { _id: 1111 }, { $addToSet: { members: {user_id: 14} } } ). This will not do anything if the value is already present. More here docs.mongodb.com/manual/reference/operator/update/addToSet/… — s7vr
– s7vr, Commented Mar 6, 2017 at 15:23
@Veeram that will match document with _id: 1111 each time your run this query. And it will try to update document each time — Sergey Berezovskiy
– Sergey Berezovskiy, Commented Mar 6, 2017 at 15:31
@SergeyBerezovskiy I assumed OP's wants to update the doc in question. So query for _id and update using $addToSet. — s7vr
– s7vr, Commented Mar 6, 2017 at 15:34
@Veeram might be, but in question OP states 'is there way to check if Object is not in array in mongodb?' And example below also about checking whether newUser is in members array. — Sergey Berezovskiy
– Sergey Berezovskiy, Commented Mar 6, 2017 at 15:44

Sergey Berezovskiy · Accepted Answer · 2017-03-06 15:26:31Z

5

Use $nin operator to check whether members array not contains document with user_id equal to 14. Update is simple $push:

db.collection.update({'members.user_id':{$nin: [14]}}, {$push:{members:{user_id:14}}})

answered Mar 6, 2017 at 15:26

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

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

Comments

kbariotis · Accepted Answer · 2017-03-06 15:24:42Z

0

First, you have to check if the array in the document contains that specific object. Use elemMatch for this

db.collection.find(
   { _id: 1111, members: { $elemMatch: { user_id: 14 } } }
)

Then, if the above returns nothing you pushing the object into

db.collection.update(
   { _id: 1111 },
   { $push: { user_id: 14 } }
)

answered Mar 6, 2017 at 15:24

kbariotis

8021 gold badge13 silver badges25 bronze badges

Comments

Rafiq · Accepted Answer · 2022-03-10 13:59:05Z

0

const a = await Trans.findOneAndUpdate(
            {
              _id: data.id,
              'products.id': { $nin: [product.id] },
            },
            {
              $inc: {
                actualCost: product.mrp,
              },
              $push: {
                products: { id: product.id },
              },
            },
            { new: true }
          );

answered Mar 10, 2022 at 13:59

Rafiq

12k5 gold badges44 silver badges46 bronze badges

Collectives™ on Stack Overflow

How to check if Object is NOT in array in mongoDb?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related