Loading...

XML

Word

Printable

JSON

Operating System:
ALL
Steps To Reproduce:
Hide

db.students.insert( { "_id" : 1, "grades" : [ { "grade" : 80, "mean" : 75, "std" : 6 }, { "grade" : 85, "mean" : 90, "std" : 4 }, { "grade" : 85, "mean" : 85, "std" : 6 } ] }) db.students.insert( { "_id" : 2, "grades" : [ { "grade" : 90, "mean" : 75, "std" : 6 }, { "grade" : 87, "mean" : 90, "std" : 3 }, { "grade" : 85, "mean" : 85, "std" : 4 } ] })

db.foo.update( { }, { $set: { "grades.$[elem].mean" : 100 } }, { multi: true, arrayFilters: [ { "elem.grade": { $gte: 85 } } ] } )

result:

No array filter found for identifier 'elem' in path 'grades.$[elem].mean'
Show
db.students.insert( { "_id" : 1, "grades" : [ { "grade" : 80, "mean" : 75, "std" : 6 }, { "grade" : 85, "mean" : 90, "std" : 4 }, { "grade" : 85, "mean" : 85, "std" : 6 } ] }) db.students.insert( { "_id" : 2, "grades" : [ { "grade" : 90, "mean" : 75, "std" : 6 }, { "grade" : 87, "mean" : 90, "std" : 3 }, { "grade" : 85, "mean" : 85, "std" : 4 } ] }) db.foo.update( { }, { $set: { "grades.$[elem].mean" : 100 } }, { multi: true, arrayFilters: [ { "elem.grade": { $gte: 85 } } ] } ) result: No array filter found for identifier 'elem' in path 'grades.$[elem].mean'

I am trying to create a query that updates arrayed subdocuments, but I keep getting an error:

"No array filter found for identifier '<identifier>' in path '<path>'"

It is reproducible using the examples from the documentation.

db.version() shows 3.6.6