Rails where clause with between not working in mysql

Question

I have the following query in rails...

@registrations = Registration.where(Orientation.where(class_date: @start_date..@end_date))

The query itself does not throw an error, however if I try to inspect @registrations do anything with the variable I get the error...

Cannot visit ActiveRecord::Relation

Any ideas?

Hope it helps http://stackoverflow.com/questions/11689720/how-to-add-conditional-where-clauses-in-rails — M Khalid Junaid, Feb 19 '14 at 20:32

xlembouras · Accepted Answer · 2014-02-20T14:06:16.490

4

Orientation.where(class_date: @start_date..@end_date)

does the range query you like

SELECT * FROM orientations WHERE class_date BETWEEN <start_date> AND <end_date>

UPDATE

Registration.where(created_at: @start_date..@end_date).
  joins(:orientation).
  where('orientations.created_at' => @start_date..@end_date)

will make the following SQL which I think is what you need

SELECT registrations.* FROM registrations INNER JOIN orientations ON orientations.id = registrations.orientation_id WHERE (registrations.created_at BETWEEN '2014-02-17 16:01:41' AND '2014-02-19 16:01:41') AND (orientations.created_at BETWEEN '2014-02-17 16:01:41' AND '2014-02-19 16:01:41')

edited Feb 20 '14 at 14:06

answered Feb 19 '14 at 20:32

xlembouras

8,215
4
33
42

This works for Orientations, but not registrations. The query Orientation.where(class_date: @start_date..@end_date) is valid, but the query Registration.where(Orientation.where(class_date: @start_date..@end_date)). I get the error Cannot visit ActiveRecord::Relation – Mark Locklear Feb 20 '14 at 13:50
Correct, Orientation has_many Registrations, and Registration belongs_to Orientation. – Mark Locklear Feb 20 '14 at 13:55
I updated my post to show the current error I am getting with my code. – Mark Locklear Feb 20 '14 at 14:02
Daym son...you nailed it! Thanks so much. – Mark Locklear Feb 20 '14 at 14:10

Rails where clause with between not working in mysql

1 Answers1