Searching a model based on a filter on its association

rubyonrails-talk
1

Hi all,

I got association like the following in my rails app. Class User < ActiveRecord::Base has_one :profile end

Class Profile < ActiveRecord::Base establish_connection :some_other_db belongs_to :user end

I need to search users based on the age stored in the profile I tried using the :joins option of find. but it seems it works only on tables in the same db.

Is there a way i can tell (:joins) to join a table from another db? Or is there some other better way in which this could be achieved?

2

Sahil Dave wrote:

I need to search users based on the age stored in the profile I tried using the :joins option of find. but it seems it works only on tables in the same db.

But of course.

So search the Profiles, get your list of user_id's that match the criteria, then select the Users.