Overriding paginateTableQuery doesn't work on Widgets

The TableWidet Class has a paginateTableQuery method where simplePagination is used. The docs say, this can be overwritten. But using the method in my Widget doesn't work. It still shows the simplePagination.

With dd() I can verify that the method gets called though. Any ideas?

Code:

use Filament\Widgets\TableWidget;
use Illuminate\Contracts\Pagination\CursorPaginator;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Model;

class CompanyProximitySearch extends TableWidget
{
    public ?Model $record = null;

    protected int|string|array $columnSpan = 'full';

    protected function paginateTableQuery(Builder $query): CursorPaginator
    {
        return $query->cursorPaginate(($this->getTableRecordsPerPage() === 'all') ? $query->count() : $this->getTableRecordsPerPage());
    }
}

use Filament\Widgets\TableWidget;
use Illuminate\Contracts\Pagination\CursorPaginator;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Model;

class CompanyProximitySearch extends TableWidget
{
    public ?Model $record = null;

    protected int|string|array $columnSpan = 'full';

    protected function paginateTableQuery(Builder $query): CursorPaginator
    {
        return $query->cursorPaginate(($this->getTableRecordsPerPage() === 'all') ? $query->count() : $this->getTableRecordsPerPage());
    }
}

Solution

Yes I see, but in that case the paginateTableQuery is set to simple when extending the TableWidget. Changing it to extend "Widget" solves the issue. But I still don't know why the overwrite didn't work, as it normally should.

Jump to solution

PProdex The TableWidet Class has a paginateTableQuery method where simplePagination is u...

LeandroFerreira•12/2/24, 3:14 PM

add this trait

LLeandroFerreira add this trait ```php use \Filament\Tables\Concerns\CanPaginateRecords; ```

ProdexOP•12/2/24, 3:18 PM

Hm... I did that now, but it's still a simple Pagination in the Frontend.

PProdex Hm... I did that now, but it's still a simple Pagination in the Frontend. ```ph...

LeandroFerreira•12/2/24, 3:23 PM

remove method.

Simple pagination will also automatically adjust based on screen size, utilizing Tailwind's responsive breakpoints.

Solution

LLeandroFerreira remove `paginateTableQuery` method. Simple pagination will also automatically a...

Prodex•12/2/24, 3:33 PM

PProdex Yes I see, but in that case the paginateTableQuery is set to simple when extendi...

LeandroFerreira•12/2/24, 3:36 PM

I didn't understand your question and didn't also understand why you marked your answer as answered

LLeandroFerreira I didn't understand your question and didn't also understand why you marked your...

ProdexOP•12/2/24, 3:42 PM

Sorry, let me explain:

My Widget extended "TableWidget", which has the following vendor code:

So using TableWidget the pagination is already set to simple. Which I should be able to overwrite but that didn't work for some reason. Now, since you can also use custom widgets which just extend "Widget" that don't set the pagination to simple, I implemented HasTables and HasForms myself and the cursor pagination appeared as expected.

I just don't understand why overwriting the paginateTableQuery method while extending TableWidget didn't do anything.

For your last response: just removing "paginateTableQuery" in my Widget would still cause the pagination to be simple, as it is set so in the TableWidget.

Did you understand that?