create a page filtered by a variable

[markplus]

I created the tables with the command php artisan datatables:make Tickets, and php artisan datatables:editor Tickets, everything works perfectly now if I create a new table and add

(TicketsDataTable)
public function query(Ticket $model): QueryBuilder
     {
         return $model->newQuery()
         ->whereYear('created_at', '2023')
         ->whereIn('status', [closed','suspended']);
     }

it works properly. I wanted to do in the controller to create specific tables and I tried to do

(TicketsController)
     public function index(TicketsDataTable $dataTable)
     {
         $data = DB::table('tickets')
         ->whereYear('created_at', '2023')
         ->whereMonth('created_at','01')
         ->whereIn('status', ['closed]);
    
         return $dataTable->render('tickets.index',compact('data'));
     }

but nothing is filtered the page loads the table with everything and not just with the values I'm looking for, where am I going wrong?

[yajra]

Do you want to load the tickets per status? Maybe something like:

(TicketsDataTable)
     public function query(Ticket $model): QueryBuilder
     {
         return $model->newQuery()
         ->whereYear('created_at', '2023')
         ->when(request()->filled('status'), fn($q) => $q->whereIn('status', [closed',' suspended']))
     }

[markplus]

Thank you