MongoDB: Find Subdocument in Array Matching Parameters

Question

In MongoDB I would like to find a document based on the values of a subdocument meeting certain parameters. Specifically I have a document structured like this:

{
  name: "test",
  data: [{
    name: "test1",
    start: 0,
    end: 2
  },
  {
    name: "test2",
    start: 15
    end: 18
  }]
}

How can I tell MongoDB to only return my document if the start time for a data subdocument is less than 5 and the end time for the same subdocument is greater than 5? Currently, if I do

db.foo.findOne({
  'data.start': { $lte: 5 },
  'data.end': { $gte: 5 }
})

it will return my document always because 5 is greater than 0 and less than 18. How can I tell MongoDB to only return my document if 5 (or whatever value) is greater than 0 and less than 2 OR greater than 15 and less than 18?

Community · Accepted Answer · 2013-10-05 18:49:09Z

79

You want to use $elemMatch.

db.foo.findOne({ data: { $elemMatch : {
  start: { $lte: 5 },
  end: { $gte: 5 }
  }}
})

edited Oct 5, 2013 at 18:49

CommunityBot

11 silver badge

answered Aug 6, 2012 at 6:18

Thilo

264k107 gold badges527 silver badges674 bronze badges

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

Comments

Arpit Aggarwal · Accepted Answer · 2016-02-04 04:59:49Z

2

Came across this post thinking of cheating the code which wasn't there ;) So thought of sharing the code snippet in Java using spring-data-mongodb

Mongo mongo = new Mongo("localhost", 27017);
MongoTemplate mongoTemplate = new MongoTemplate(mongo, "db");
Query query = new Query();
query.addCriteria(Criteria.where("data").elemMatch(
         Criteria.where("start").lte(5)
        .andOperator(Criteria.where("end").gte(5))));
Foo foo = mongoTemplate.findOne(query, Foo.class);

answered Feb 4, 2016 at 4:59

Arpit Aggarwal

29.5k16 gold badges97 silver badges110 bronze badges

1 Comment

Newton Over a year ago

can you give a code snippet like that using morphia?

Collectives™ on Stack Overflow

MongoDB: Find Subdocument in Array Matching Parameters

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related