How to filter paginated results?

You should apply filter before paginating results. Think of pagination as a view. First you get data then you pass it to the view.

@aurawindsurfing Thanks for the reply.

I am trying to do such thing.

$items = $items->paginate(10);
$filtered = $items->filter( function($item) {
            if (condition) {
                return true;
            }
  }); 

Now I want to show the filtered items in view but with pagination links. I hope you got my point. Please reply.

@kkatwork do paginate last

$items = Model::all();

$items = $items->filter( function($item) {
            if (condition) {
                return true;
            }
  }); 
return $items->paginate(10);

if you filter after your paginate, you wont have the right number of results per page as you'll be removing some of them with your filter.

@automica Thanks for reply.

I tried that. But I get error - 'paginate' does not exist. I think it is because after filtering we get a collection and paginate does not exist on collection.

You must apply filter to your DB/Eloquent query. Don't try to do it on the collection.

@snapey Thanks for the reply.

I have a little complex condition. When I do it by chaining where method on eloquent I get not a number and various other errors. Can you guide me how should I do this operation please?

where(function($query){
            $query->where(((int)'items' - (int)'checked_items') - 'other_item', '>', 3);
        })