Postgresql cross-database references in Rails

Question

I'm building a search for and got stuck on a cross-database references error

activities = Activity.order(:name).includes([:profile => :country])
activities = activities.where("lower(activities.city) like ?", "%#{params[:activity_search][:city].downcase}%") unless params[:activity_search][:city] == ""      
activities = activities.where("activities.sport_id =?", params[:activity_search][:sport_id])

I'm trying to add something like this:

activities = activities.where("activities.profiles.country.id =?", params[:activity_search][:country_id])

an activity's country is the same as the activity creator's country.

How can I add this constraint in my query?

Thanks for your help

ptd · Accepted Answer · 2015-02-18 16:26:10Z

1

You need to use joins here to include the associations:

activities.joins(profiles: :country).where('countries.id = ?', params[:whatever])

This assumes Activity has_many :profiles and Profile has_one :country and countries is your table name, but I think all that is true based on your post. This will include the associated profiles and country with activities and allow you to use their attributes in the where method call.

answered Feb 18, 2015 at 16:26

ptd

3,05418 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

Postgresql cross-database references in Rails

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