MongoDB filter on same object in array

Question

I have object with column chars with such data:

{
  "chars": [
    {
      "count": 1,
      "color": "red"
    },
    {
      "count": 2,
      "color": "green"
    },
    {
      "count": 3,
      "color": "blue"
    }
  ]
}

I want to exclude records with chars like

{"count": 2, "color": "blue"}

I filter by (demo1)

{
    "$or": [
        {
            "chars.count": {
                "$ne": 2
            }
        },
        {
            "chars.color": {
                "$ne": "blue"
            }
        }
    ]
}

or (demo2)

{
    "chars.count": {
        "$ne": 2
    },
    "chars.color": {
        "$ne": "blue"
    }
}

I want to receive object, but receive empty set.

I use MongoDB 6.0.6

Your question is unclear. You want the returned document with filtered chars in the projection? Should be filter 2 not 3 according to your question? — Yong Shun
– Yong Shun, Commented Jul 29, 2024 at 12:26
I want to receive whole object with array chars with all objects in it, because I haven't {"count": 2, "color": "blue"} — M-A-X
– M-A-X, Commented Jul 29, 2024 at 14:56

jQueeny · Accepted Answer · 2024-07-31 13:36:35Z

1

I think what you're looking for is to use the $elemMatch query operator to match documents that have an array element containing { count: 2, color: "blue" } and just negate the results by using $not. This will return all documents that didn't match, which I think is what you're aiming for:

db.collection.find({
  chars: {
    $not: {
      $elemMatch: {
        count: 2,
        color: "blue"
      }
    }
  }
})

See HERE for a working example.

answered Jul 31, 2024 at 13:36

jQueeny

8,9253 gold badges8 silver badges29 bronze badges

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

Comments

General Grievance · Accepted Answer · 2024-07-29 12:26:22Z

-2

Your query should be like this

"$or": [
    { "chars.count": { "$ne": 2 } },
    { "chars.color": { "$ne": "blue" } }
  ]

edited Jul 29, 2024 at 12:26

General Grievance

5,12039 gold badges39 silver badges60 bronze badges

answered Jul 29, 2024 at 11:21

akinbode abdulrazaq

221 silver badge5 bronze badges

Collectives™ on Stack Overflow

MongoDB filter on same object in array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related