Sijo Kg wrote: > suppose if the junction model is ProfileUser You can define like > > Profile.rb >> ----------- > has_many :profile_users > has_many :users, :through => :profile_users >> > User.rb >> ------- > has_many :profile_users > has_many :profiles, :through => :profile_users > > profile_users.rb > belongs_to :user > belongs_to :profile > > Now you can access like @user.profiles Is that what u want? > > Sijo
Thanks for your input. I'm able to do @user.profiles, that is not creating any problem. The problem is, User: -------- has_many :profile_users has_many :profiles, through=>:profile_users has_many :community, through=>:profiles where community --------- has_many :profiles has_many :users , through=>:profiles and profile ------- belongs_to :community profiles_users -------------- belongs_to :profile belongs_to :user When do @user.communities, flow should be like this: ----------------------------------------------------------------------------- Join the profile and profile user table and get all the profiles that belong to the user and, from the profiles check the community it belongs to and then return the result(communities). but am not getting the desired result because rails is not joining all the tables needed, it is checking for community_id in profile_users whereas it is in profile table. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
