Mongoid date range query

ruby-on-rails mongodb mongoid
Dustin Brewer picture Dustin Brewer · May 6, 2011 · Viewed 11k times · Source

I can't seem to find anything to make a date range query using Mongoid/Rails. Below are some queries I've tried (among about 100 others). If it returns anything, it always ignores the 'end_date'. Both dates are datetimes...

all(:conditions => {:created_at => start_date.to_datetime..end_date.to_datetime})

results in:

NoMethodError: undefined method `to_i' for Tue, 26 Apr 2011 00:00:00 +0000..Fri, 06 May 2011 00:00:00 +0000:Range

another example...

where(:created_at => {'$gte' => start_date,'$lt' => end_date})

results in a successful query but the end date is ignored. The results come back correctly after the start date but are not limited by the end date.

I've been working on this problem for several days to no avail. Not much help online, in the forums or IRC.

Would love to figure what I'm doing wrong :)

Answer

Dustin Brewer picture Dustin Brewer · May 7, 2011

There was a bug in Mongoid. Fixed now.

For more information:

https://github.com/mongoid/mongoid/issues/761

https://github.com/mongoid/mongoid/commit/f326de5acc969e1342e640dc026de7e94bf4cf49#lib/mongoid/matchers.rb

Related questions

How to implement has_many :through relationships with Mongoid and mongodb?

Using this modified example from the Rails guides, how does one model a relational "has_many :through" association using mongoid? The challenge is that mongoid does not support has_many :through as ActiveRecord does. # doctor checking out patient class Physician &…

Read More
Is it bad to change _id type in MongoDB to integer?

MongoDB uses ObjectId type for _id. Will it be bad if I make _id an incrementing integer? (With this gem, if you're interested)

Read More
How to query MongoDB directly from Ruby instead of using Mongoid?

I am writing a migration for a Rails application that uses MongoDB and Mongoid. My migration currently uses my models that use Mongoid to query and update records, but the performance is sub-par. I am essentially updating all records in …

Read More