RAILS Query - How to use the 'where' method - rails 4

Question

I am new to rails - any help would be much appreciated.

I have a list of created job adverts
Advert is a model
In the schema Advert is a table with the columns title, content & deadline
I would like to only display adverts whose deadline are '= or >' than Date.current (active adverts)

Unfortunately I am unsure how to do it. I tried the below in the console:

active_adverts = Advert.where(:deadline > Date.current)

Could one kindly advise me on how to display adverts that have a deadline greater than the current date?

Zoran · Accepted Answer · 2015-10-05 21:58:03Z

6

You can use the following syntax:

active_adverts = Advert.where('deadline >= ?', Date.current)

Hope it helps!

edited Oct 5, 2015 at 21:58

answered Oct 5, 2015 at 20:31

Zoran

4,2562 gold badges26 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mahi-man Over a year ago

You should also check out scopes. If you create a scope in your Advert model like: scope :active, -> { where("deadline >= ?", Date.current) } then you can re-use whenever you are doing an activerecord query on Adverts e.g. Advert.active or if a user has_many adverts @user.adverts.active

Collectives™ on Stack Overflow

RAILS Query - How to use the 'where' method - rails 4

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related