MongoDB Query, update specific field if value is not null

Question

I have an object "input" and will be passed to query like a parameter:

var input = {
    id: 1,
    componentId: x,
    commands: [...],
    user: [...],
}

And the collection "testCollection":

testCollection = {
    id: 1,
    model: {
        stepComponents: [
           {  
            componentId: x
            command: [...],
            user: [...],
           }
         ]
    }
}

My question is how can I update a specific field on "testCollection" and skip the update if it is undefined or null. That means if "input.user" is undefined/null, then not update "user" field.

The update query sample is below:

testCollection.update(
  {
    _id: objectId(input.id),
    'model.stepComponents.componentId': input.componentId
  },
  {
    'inputs': input.inputs,
    'model.stepComponents.$.commands': input.commands,
    'model.stepComponents.$.users': input.users,
  },
  { upsert: true },
);

Any help would be appreciated. Thanks.

p u · Accepted Answer · 2018-11-30 05:59:16Z

2

I was struck at the same problem and solved by below solution

  let params= {
      id: req.body.id, componentId: req.body.x, commands: req.body...,
  }

  ;
  for(let prop in params) if(!params[prop]) delete params[prop];//it will remove fields who are undefined or null 

  testCollection.findOneAndUpdate( {
      _id: req.params.id
  }

  , params);

answered Nov 30, 2018 at 5:59

p u

1,4551 gold badge20 silver badges30 bronze badges

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

1 Comment

nnson1610 Over a year ago

Sorry for my late response, it solved my problem, thank you.

Hokage Sama · Accepted Answer · 2018-11-30 04:53:14Z

2

Try this one:

testCollection.update(
{
  _id: objectId(input.id),
  user: {$ne: null}
},
{
    $set: {input}
}

);

answered Nov 30, 2018 at 4:53

Hokage Sama

1531 gold badge2 silver badges12 bronze badges

1 Comment

nnson1610 Over a year ago

It's not suitable for my case, anw, thanks for your help :)

Shiva · Accepted Answer · 2018-11-30 05:17:44Z

2

You can try to use exists

db.collection.find({ "fieldToCheck": { $exists: true, $ne: null } })

answered Nov 30, 2018 at 5:17

Shiva

2,0322 gold badges16 silver badges35 bronze badges

Collectives™ on Stack Overflow

MongoDB Query, update specific field if value is not null

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related