Halo agan2, saya mau tanya nih.

gimana ya cara nya agar datatable bisa menampilkan data relasi yang null?


agar error ini tidak muncul dan datatable bisa muncul.
saya udah cari di google gak dpt2.

file controller

public function index()

 {

 if (request()->ajax()) {

 $model = User::with('role','wilayah','wilayah_bagian')->get();



 return datatables()->of($model)

 ->addColumn('role', function(User $user){

 return $user->role->nama_akses;

 })

 ->addColumn('wilayah', function(User $user){

 return $user->wilayah->nama_wilayah;

 })

 ->addColumn('wilayah_bagian', function(User $user){

 return $user->wilayah_bagian->nama_wilayah_bagian;

 })

 ->addColumn('action', function ($data) {

 $link = '<a >id . '" class="btn btn-success">

 <i class="flaticon-eye" title="Detail"></i></a>';

 $link .= '  ';

 $link .= '<a >id . '/edit' . '" class="edit btn btn-primary">

 <i class="flaticon2-edit" title="Edit"></i></a>';

 $link .= '  ';

 $link .= '<button type="button" name="delete" id="' . $data->id . '" class="delete btn btn-danger">

 <i class="flaticon2-trash" title="Delete"></i></button>';

 return $link;

 })->rawColumns(['action'])->addIndexColumn()->make(true);

 }



 $levels = Role::all();

 return view('backend.superadmin.users.index', compact('levels'));

 }

file view

var table = $('#table-users').DataTable({

 processing: true,

 serverSide: true,

 ajax: {

 url: "{{ url('superadmin/users')}}",

 },

 columns: [{

 data: 'DT_RowIndex',

 name: 'DT_RowIndex'

 },

 {

 data: 'nama',

 name: 'nama'

 },

 {

 data: 'role',

 name: 'role'

 },

 {

 data: [],

 name: [],

 },

 {

 data: [],

 name: [],

 },

 {

 data: 'status',

 name: 'status'

 },

 {

 data: 'action',

 name: 'action',

 orderable: false

 }

 ]

 });

Schema::table('users', function (Blueprint $table) {

$table->bigIncrements('id');

 $table->string('nama');

 $table->string('email')->unique();

 $table->timestamp('email_verified_at')->nullable();

 $table->string('password');

 $table->date('tgl_lahir');

 $table->string('tmpt_lahir');

 $table->text('alamat');

 $table->enum('status', ['aktif','tidak aktif'])->default('tidak aktif');

 $table->smallInteger('level');

 $table->rememberToken();

 $table->timestamps();

 $table->integer('wilayah_id')->nullable();

 $table->integer('wilayah_bagian_id')->nullable();

 });

migration table wilayah bagian

Schema::create('wilayah_bagian', function (Blueprint $table) {

 $table->bigIncrements('id');

 $table->integer('wilayah_id');

 $table->string('nama_wilayah_bagian');

 $table->timestamps();

 });

migration table wilayah

 Schema::create('wilayah', function (Blueprint $table) {

 $table->bigIncrements('id');

 $table->string('nama_wilayah');

 $table->timestamps();

 });