Hi
I do have collection called “student” which has following data (provided in json format).
I can update the “grade” in grades array by using
db.students.updateMany({},{$inc:{“grades.$.grade”:-5}})
but instead of “-5” I want to use “adj” field of document . How can I do that?
I tried to use
db.students.updateMany({},{$inc:{“grades.$.grade”:‘$adj’}})
but I am getting error
{
"_id": 1,
"adj": -5,
"grades": [
{
"grade": 70,
"mean": 75,
"std": 6
},
{
"grade": 75,
"mean": 90,
"std": 4
},
{
"grade": 75,
"mean": 85,
"std": 6
}
]
},{
"_id": 2,
"adj": -4,
"grades": [
{
"grade": 80,
"mean": 75,
"std": 6
},
{
"grade": 77,
"mean": 90,
"std": 3
},
{
"grade": 75,
"mean": 85,
"std": 4
}
]
}
Thanks