arrayFilters in mongodb

Question

I have the following schema.

{
   posts: [
          {
             _id: '5ayuunbdsyuuuyut778'
             replies: [{
                 _id: "67hfudj7e9whduu888",
                 text: "something"
             }]
          }
      ]
}

I want to update the text in particular reply. I am using mongoose.

I have written the query as follows

Post.findOneAndUpdate(
   {'posts.replies._id': _id}, 
   {$set: {'posts.$[post].replies.$[reply].text': "something1"}},
   { arrayFilters: [{'post._id': postId}, { 'reply._id': _id }]}
 )

This query is not updating the document.

Am I missing something? Do I need to cast ids using ObjectId

Are you getting any error? Because above query works for me... Probably your `postId` or `_id` would not be correct... I have tried this `User.findOneAndUpdate( {'posts.replies._id': "67hfudj7e9whduu888"}, {$set: {'posts.$[post].replies.$[reply].text': "something12"}}, { arrayFilters: [{'post._id': "5ayuunbdsyuuuyut778"}, { 'reply._id': "67hfudj7e9whduu888" }]} )` — Ashh, Jul 13 '18 at 12:31
@Anthony Winslet. I am not getting any error. I am getting the doc without updating when I use {new:true} — Kodanda Rama Durgarao poluri, Jul 13 '18 at 15:14
are they updating in the database? And how you are using `multi: true`? — Ashh, Jul 13 '18 at 15:33
Sorry I mean `new: true`... How you used it? and put `@` so that I can get the notification — Ashh, Jul 13 '18 at 16:46
@Anthony Winslet User.findOneAndUpdate( {'posts.replies._id': "67hfudj7e9whduu888"}, {$set: {'posts.$[post].replies.$[reply].text': "something12"}}, { arrayFilters: [{'post._id': "5ayuunbdsyuuuyut778"}, { 'reply._id': "67hfudj7e9whduu888" }]}, {new:true} ) — Kodanda Rama Durgarao poluri, Jul 13 '18 at 18:55

Ashh · Accepted Answer · 2018-07-14T09:16:43.407

13

You need to use new: true to get the updated value and cast id to mongoose objectId to make it work

Post.findOneAndUpdate(
   { 'posts.replies._id': _id }, 
   { $set: { 'posts.$[post].replies.$[reply].text': "something1" } },
   { arrayFilters: [{ 'post._id': postId }, { 'reply._id': _id }], new: true }
)

edited Jul 14 '18 at 09:16

answered Jul 13 '18 at 19:08

Ashh

44,693
14
105
132

It's not updating in database itself. – Kodanda Rama Durgarao poluri Jul 14 '18 at 05:42
What I have observed is, its updating in mongo shell(3.6). but not through mongoose(5.2). – Kodanda Rama Durgarao poluri Jul 14 '18 at 06:13
Type this command in your mongo shell `db.adminCommand( { setFeatureCompatibilityVersion: "3.6" } )` and then try again – Ashh Jul 14 '18 at 07:45
Now I am sure your id might not be correct... Put the id hard coded and try – Ashh Jul 14 '18 at 08:10
Hey thank you for your help. I forgot to cast the Object Id in mongoose. – Kodanda Rama Durgarao poluri Jul 14 '18 at 09:00
is it possible to keep the original _id – moein rahimi May 17 '20 at 06:15

score 4 · Answer 2 · answered Jul 14 '18 at 09:02

As arrayFilters are something related to mongodb, you need to cast id in mongoose with ObjectId

Post.findOneAndUpdate(
   { 'posts.replies._id': _id }, 
   { $set: { 'posts.$[post].replies.$[reply].text': "something1" } },
   { arrayFilters: [{ 'post._id': postId }, { 'reply._id': _id }]}
)

must be changed to

Post.findOneAndUpdate(
   { 'posts.replies._id': _id }, 
   { $set: { 'posts.$[post].replies.$[reply].text': "something1" } },
   { arrayFilters: [{ 'post._id': ObjectId(postId) }, { 'reply._id': ObjectId(_id)}]}
)

score 0 · Answer 3 · answered Jun 08 '21 at 08:22

arrayFilters does not accept stringified Object Ids, as opposed to typical filters in mongoose (which cast object ids automatically for you), you must cast object id manually when passing it as filter to arrayFilters).

Post.findOneAndUpdate(
   { 'posts.replies._id': _id }, 
   { $set: { 'posts.$[post].replies.$[reply].text': "something1" } },
   { arrayFilters: [{ 'post._id':new ObjectId(postId) }, { 'reply._id': new ObjectId(_id) }], new: true }

this will work, check comments here for more details

arrayFilters in mongodb

3 Answers3

Linked

Related