Can you do greater than comparison on a date in a Rails 3 search

Question

I have this search in Rails 3   Note where  user id   gt  current user id   notetype   gt  p  note type    date   gt  p  date   order  date ASC  created at ASC     But I need the  date   gt  p  date  condition to be equivilent to  date  gt  p  date   How can I do this  Thanks for reading

User · Accepted Answer

Note    where  user id   gt  current user id   notetype   gt  p  note type      where  date  gt      p  date      order  date ASC  created at ASC     or you can also convert everything into the SQL notation  Note    where  user id     AND notetype     AND date  gt      current user id  p  note type   p  date      order  date ASC  created at ASC

User · Answer

Rails 6 1 added a new  syntax  for comparison operators in where conditions  for example  Post where  id  gt    9  Post where  id  gt     9  Post where  id  lt    3  Post where  id  lt     3   So your query can be rewritten as follows  Note    where user id  current user id  notetype  p  note type    date  gt    p  date      order date   asc  created at   asc   Here is a link to PR where you can find more examples

User · Answer

If you hit problems where column names are ambiguous  you can do   date field   Note arel table  date  Note where user id  current user id  notetype  p  note type         where date field gt p  date          order date field asc    Note arel table  created at  asc

User · Answer

You can try to use   where date  p  date   Float  INFINITY    equivalent in sql  WHERE   date   gt   p  date     The result is   Note where user id  current user id  notetype  p  note type   date  p  date   Float  INFINITY  order  fecha   created at    And I have changed too  order  date ASC  created at ASC     For  order  fecha   created at

User · Answer

If you aren t a fan of passing in a string  I prefer how  sesperanto has done it  except to make it even more concise  you could drop Float  INFINITY in the date range and instead simply use created at  p  date    Note where      user id  current user id      notetype  p  note type       created at  p  date      order  date   created at   Take note that this will change the query to be  gt   instead of  gt   If that s a concern  you could always add a unit of time to the date by running something like p  date    1 day

[ruby-on-rails] Can you do greater than comparison on a date in a Rails 3 search?

Examples related to ruby-on-rails

Examples related to activerecord

Examples related to ruby-on-rails-3