Rails query using object's attribute

Question

I have a model, Consultation, and it has two fields :date and :original_date. Is it possible to pull all consultations where :date is greater than one year after :original_date without looping through all consultations?

I tried something like this but it didn't work:

Consultation.where("date >= ?", self.original_date + 1.year)

Eyeslandic · Accepted Answer · 2021-02-12 15:16:02Z

1

If you're using Postgres you can do this

Consultation.where("date >= (original_date + INTERVAL '1 year')")

https://www.postgresql.org/docs/current/functions-datetime.html

edited Feb 12, 2021 at 15:16

answered Feb 12, 2021 at 15:05

Eyeslandic

14.9k13 gold badges44 silver badges55 bronze badges

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

Collectives™ on Stack Overflow

Rails query using object's attribute

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related