On 16 January 2012 15:54, Erwin <[email protected]> wrote: > when I use a quart joins on Roles and Profiles models > > Role.joins(:profiles).where('profiles.profilable_type' => "Admin") > > I get the following generated sql > SELECT `roles`.* FROM `roles` INNER JOIN `profiles_roles` ON > `profiles_roles`.`role_id` = `roles`.`id` INNER JOIN `profiles` ON > `profiles`.`id` = `profiles_roles`.`profile_id` WHERE > `profiles`.`profilable_type` = 'Admin' > > which gives me all roles attributes only > > I should I write my Rails query to get all attributes ? > > SELECT `roles`.*, `profiles`.* FROM `roles` INNER JOIN > `profiles_roles` ON `profiles_roles`.`role_id` = `roles`.`id` INNER > JOIN `profiles` ON `profiles`.`id` = `profiles_roles`.`profile_id` > WHERE `profiles`.`profilable_type` = 'Admin' > > in this case, I'll have 2 attributes with same name in both tables > ( :id and :name ) is there any way to avoid such collision ( using > AS ...) > > > > ====== > class Role < ActiveRecord::Base > has_and_belongs_to_many :profiles, :join_table => :profiles_roles
If you get the profiles using something like profiles = Profile.where( profileable_type => "Admin") then for each profile in the collection you can do profile.roles to get all the roles for that profile. Alternatively use :includes( :profiles ) rather than join and specify a where for the the profilable type which will give you a collection of Roles. Colin -- 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.
