Level 73
That's fine as long as you have the relationship setup correctly. Proving that it is correct Eloquent you can see it used in the docs too: https://laravel.com/docs/8.x/eloquent-relationships#querying-relationship-existence
1 like
Jan 26, 2022
4
Level 1
Eloquent - 'where' in belongstoMany relationship
Newbie question here :-)
Is this the proper way to 'where' in belongstoMany relationship?
$platforms = Platform::with('users')
->whereHas('users', function ($q) {
$q->where('id', '=', Auth()->user()->id);
})
->orderBy('id', 'desc')
->get();
Looks like I'm not using proper Eloquent for this...
Level 1
@Nakov Thanks! It is working as it should. But I thought there must be a nicer/cleaner way :-)
Level 75
You code could look like this
$platforms = Platform::with('users')
->whereRelation('users', 'id', auth()->id())
->orderByDesc('id')
->get();
1 like
Level 1
@MichalOravec Thanks a lot!
Please or to participate in this conversation.