Getting the table's query with sorting and filtering applied by Andréia Bohner - Tricks

You can use the getFilteredTableQuery() and applySortingToTableQuery($query) methods to get the table query with the selected filtering and sorting applied.

The example below is an action to export the table using the Laravel Excel library:

<?php
 
namespace App\Filament\Resources\UserResource\Pages;
 
use App\Exports\UsersExport;
use Filament\Resources\Pages\ListRecords;
use Maatwebsite\Excel\Facades\Excel;
// ...
 
class ListUsers extends ListRecords
{
    // ...
 
    public function export()
    {
        $query = $this->getFilteredTableQuery();
        $this->applySortingToTableQuery($query);
 
        $users = $query->get();
 
        $filename = now()->format('Y-m-d_his').'-users.xlsx';
 
        return Excel::download(new UsersExport($users), $filename);
    }
 
    // ...
}