indexzer0/eloquent-filtering
Filter Laravel Eloquent models using simple arrays and request data—no custom query spaghetti. Define allowed filters on your models, support complex search, and keep queries readable, maintainable, and easy to extend for APIs and dashboards.
You can use dot notation for filter targets.
This may be useful when wanting to filter by a join column.
$sql = Author::filter(
[
[
'target' => 'age',
'type' => '$eq',
'value' => 20,
],
],
Filter::only(
Filter::field(
Target::alias('age', 'author_profiles.age'),
[FilterType::EQUAL]
),
)
)->join('author_profiles', function (JoinClause $join): void {
$join->on('authors.id', '=', 'author_profiles.author_id');
})->toRawSql();
select * from "authors" inner join "author_profiles" on "authors"."id" = "author_profiles"."author_id" where "author_profiles"."age" = 20
How can I help you explore Laravel packages today?