How to use greater than with "or" condition in Activerecord?

Question

How do I use greater than together with "or" condition in activerecord? Here is what I am trying to do:

@contract_dues_now = ContractDue.where(:status => ['Unpaid', 'Partially Paid']).
  where(due_date: Date.today || ContractDue.arel_table[:due_date].gt(Date.today)).
  group(:contract_id).order(:due_date)

It doesnt seems correct to me as I this query result didnt output the OR statement like it suppose to:

http://stackoverflow.com/questions/10871131/how-to-use-or-condition-in-activerecord-query — ruby_newbie, Oct 05 '15 at 00:50

score 1 · Accepted Answer · answered Oct 05 '15 at 01:37

1

This should do it:

@contract_dues_now = ContractDue.where(:status => ['Unpaid', 'Partially Paid']).
    where('contract_dues.due_date = ? OR contract_dues.due_date > ?', Date.today, Date.today).
    group(:contract_id).order(:due_date)

answered Oct 05 '15 at 01:37

K M Rakibul Islam

33,760
12
89
110

score 0 · Answer 2 · answered Oct 05 '15 at 04:34

0

arel supports or operator.

where(ContractDue.arel_table[:due_date].eq(Date.today).or(ContractDue.arel_table[:due_date].gt(Date.today)))

https://github.com/rails/arel#more-sophisticated-queries

answered Oct 05 '15 at 04:34

tyamagu2

969
7
17

How to use greater than with "or" condition in Activerecord?

2 Answers2