Rails, Postgres, ActiveRecord query postgres based on columns value

Question

I working with Rails and Postgresql and I'm trying to query my postgres db based on the value of a column.

To put it into perspective, I have an Events table in postgres and in that table I have some events that are recurring and some that aren't based on the column value of repeats.

If the events recur, then they will have a value of daily, weekly, monthly, etc. inside of the repeats column. Obviously, if it doesn't recur then the value will be set to null.

I would like to receive only those events that recur in the repeats column. So if it's null, then the query will skip over it.

I've looked through the ActiveRecord Query Interface but due to my inexperience, I was unable to find a helper that would do the trick for me.

Please let me know if more info is needed.

Any advice will be greatly appreciated. Thanks!

DVG · Accepted Answer · 2015-06-14 01:25:04Z

1

Event.where.not(repeats: nil)

Alternatively, you can specify a sql stream

Event.where("repeats is not null")

answered Jun 14, 2015 at 1:25

DVG

17.5k7 gold badges64 silver badges88 bronze badges

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

1 Comment

Nigel Earle Over a year ago

Thanks so much. Appreciate the help. @DVG

Collectives™ on Stack Overflow

Rails, Postgres, ActiveRecord query postgres based on columns value

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