How do I build a scope that will pass the first relationship back

Question

Ok so i have users and company and there a a join table on a many to many relationship

SO i can do

@user.companies

Can i do a scope that passes back the first company

i tied this in the user model

 scope :first_company, includes(:companies_users).where(:user_id => self.id).first

and this fails....any suggestions

Update

I have this that will work also but i was wondering if there was a equivalent scope

 def company
   self.companies.first
 end

`User` already has the method `first`. Use another name for your scope. — jdoe, May 18 '12 at 13:26
Scope works on the whole model. Like `User.admins`. You're trying to make some "scope" on the `@user`, which obviously makes no sense: scope limits results, what can you limit on the `@user`? So, you're right when you create method, which is called on a particular user rather than on all users. — jdoe, May 18 '12 at 13:37

score 1 · Accepted Answer · edited May 23 '17 at 12:04

1

You need to define your scope as a lambda as the context of self in a scope would be the class not the instance.

see this SO article for how to do that.

edited May 23 '17 at 12:04

Community

answered May 18 '12 at 13:37

engineerDave

1 Answers1