Forum Is it possible to query 'where' on eager loaded relationship without a join?

messerli90

posted 9 years ago

Database Eloquent

Last updated 2 years ago.

messerli90

replied 9 years ago

Solution

Actually, I think I solved it. I was looking in the wrong part of the documentation.

This seems to work:

$query = Profile::with('user', 'rank', 'game', 'roles', 'gamemodes', 'characters')
    ->whereHas('user', function($query)
    {
      if(\Request::get('name'))
        $query->where('name', 'LIKE', '%' . \Request::get('name') . '%');
    })
    ->get();

Will come back, if this isn't the case after all.

messerli90

replied 9 years ago

Bonus Update:

I just realized that if I getXAttribute() I can then append this on my object and don't have to use ->with(). Which allows me to use the built in pagination