MongoDB: find value in Array with multiple criteria

Question

I'm trying to filter documents based on their price range,

i have the following document structure example

{
    "name": "test 1",
    "priceObject" : [
        {
            "price" : {
                "value" : 1000
            }
        },
        {
            "price" : {
                "value" : 500
            }
        },
        {
            "price" : {
                "value" : 333
            }
        }
    ]
}

i use aggregate to match documents that have at least one price that must be greater than 500 and less than 1000

{
    "$match": {
        "priceObject.price.value": {
            "$gt": 500,
            "$lt": 1000
        }
    }
}

it return "test 1" document, although it should not, because

500 is not less than 1000 and greater that 500
1000 is not less than 1000 and greater that 500
333 is not less than 1000 and greater that 500

how can i do that?

Thanks

Ashh · Accepted Answer · 2019-07-25 09:36:20Z

1

If you specify more than one condition to query an array then you have to use $elemMatch query operator

db.collection.aggregate([
  { "$match": {
    "priceObject": {
      "$elemMatch": {
        "price.value": {
          "$gt": 500,
          "$lt": 1000
        }
      }
    }
  }}
])

answered Jul 25, 2019 at 9:36

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

Collectives™ on Stack Overflow

MongoDB: find value in Array with multiple criteria

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