Mongodb Java add new array element in document

Question

I'm using mongo 2.2.3 and the java driver. My dilemma, I have to $push a field and value into an array element, but I cant seem to figure out how to do this. A sample of my data:

"_id" : 1,
"scores" : [
    {
        "type" : "english",
        "score" : 78.97979
    },
    {
        "type" : "spanish",
        "score" : 6.99
    }
]

I want to push one array attribute ("grade" : "A") in document where type = english.

after push document look like this :

"_id" : 1,
    "scores" : [
        {
            "type" : "english",
            "score" : 78.97979,
            "grade" : "A"
        },
        {
            "type" : "spanish",
            "score" : 6.99
        }
    ]

I tried using shell :

db.Sample.update({"scores.type" : "english"},{"$push" : {"scores": {"grade":"A"}}})

But this is not adding attribute on specific position.

Did you try my solution?

gasparms
– gasparms

2015-02-20 08:10:58 +00:00
Commented Feb 20, 2015 at 8:10 — gasparms
– gasparms, Commented Feb 20, 2015 at 8:10
@gasparms, Yes, i tried and solved my problem.

rajesh
– rajesh

2015-02-20 10:34:14 +00:00
Commented Feb 20, 2015 at 10:34 — rajesh
– rajesh, Commented Feb 20, 2015 at 10:34

gasparms · Accepted Answer · 2015-02-17 08:42:21Z

2

Try this update with Set and reference:

db.Sample.update({"scores.type" : "english"},{"$set" : {"scores.$.grade":"A"}})

edited Feb 17, 2015 at 8:42

answered Feb 17, 2015 at 8:22

gasparms

3,35424 silver badges26 bronze badges

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

2 Comments

rajesh Over a year ago

Hello, @gasparms can you differentiate $set and $push ??

gasparms Over a year ago

Maybe you want to know differences between $push and $addToSet? Becasue, $set and $push are totally differentes. $set replace the value of field and $push append a value to an array.

Collectives™ on Stack Overflow

Mongodb Java add new array element in document

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related