Update multiple array elements with $inc

Question

I have the following document

{store : {
        id        : 'STORE1',
        name      : 'Electronics Store',
        locations : [
            {
                id       : 'LOC1',
                quantity : 4
            },
            {
                id       : 'LOC2',
                quantity : 10
            },
            {
                id       : 'LOC3',
                quantity : 5
            }
        ]
    }
}

I want to update the quantity of multiple elements of the locations array based on their id field using $inc.

For example I want to update id : 'LOC1' with +5 to the quantity field and id : LOC3 with +2 to its quantity field.

Is it possible to do this with one query in mongodb instead of using multiple queries for each location.

Does this answer your question? arrayFilters in mongodb --> Making it as direct duplicate, Only change is $set to $inc — whoami - fakeFaceTrueSoul
– whoami - fakeFaceTrueSoul, Commented Jun 4, 2020 at 15:43

ngShravil.py · Accepted Answer · 2020-06-04 14:32:08Z

3

You can make use of filtered positional operator $[<identifier>]. Below code will be helpful:

db.collection.update(
     {},
     {$inc: {'store.locations.$[elem1].quantity': 5, 'store.locations.$[elem2].quantity': 2}},
     {arrayFilters: [{'elem1.id': 'LOC1'}, {'elem2.id': 'LOC3'}]}
)

answered Jun 4, 2020 at 14:32

ngShravil.py

5,0983 gold badges21 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

Update multiple array elements with $inc

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related