Queries: "between" or "range" queries (<, >)

[mikermcneil]

Presently, you can do > and <, but you can't do between.

Example usage:

// Get all users between the ages of 18 and 21
User.findAll({
  age: {
    '>=': 18,
    '<': 21
  }
}).done(function (err, users) {
  if (err) return res.send(err,500);
  res.json(users);
});

( PS- this isn't high priority really, just cleaning up-- migrated from: #274 )

[terox]

+1

[artworkad]

👍 WOW guys this is essential

[artworkad]

However using native() we can achieve the same http://cookbook.mongodb.org/patterns/date_range/

[terox]

@artworkad, I think that using native method is a patch, but not a solution :)

I think also that this feature is essential

[v-sullivan]

Hi all,
Sorry to say that during my fist post but yes, I think that it's an important point too !
Getting a set between 2 dates must be straighforward and not depending on the underneath datastore technology.
Saying that, I know that it's not trivial and despite that I am a Sails framework enthusiast I don't really know how to help.

[particlebanana]

You can do:

User.find({
    date: { '>': new Date('2/4/2014'), '<': new Date('2/7/2014') }
}).exec(/* ... */);