ActiveRecord 4 rails not equal to condition
I am using rails 4 to develop my application. I have a problem with my active record request not equal to a condition. I am not getting the desired result. I think there is a problem with not equal parts.
@available_rooms = Room.joins("LEFT OUTER JOIN reservations ON reservations.room_id = rooms.id").where("category_id = ? AND arrival_date != ?",params[:category],params[:arrival_date])
source to share