Compare dates along with other constraints in ActiveRecord query

Question

I'm trying to grab space listing date which is greater than another date.

So far, I have...

    Booking.where({ space_listing_id: 22, approved_status: true, ['move_out < ?', potential_move_in] })

I need to check if the Booking potential date is greater than each space_listing with move_out date.

My move_out and move_in is a datetime.

http://stackoverflow.com/a/4224627/2545197 this answer should help — Abhinay, Jun 16 '16 at 02:21
Thanks Abhinay. it is working now. I did Booking.where("move_out < ?", potential_move_in).where({space_listing_id: 22, approved_status: true}) — Anna_Natorilla, Jun 16 '16 at 02:27
With another `where` query..answer to your question is there itself. — Abhinay, Jun 16 '16 at 02:31

Abhinay · Accepted Answer · 2017-07-31T06:48:21.300

2

In order to combine multiple constraints in an ActiveRecord query, you can simply use multiple where clause.

Booking.where(space_listing_id: 22, approved_status: true).where("move_out < ?", potential_move_in)

edited Jul 31 '17 at 06:48

answered Jun 16 '16 at 02:43

Abhinay

1 Answers1