How to do a search on the field of the main model OR in the hasMany model?

Question

css

There is a model Task(id, author_id)
There is a model Subscriber (id, task_id, user_id)
Accordingly, a Task may or may not have several Subscribers.

public function subscribers()
 {
        return $this->hasMany('\App\Models\Subscriber', 'task_id');
}

How do I query to find all issues where Auth::user()->id OR author OR subscriber?
PS Current version excluding subscribers:

$tasks = Task::filter($filter)
            ->with('author', 'subscribers')
            ->where('author_id', Auth::user()->id)
            ->orderBy('status')
            ->orderBy('level', 'desc')
            ->orderBy('created_at', 'desc')
            ->get();

Answer 1

nicolasgallagher.com/pure-css-speech-bubbles/demo

Answer 2

You need the orWhereHas method .
https://laravel.com/docs/5.4/eloquent-relationship...