Mongo DB aggregation with array of objects

Question

My collection schema is as follows:

Product

{
  _id: ObjectId(), // default mongo db id
  specification: [
    {key: 'Name', value: "value 1"},
    {key: 'Category', value: "value 2"},
    {key: 'Department', value: "value 3"}
  ]
}

Now I want to query on this with a generic filter. For example,

Get me all product with Name = value 1 and Category in [value 2, value 3] and Department = value 3
Get me all product with Name = value 1 or Category = value 2 or Department in [value 3, value 4]

I have been trying to use $match with $elemMatch. But that only allows only one query but I am not able to use the $and and $or operator.

so you want two queries? one for Get me all product with Name = value 1 and Category in [value 2, value 3] and Department = value 3 And other for Get me all product with Name = value 1 or Category = value 2 or Department in [value 3, value 4] — Vijay Rajpurohit
– Vijay Rajpurohit, Commented May 5, 2020 at 18:33

thammada.ts · Accepted Answer · 2020-05-05 20:06:32Z

0

You can use $elemMatch just fine, you just have to put $and / $or at the top level.

Your first example would be

db.products.find({
  $and: [
    { 
      specification: {
        $elemMatch: { key: 'Name', value: 'value 1' }
      }
    },
    {
      specification: {
        $elemMatch: { key: 'Category', value: { $in: ['value 1', 'value 2'] } }
      }
    },
    { 
      specification: {
        $elemMatch: { key: 'Department', value: 'value 3' }
      }
    }
  ]
})

answered May 5, 2020 at 20:06

thammada.ts

5,2653 gold badges26 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

Mongo DB aggregation with array of objects

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related