How to display user defined column name in yajra datatables

[Nahiyan47]

i am trying to view datatables where i have user defined columns. It is showing the name of table column automatically.

i have a class IncomesourceDatatable and from that class i am rendering to my view
below i have a function getColumns.

protected function getColumns()
{
return [
'title',
'description',
'special_rule',
'amount',
'created_at',
];
}

as i can see it shows the table column name as the column name in view, how can i put a user defined column name for example title as My Ttile

[gebaiwan]

addColumn?

[Nahiyan47]

can you please elaborate .?

[gebaiwan]

->addColumn('rename_title', function($datum){ return $datum->title }) ->filterColumn('rename_title', function($query, $keyword) { $sql = "select title like ?"; $query->whereRaw($sql, ["%{$keyword}%"]); })

js script: {data:'rename_title', name:'rename_title'}

will this solve your problem?

[shabeebrizvi]

->addColumn('rename_title', function($datum){ return $datum->title }) ->filterColumn('rename_title', function($query, $keyword) { $sql = "select title like ?"; $query->whereRaw($sql, ["%{$keyword}%"]); })

js script: {data:'rename_title', name:'rename_title'}

will this solve your problem?

->title('UserDefined')

[demetreeus]

I assume the attributes here are compatible https://yajrabox.com/docs/laravel-datatables/master/html-builder-column .
So,

return [
 ['name' => 'column_1', 'title' => 'Da Column', 'data' => 'column_1'],
 ['name' => 'column_2', 'title' => 'Another Column', 'data' => 'column_2'],
]

works for me.

[github-actions]

This issue is stale because it has been open for 30 days with no activity. Remove stale label or comment or this will be closed in 7 days.

[github-actions]

This issue was closed because it has been inactive for 7 days since being marked as stale.