How to replace an element in an array field in mongodb

Question

Field tags is array in scenes document. I wanna replace element 'Bad' with 'Good' in the array as:

db.scenes.update({ 'tags': 'Bad' }, { $set: { 'tags.$' : 'Good' } }, { 'multi':true});

I don't know how to do it in doctrine. I tried

    $dm->createQueryBuilder('SceneBundle:Scene')
        ->update()
        ->field('tags.$')->set($tag)
        ->field('tags')->equals($oldTag)
        ->multiple(true)
        ->getQuery()
        ->execute();

but not work.

Thanks.

I don't know about doctrine, but here's how to replace an array element in MongoDB. — Dan Dascalescu
– Dan Dascalescu, Commented Jun 2, 2020 at 4:17

Community · Accepted Answer · 2017-05-23 11:54:19Z

2

it's been a long time, but just to not leave this post without a good answer I found a link (Mongodb array $push and $pull) which can help us.

The issue is that MongoDB doesn’t allow multiple operations on the same property in the same update call. This means that the two operations must happen in two individually atomic operations.

edited May 23, 2017 at 11:54

CommunityBot

11 silver badge

answered Mar 31, 2017 at 13:31

Marabesi

741 silver badge7 bronze badges

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

Comments

Adil · Accepted Answer · 2013-04-12 16:04:13Z

1

There isn't a single replace function for this, but you can do it in one query by pulling all the 'Bad' out, and pushing 'Good' in

db.scenes.update({ 'tags': 'Bad' }, { $pull: { 'tags' : 'Bad' }, $push: { 'tags' : 'Good' } }, { 'multi':true});

The doctrine equivalent should be :

 $dm->createQueryBuilder('SceneBundle:Scene')
    ->update()
    ->field('tags')->pull('Bad')
    ->field('tags')->push('Good')
    ->field('tags')->equals('Bad')
    ->multiple(true)
    ->getQuery()
    ->execute();

Refer to the doctrine docs here : http://docs.doctrine-project.org/projects/doctrine-mongodb-odm/en/latest/reference/query-builder-api.html

edited Apr 12, 2013 at 16:04

answered Apr 12, 2013 at 15:38

Adil

2,1324 gold badges27 silver badges37 bronze badges

4 Comments

K1Zhang Over a year ago

No, this does not work. I wrote this at first and mongod complained:code(Field name duplication not allowed with modifiers)

K1Zhang Over a year ago

huh, probably three. Need find documents to be modified first

Adil Over a year ago

It doesn't need to be done twice in mongo. However, I'm not fluent with Doctrine to give you an answer. Try some options and post the answer here.

Aral Roca Over a year ago

This don't woks for me... errmsg: 'exception: Cannot update \'tags\' and \'tags\' at the same time

Collectives™ on Stack Overflow

How to replace an element in an array field in mongodb

2 Answers 2

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related