Laravel Packages

Apply Dynamic Filters to Eloquent Models with the Filterable Package

Published
Apply Dynamic Filters to Eloquent Models with the Filterable Package image

Filterable is a Laravel package by Jerome Thayananthajothy that enhances Laravel queries with adaptable, customizable filters and intelligent caching to improve both performance and functionality.

The main features of this package include:

  • Dynamic Filtering: Apply filters based on request parameters with ease.
  • Caching: Improve performance by caching query results.
  • User-specific Filtering: Easily implement filters that depend on the authenticated user.
  • Custom Filter Methods: Extend the class to add your own filter methods.

Defining Filter classes is at the center of this package, where you can create methods that can apply filtering to Eloquent queries. The package includes a make:filter Artisan command to generate a filter in your app's App\Filters namespace. Here's an example of a filter from the package's README:

namespace App\Filters;
 
use Filterable\Filter;
use Illuminate\Database\Eloquent\Builder;
 
class PostFilter extends Filter
{
protected array $filters = ['status', 'category'];
 
protected function status(string $value): Builder
{
return $this->builder->where('status', $value);
}
 
protected function category(int $value): Builder
{
return $this->builder->where('category_id', $value);
}
}

Given a PostFilter, you can utilize this class in a controller with the Post model to filter models based on the HTTP query params:

public function index(Request $request, PostFilter $filter)
{
// i.e., /posts?status=active&category_id=2
$query = Post::filter($filter);
 
$posts = $request->has('paginate')
? $query->paginate($request->query('per_page', 20))
: $query->get();
 
return response()->json($posts);
}

You can learn more about this package, get full installation instructions, and view the source code on GitHub.

Paul Redmond photo

Staff writer at Laravel News. Full stack web developer and author.

Sponsored

laravelcloud logo
Laravel Cloud

Easily create and manage your servers and deploy your Laravel applications in seconds.

Visit Laravel Cloud

The latest

View all →
Building EasyReply: How We Used Laravel to Unify Customer Support image

Building EasyReply: How We Used Laravel to Unify Customer Support

Read article
PostgreSQL Monitoring and Schema Linting for Laravel with Vacuum image

PostgreSQL Monitoring and Schema Linting for Laravel with Vacuum

Read article
PayZephyr: One Payment API for Stripe, Paystack, and PayPal image

PayZephyr: One Payment API for Stripe, Paystack, and PayPal

Read article
Bifrost Turns One With AI Builds and New Workflows image

Bifrost Turns One With AI Builds and New Workflows

Read article
Preview Blade Templates in macOS Finder with Quick Blade image

Preview Blade Templates in macOS Finder with Quick Blade

Read article
Artisan Debugging Commands in Laravel Telescope 5.24.0 image

Artisan Debugging Commands in Laravel Telescope 5.24.0

Read article