I want to write following query rails way

Question

select DISTINCT firstname 
  from users u 
    inner join  members m 
      on m.user_id = u.id 
    inner join  member_roles m1 
      on m1.member_id = m.id 
    inner join roles r
      on r.id = m1.role_id  
  where r.name  = 'Project Coordinator'

this gives perfect result

I tried to write above query rails way like

s = MemberRole.joins(:role).where("roles.name" => "Project Coordinator")

@u = User.select("users.firstname").includes(:members => s )

but seems doesnt work any help?? thanks in advance

What associations have you defined between User, Member, MemberRole and Role models? — BroiSatse
– BroiSatse, Commented Feb 3, 2014 at 13:07

Anish · Accepted Answer · 2014-02-03 13:25:00Z

1

User.select("users.firstname").includes(:members => [{:member_roles => :role}]).where("roles.name" => "Project Coordinator")

answered Feb 3, 2014 at 13:25

Anish

5583 gold badges10 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

I want to write following query rails way

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related