Query an array of subdocuments in Mongodb

Question

I have a collection of documents that goes like this:

{
  name: "Whatever 1".
  distances: [
    {name: "first distance", distance: 3000},   
    {name: "another distance", distance: 8000},
  ]
},
{
  name: "Whatever 2".
  distances: []
},
{
  name: "Whatever 3".
  distances: [
    {name: null, distance: 6000},   
  ]
},
{
  name: "Whatever 4".
  distances: [
    {name: "hello", distance: 100000},   
  ]
},

I need to get all the documents that contains a distance in a given range.

Example: If I query for distance greater than 5000 and smaller than 9000, I want to get documents "Whatever 1" and "Whatever 3"

How can I do this?

mickl · Accepted Answer · 2019-03-10 20:18:35Z

1

You can use $elemMatch to specify range condition for single subdocument of distances array:

db.col.find({ distances: { $elemMatch: { distance: { $gt: 5000, $lt: 9000 } } } })

answered Mar 10, 2019 at 20:18

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

Collectives™ on Stack Overflow

Query an array of subdocuments in Mongodb

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related