Blog Detail


A Query Database Collection for Use with Laravel Pipeline cover image

A Query Database Collection for Use with Laravel Pipeline

Pipeline-query-collection is an amazing package that contains a collection of classes that can be used with the Laravel Pipeline.

// users?name=Baro&is_admin=1&created_at_from=2022-06-01&created_at_to=2022-06-31
$users = User::query()
    ->when($request->name ?? null, function($query, $name) {
        $query->where('name', 'like', "%$name%");
    ->when($request->is_admin ?? null, function($query, $isAdmin) {
        $query->where('is_admin', $isAdmin ? 1 : 0);
    ->when($request->created_at_from ?? null, function($query, $date) {
        $query->where('created_at', '>=', $date);
    ->when($request->created_at_to ?? null, function($query, $date) {
        $query->where('created_at', '<=', $date);

As you all can see, it's obvious that filter conditions will continue to grow as well as the duplication of the same filter for other queries. We can use Laravel Pipeline combine with some pre-made queries to refactor this

use Baro\PipelineQueryCollection;

// users?name=Baro&is_admin=1&created_at_from=2022-06-01&created_at_to=2022-06-31
$users = Users::query()->filter([
    new PipelineQueryCollection\RelativeFilter('name'),
    new PipelineQueryCollection\BooleanFilter('is_admin'),
    new PipelineQueryCollection\DateFromFilter('created_at'),
    new PipelineQueryCollection\DateToFilter('created_at'),


You can install this package via composer by running this command:

composer require l3aro/pipeline-query-collection

Optionally, you can publish the config file with:

php artisan vendor:publish --tag="pipeline-query-collection-config"

This is the contents of the published config file:


Preparing your model

To use this collection with a model, you should implement the following interface and trait:

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Baro\PipelineQueryCollection\Concerns\Filterable;
use Baro\PipelineQueryCollection\Contracts\CanFilterContract;

class YourModel extends Model implements CanFilterContract
    use Filterable;

    public function getFilters(): array
        return [
            // the filter and sorting that your model need

After setup your model, you can use a scope filter on your model like this


You can also override the predefined filter lists in your model like this

    // the custom filter and sorting that your model need


Here are the features below:

  • Bitwise filter
  • Boolean filter
  • Date From filter
  • Date To filter
  • Exact filter
  • Relation filter
  • Relative filter
  • Scope filter
  • Sort
  • Detector
  • Custom search column

If you want to see the details of the above features with code examples. You can visit its documentation on Github.

Closing Notes

Being a custom web development company, Codebrisk has great experience in developing CRM software, and e-commerce and SASS web applications for a variety of industries. So if you want to develop any web application, We are here to assist you with this initiative. Please Feel free to get in touch or launch a project with us.

Published at : 09-06-2022

Author : Rizwan Aslam
Rizwan Aslam

I am a highly results-driven professional with 12+ years of collective experience in the grounds of web application development especially in laravel, native android application development in java, and desktop application development in the dot net framework. Now managing a team of expert developers at Codebrisk.

Launch project