How to create a scope to search by a field of a 1 to n relationship?

Two models, User and Company User hasMany Company (each company has a user_id field)

I need to filter users where 'description' on one of its company is like a specific description.

Is it possible to create a scope of this kind? to be used as ->companyDescriptionLike($user_entered_value)?

SilenceBringer

4 years ago

Level 55

@realtebo assuming relation in User model called companies (fix if wrong)

public function scopeCompanyDescriptionLike($query, $value)
{
	return $query->whereHas('companies', fn ($query) => $query->where('description', 'like', '%' . $value . '%'));
}

https://laravel.com/docs/8.x/eloquent-relationships#querying-relationship-existence

Please or to participate in this conversation.