how to remove array filed with value null after unset in mongodb

Question

I had unset an array field, in mongo but it's leave the field with valué null,

the question is, how to remove it!

like this image https://i.sstatic.net/O2WiV.png

enricog · Accepted Answer · 2013-10-18 10:47:25Z

6

You could remove all null elements from the array with the $pull operation.
See docs

Code example:

db.collecton.update({condition: "x"}, {$pull: {state: null}});

edited Oct 18, 2013 at 10:47

answered Oct 18, 2013 at 9:13

enricog

4,2955 gold badges37 silver badges56 bronze badges

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

2 Comments

Hadi Nug Over a year ago

in this case, I have try like this one : db.tbl_location.update({country:"Indonesia"}, {$pull:{province:0}}); But it's not work, please check it

enricog Over a year ago

In the $pull condition you have to set the value that should be removed from the array not the index. So in you're case {$pull:{province:null}}. NOTE: This removes ALL null values from the array.

Collectives™ on Stack Overflow

how to remove array filed with value null after unset in mongodb

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related