How to update a String with an Array in a document within Robo3T?

Question

I am trying to change an element object that is within an array in a document on Robo3T.

The structure looks like this:

  {
    "_id" : ObjectId("1234"),
    "source" : "BW",
    "sourceTableName" : "lwtrmls",
    "tableName" : "tier",
    "type" : "main",
    "primaryKeys" : [ 
        {
            "sourceField" : "tier_id", // <~~~~ This is what I am trying to update!
            "reportingField" : "bw_id",
            "type" : "integer"
        }
    ]
}

Basically trying to change tier_id under primaryKeys and sourceField to trmls_id.

I have tried something like db.my_collection.update( {_id : "1234"}, {$set : {"primaryKeys.0.tier_id" : "trmls_id"}} ) and that does not seem to be working. Is there a clean way to do this?

Does this answer your question? How to update objects in array in Mongo — turivishal
– turivishal, Commented Aug 13, 2020 at 19:07
If primary keys contains more than one object? What should be the condition — Gibbs
– Gibbs, Commented Aug 13, 2020 at 19:13

Andrey Sherman · Accepted Answer · 2021-02-18 13:47:18Z

1

Basically you need to use $(update)

In you case you need to execute current query:

db.my_collection.update( {_id : "1234", "primaryKeys.sourceField":"tier_id"}, {$set : {"primaryKeys.$.sourceField" : "trmls_id"}} )

Updated:

If you want to update not only first element in array for current filters, but all, you could use $[]

db.my_collection.update( {_id : "1234", "primaryKeys.sourceField":"tier_id"}, {$set : {"primaryKeys.$[].sourceField" : "trmls_id"}, { multi: true }} )

edited Feb 18, 2021 at 13:47

answered Aug 13, 2020 at 20:48

Andrey Sherman

3601 silver badge7 bronze badges

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

1 Comment

turivishal Over a year ago

updates all not matching fields also, This is not the way to update, it requires arrayFilters and this is duplicate question. answers are already in above comment link.

Collectives™ on Stack Overflow

How to update a String with an Array in a document within Robo3T?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related