Laravel Yajra Datatables Hide Null Column

Question

Wha is the best way to hide empty or null comumns from Yajra Datatables:

var table = $('.data-table').DataTable({

      processing: true,

      serverSide: true,

      ajax: "{{ route('any.route') }}",

      columns: [

          // How to Hide any of these columns if its data is empty or null?
          // for exampe I want to hide mname column ?
          // visible: what condition for example !!!!
          {data: 'fname', name: 'fname'},
          {data: 'mname', name: 'mname'},
          {data: 'lname', name: 'lname'},
          ....
      ]

  });

How do I hide th in table whenever any data is empty or null. for instance, using visible:, what condition should I use to test if the data: is empty or null

Dharman · Accepted Answer · 2024-10-24 16:25:00Z

1

I had the same issue but I fixed it. Try this in your controller!

public function example(){
if ($request->ajax()) { // if request ajax
    $data = User::all();  //  take all user table
    return Datatables::of($data)
        ->editColumn('fname', function ($row) {  //this example  for edit your columns if colums is empty 
            $fname = !empty($row->name) ? $row->name : 'empty';
            return $fname;
        })
        ->make(true);
    return view('example', compact('data'));
}}

edited Oct 24, 2024 at 16:25

Dharman♦

34k27 gold badges106 silver badges158 bronze badges

answered Feb 7, 2021 at 0:28

Mobil Terbang89

111 bronze badge

Sign up to request clarification or add additional context in comments.

Comments

Ashwani Garg · Accepted Answer · 2020-12-26 13:11:10Z

0

This is the best way to hide NULL values from the data tables.

  $('#leads').DataTable({
    
      "columnDefs": [{
        "defaultContent": "-",
        "targets": "_all"
    }]

answered Dec 26, 2020 at 13:11

Ashwani Garg

1,5271 gold badge16 silver badges23 bronze badges

Collectives™ on Stack Overflow

Laravel Yajra Datatables Hide Null Column

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related