find in array between dates in mongo

Question

I have mongo documents:

{
    id:1
    time:[
        1,
        2,
        10
    ]
}
{
    id:2
    time:[
        1,
        4,
        8,
        10
]
}

I want find all documents, which have time between 3 and 5 or between 7 or 9 (document with id 2). I dont know how do this.

I try:

mongo.find( $or : [{time:{$gte:3, $lte:5}}, {time:{$gte:7, $lte:9}}] )

and mongo returns documents with id 1 and 2, but i need id2 with time[4, 8].

How to apply a condition to each element of the array, but NOT to entire array?

p.s. Size array "time" maybe different

Martin Evans · Accepted Answer · 2013-08-01 11:39:43Z

3

If you're using the 'time' array as a placeholder for another array of storage then the previous comment with elemMatch should help you as this should cope with other numerical searches such as exam scores.

However, if you are using it for processing dates / times etc. then you might be better of working with unix timestamps for storage as this is done via integers and quite easy to search and store in mongodb and support is easy to come by for the majority of programming languages out there. (example in php: mktime() and DateTime::getTimestamp()).

answered Aug 1, 2013 at 11:39

Martin Evans

562 bronze badges

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

Comments

guido · Accepted Answer · 2013-08-01 10:22:44Z

2

Try using the $elemMatch operator:

mongo.find({time:{$elemMatch: {$gte:3,$lte:5}}})

Like with:

mongo.find( 
  {
    $or: [
      {time:{$elemMatch: {$gte:3,$lte:5}}},
      {time:{$elemMatch: {$gte:7,$lte:9}}}
    ]
  }
)

edited Aug 1, 2013 at 10:22

answered Aug 1, 2013 at 10:14

guido

19.3k6 gold badges74 silver badges97 bronze badges

1 Comment

user445338 Over a year ago

what if time was an array of objects rather than an array of numbers?

Collectives™ on Stack Overflow

find in array between dates in mongo

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