edit-column.md

Edit Column

You can edit a column on your response by using editColumn api.

Edit Column with Blade Syntax

use DataTables;

Route::get('user-data', function() {
	$model = App\User::query();

	return DataTables::eloquent($model)
				->editColumn('name', 'Hi {{$name}}!')
				->toJson();
});

Edit Column with Closure

use DataTables;

Route::get('user-data', function() {
	$model = App\User::query();

	return DataTables::eloquent($model)
				->editColumn('name', function(User $user) {
					return 'Hi ' . $user->name . '!';
				})
				->toJson();
});

Edit Column with View

{tip} You can use view to render your added column by passing the view path as the second argument on editColumn api.

use DataTables;

Route::get('user-data', function() {
	$model = App\User::query();

	return DataTables::eloquent($model)
				->editColumn('name', 'users.datatables.name')
				->toJson();
	
});

Then create your view on resources/views/users/datatables/name.blade.php.

Hi {{ $name }}!

Edit Column with View and Data

{tip} You can use view to render your added column by passing the view path as the second argument on editColumn api.

use DataTables;

Route::get('user-data', function() {
	$model = App\User::query();

	$externalData = 'External';

	return DataTables::eloquent($model)
				->editColumn('name', ['users.datatables.name', [
					'externalData' => $externalData,
				]])
				->toJson();
	
});

Then create your view on resources/views/users/datatables/name.blade.php.

Hi {{ $name }}!

Here is some external data: {{ $externalData }}.

Edit only the requested Columns

{tip} You can skip editing the columns that are not in your requested payload by using editOnlySelectedColumns before using editColumn

use DataTables;

Route::get('user-data', function() {
	$model = App\User::query();

	return DataTables::eloquent($model)
                ->editColumn('id', function () {
                    return view('users.datatables.id'); // View will always be rendered
                })
                ->editOnlySelectedColumns()
                ->editColumn('name', function () {
                    return 'Hi ' . $user->name . '!'; // View will only be rendered if the column is in the payload
                               only if in the payload
                })
                ->toJson();
});