Donations Appreciated

The simplest acts of kindness are by far more powerful then a thousand heads bowing in prayer. - Mahatma Gandhi

Click here to lend your support to: Laravel Datatables and make a donation at !

EloquentController.php - Blacklist Columns

Sorting and searching will not work on columns explicitly defined as blacklisted.

->blacklist(['password', 'name'])
Id Name Email Created At Updated At


    public function getBlacklist(Request $request)
        if ($request->ajax()) {
            return Datatables::of(User::query())
                ->blacklist(['password', 'name'])

        return view('datatables.eloquent.blacklist');


        processing: true,
        serverSide: true,
        ajax: '',
        columns: [
            {data: 'id', name: 'id'},
            {data: 'name', name: 'name'},
            {data: 'email', name: 'email'},
            {data: 'created_at', name: 'created_at'},
            {data: 'updated_at', name: 'updated_at'}