-
Type:
Bug
-
Resolution: Duplicate
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Querying
-
Labels:None
-
ALL
Hello All,
I have a similar situation I guess, the following is the sample Json document in which I need to query on.
{
"_id" : ObjectId("591d601fc9f360331cd4668c"),
"Type" : "district",
"GroupId" : "00000000-0000-0000-0000-000000000456",
"Grades" : [
{
"GroupId" : "gs00000000-0000-0000-0000-000000000452",
"Categories" : [
{
"Sequence" : 1,
"Low" : 0,
"High" : 99,
"Min" : 0,
"Max" : 0,
},
{
"Sequence" : 1,
"Low" : 50,
"High" : 99,
"Min" : 0,
"Max" : 0,
}
]
}
],
"NumberOfTypes" : 4,
"CreatedDate" : ISODate("2017-05-18T08:49:35.433Z"),
"LastModifiedDate" : ISODate("2017-05-26T16:12:52.093Z"),
"Status" : true
}
I need to pick all the document where the value of "Low": 0 and change to 1. I am trying the following query
db.BenchmarkDetails.update(
{"Grades.Categories.Low" : 0},
{$set :
{"Grades.Categories.$.Low" : 1}
}
)
This throwing the error
cannot use the part (Grades of Grades.Categories.0.Low) to traverse the element.
- duplicates
-
SERVER-27089 Extend the update subsystem to support more expressive updates to array fields
-
- Closed
-
- related to
-
-
- Closed
-