How to write a query in mongo db to find elements in which the nested array does not have an element with the given id?

Question

There is a given array with data .

[
   {
      "_id":"62d9553f2f7d45d51e9e6850",
      "title":"lol",
      "body":"lol",
      "readIds":[
         {
            "id":"62c56b2cffe059fdfdd19230",
            "createdAt":1658417024700
         }
      ],
      "mode":"custom",
      "createdAt":"2022-07-21T13:31:43.633Z",
      "updatedAt":"2022-07-21T15:23:44.701Z"
   },
   {
      "_id":"62d954e2ea35817546d42702",
      "title":"tesssst",
      "body":"tesssst",
      "readIds":[
      ],
      "mode":"custom",
      "createdAt":"2022-07-21T13:30:10.759Z",
      "updatedAt":"2022-07-21T13:30:10.759Z"
   },
]

And I need to write a query to filter the array and get only those elements which readIds hasn't object with id equal to '62c56b2cffe059fdfdd19230'. My attempts were like this:

  .find({
            readIds: {
              $elemMatch: {
                id: {
                  $not: {
                    $eq: id,
                  },
                },
              },
            },
          })

wardialer · Accepted Answer · 2022-07-21 20:55:24Z

2

I'm not sure i got your question correctly, but isn't the following working?

db.getCollection('stuff').find({"readIds.id": {$ne: "62c56b2cffe059fdfdd19230"}})

you can test it here: Mongo Playground

answered Jul 21, 2022 at 20:55

wardialer

4923 silver badges9 bronze badges

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

1 Comment

Andrey Shostik Over a year ago

Great that it is, simpler than I though. Thank you.

Collectives™ on Stack Overflow

How to write a query in mongo db to find elements in which the nested array does not have an element with the given id?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related