Unwanted Search

[reza305z]

Hello guys!

Why does laravel datatables does unwanted search when I type something in search box?
I process search in server side:

        $offset = request()->start ?? 0;
        $limit = request()->length ?? 10;
        $query = Order::query()
            ->join('users', 'orders.user_id', '=', 'users.id')
            ->leftJoin('orders as reverse_orders', 'orders.reverse_order_id', '=', 'reverse_orders.id')
            ->select(
                'orders.*',
                'orders.product_id',
                'users.mobile',
                'reverse_orders.tracking_code as reverse_order_tracking_code'
            )
           /* ->when(request()->search['value'], function ($query) {
                $query->where('orders.product_id', (int) request()->search['value']);
            }) */
            ->latest();
        $orderCount = $query->count();
        $orders = $query->offset($offset)
            ->limit($limit)
            ->get();

        return DataTables::collection($orders)->skipPaging()
            ->setTotalRecords($orderCount)
            ->setFilteredRecords($orderCount)
            ->toJson();

I have commented out the searching part but it still searches by tracking_code. That's wired I think!!

[yajra]

By default, the package will search all the columns defined in your javascript. If you want to disable search for a particular column, you can do something like:

columns: [
  {data: 'tracking_code', searchable: false, orderable: true},
  ...
]

If you want more strict control, you can do it on the PHP side via blacklist.

return DataTables::collection($orders)->skipPaging()
            ->blacklist(['tracking_code'])
            ->setTotalRecords($orderCount)
            ->setFilteredRecords($orderCount)
            ->toJson();