multi-pal data show in on row but filter not working

mani123

hi
i want display multiple data in on row when we search according data its not working

GROUP_CONCAT(CONCAT(" . $this->db->dbprefix('purchase_items') . ".product_name, " . $this->db->dbprefix('purchase_items') . ".quantity, ']') SEPARATOR '\n') as iname

this is my datatable sql query

mani123

$this->load->library('datatables');
$this->datatables
->select($this->db->dbprefix('purchases') . ".date, reference_no, " . $this->db->dbprefix('warehouses') . ".name as wname,".$this->db->dbprefix('purchases') . ".supplier as spplly,GROUP_CONCAT(CONCAT(" . $this->db->dbprefix('purchase_items') . ".product_name, " . $this->db->dbprefix('purchase_items') . ".quantity, ']') SEPARATOR '\n') as iname, purchase_note, eda," . $this->db->dbprefix('purchases') . ".ship_type as sship, total, paid, (total-paid) as blns," . $this->db->dbprefix('purchases') . ".status," .$this->db->dbprefix('purchases') . ".id as eeid", FALSE)
->from('purchases')
->join('purchase_items', 'purchase_items.purchase_id=purchases.id', 'left')
->join('warehouses', 'warehouses.id=purchases.warehouse_id', 'left')
->group_by('purchases.id');

allan

From those statements it looks like you are using client-side processing. Is that correct? If so, the data source shouldn't actually make any difference.

Could you link to a test page showing the issue, as noted in the forum rules, so we can offer some help please?

Allan

mani123

mani123

like this is my data display but when need to search only show processing bar and when i check in console there show error
like this ---->
Uncaught TypeError: Cannot read property 'sEcho' of null
at Fa (jquery.dataTables.min.js:48)
at Object.success (jquery.dataTables.min.js:46)
at l (jquery-2.0.3.min.js:4)
at Object.fireWith [as resolveWith] (jquery-2.0.3.min.js:4)
at k (jquery-2.0.3.min.js:6)
at XMLHttpRequest.<anonymous> (jquery-2.0.3.min.js:6)![]
this is screen shot of error --->
(https://datatables.net/forums/uploads/editor/dq/zpvd5xjcyg6h.png "")

allan

That makes it sounds like the data being returned by the server is null. Perhaps you can check with your browser's network inspector to see what the server is returning?

Allan