Forum: Rails I18n Polymorphic associations has_many :through

Posted by Preethi Sivakumar (preethi)
on 2009-02-27 15:55
Hi,
I'm facing an issue in polymorphic associations when i try to to
:through relationship.
I've three models:profile,gbluser,community

profile.rb
-------------
  belongs_to :node ,:polymorphic => true
  belongs_to :community,:class_name => "community",
                        :foreign_key => "node_id",
                        :conditions => "node_type = 'community'"
  belongs_to :gblorganization,:class_name => "gblorganization",
                        :foreign_key => "node_id",
                        :conditions => "node_type = 'gblorganization'"
  has_and_belongs_to_many :gblusers

Vcgbluser.rb
------------
has_many :communities,,:through=>:profiles,:conditions =>
"profiles.node_type = 'Community'",:source=>:community

Vccommunity.rb
--------------
has_many :gblusers ,:class_name
=>"gbluser",:through=>:profiles,:conditions => "profiles.node_type =
'Community'",:source=>:community

I'm trying to implement has_many :through relationship between community
and users.
user has_many communities through profiles and
communities has_many users through profiles

When i'm trying to do @user.communities, the search is made not on the
mapping table between user and profiles but on the profile table itself.
Rails is searching for user_id in profiles table but i've
has_and_belongs_to_many between profile and user.
How to solve this problem? Am I wrong somewhere. Please guide me.
Thanks
Please log in before posting. Registration is free and takes only a minute.
Existing account (Switch to SSL-encrypted connection)
NEW: Do you have a Google/GoogleMail or Yahoo account? No registration required!
Log in with Google account | Log in with Yahoo account
No account? Register here.