query nested array of object mongoose

Question

I would like to find name with alexa in nested object Playground: https://mongoplayground.net/p/rqYQtf0liaX

[
  {
    item: "journal",
    instock: [
      {
        warehouse: "A",
        qty: 5,
        items: null
      },
      {
        warehouse: "C",
        qty: 15,
        items: [
          {
            name: "alexa",
            age: 26
          },
          {
            name: "Shawn",
            age: 26
          }
        ]
      }
    ]
  }
]

What i have tried so far and this returns no document found

db.collection.find({
  "instock.items": {
    $elemMatch: {
      name: "Alexa"
    }
  }
})

ambianBeing · Accepted Answer · 2020-07-18 16:07:40Z

11

Mongo is case sensitive.

play

db.collection.find({
  "instock.items": {
    $elemMatch: {
      name: "alexa"
    }
  }
})

If you want to have case-insensitive, use regex or $text. With $regex, you can use $elemMatch.

db.collection.find({
  "instock.items": {
    $elemMatch: {
      name: {
        $regex: "alexa",
        $options: "i"
      }
    }
  }
})

edited Jul 18, 2020 at 16:07

ambianBeing

3,5492 gold badges17 silver badges28 bronze badges

answered Jul 18, 2020 at 15:39

Gibbs

23.1k14 gold badges84 silver badges147 bronze badges

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

Collectives™ on Stack Overflow

query nested array of object mongoose

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related