Laravel - Access model attribute dynamically inside whereHas Closure

Question

Let's say I have the relation: Role has many Users. Role and user stores a code value.

If I want to select all roles that have users with same code, how would be this query using whereHas clause?

What I tried:

$roles = Role::whereHas('users', function ($users) {
    // Obviously doesn't work but it is what I need to access.
    $code = $users->first()
        ->role
        ->code;

    return $users->where('code', $code);
})->get();

Is this to see how it would would using the whereHas method, or just to have this working regardless of the method used? — thisiskelvin
– thisiskelvin, Commented Sep 18, 2018 at 14:14
@thisiskelvin Actually this is a symbolic example to a more complex one that I have to use whereHas. So it's required. — Alexandre Demelas
– Alexandre Demelas, Commented Sep 18, 2018 at 14:16
I would like to see the result of this. I think the problem is finding out a way to access the current role iteration within whereHas() to be able to use within the query. — thisiskelvin
– thisiskelvin, Commented Sep 18, 2018 at 14:24

Jonas Staudenmeir · Accepted Answer · 2018-09-18 14:35:42Z

1

Use this:

$roles = Role::whereHas('users', function ($query) {
    $query->whereColumn('users.code', 'roles.code');
})->get();

edited Sep 18, 2018 at 14:35

answered Sep 18, 2018 at 14:17

Jonas Staudenmeir

26k7 gold badges70 silver badges114 bronze badges

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

7 Comments

Alexandre Demelas Over a year ago

If I need to use the code value for another operation, like filter a php array, I couldn't use this approach?

Alexandre Demelas Over a year ago

For example: $code = $query->getColumn('roles.code');

Jonas Staudenmeir Over a year ago

I don't understand your question. You can get the code from the result: foreach($roles as $role) { echo $role->code; }

Vinay Over a year ago

You've missed the $query in function parameter

Alexandre Demelas Over a year ago

@JonasStaudenmeir no, I need the value of code inside whereHas Closure.

|

Collectives™ on Stack Overflow

Laravel - Access model attribute dynamically inside whereHas Closure

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related