QueryException

[vivekbasvivek]

SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]'CONCAT_WS' is not a recognized built-in function name. (SQL: select top 20 [devs].[customer_id] as [customer_id], [devs].[customer_name] as [customer_name], [devs].[email] as [email], [devs].[phone_number] as [phone_number], [devs].[qatar_id] as [qatar_id], [devs].[nationality] as [nationality], [devs].[code] as [code], CONCAT_WS("|lwdt|" ,COALESCE(devs.customer_id, ''), COALESCE(devs.customer_name, '')) AS callback_2400307084 from [devs] order by customer_id desc) (View: C:\inetpub\wwwroot\uccx\vendor\mediconesystems\livewire-datatables\resources\views\livewire\datatables\datatable.blade.php)

i faced this issue while fetching SQL express record in laravel livewire datatable

[carlinchisart]

Hi all,

I have the same problem, this happen when i change a Column::callback from array two fields like this:

Column::callback(['id', 'name'], function ($id, $name) { return view('users.table-actions', ['id' => $id, 'name' => $name]); })->unsortable()

the sql error is the same:

CONCAT_WS( '|lwdt|', COALESCE(users.id, ''), COALESCE(users.name, '') ) AS "callback_1905151799"

if only one colum in the callback , works, but sometime i need two fields.

Thanks