Good day KoolReport, I've been trying to utilize server processing in the datagrid package and i have received this error:
Uncaught Error: DataTables warning: table id=datatables5dc2786d40f937 - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1
Here is my code: <?php
DataTables::create(array(
'dataSource' => function() {
return $this->src('employees')
->query("SELECT date_format(cl.created_at,'%d %b %Y') as 'Date' ,cl.id,
a.name as 'Module',u.name, p.name as 'Campaign' , concat(u.name,' ',u.surname)as 'User',
record_processed, success_process as 'Successfully Processed',
not_success_process as 'Unsuccessfully Processed'
FROM campaign_manager_logs cl
join application_modules as a on a.id = cl.application_module_id
join preview_campaigns as p on p.id = cl.campaign_id
join users as u on u.id = cl.user_id
where application_module_id = 12");
},
"options" => array(
"searching" => true,
"paging" => true,
"colReorder" => true,
"order" => [],
"ordering" => false,
"pageLength" => 25,
),
"showFooter"=>true,
"serverSide"=>true,
// "method" => "post",
));
?>