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?

Answer 1

You can use the following syntax:

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

Hope it helps!