indivisual colum filter bug
indivisual colum filter bug
////my datatable serverside.php what i do i just retrun these column in json as DataTable Recomended and hiding auto_id colum only see javascript c ode
$aColumns = array('auto_id','from_date', 'to_date', 'currency_name','country_code','country_name','status');
transferMasterTable=$('#transferMasterTable').dataTable( {
"bProcessing": true,
"bServerSide": true,
"bStateSave": true,
"bAutoWidth": true,
"sPaginationType": "full_numbers",
"sDom": '<"top fg-color-blue">r t i <"fr" p><"fr" l> ',
"aaSorting": [[1,'desc']],
"aoColumnDefs": [
{ 'bSortable': false, 'aTargets': [ 6] }
],
"aoColumns": [
{"bVisible": false },
{"bVisible": true},
{"bVisible": true },
{"bVisible": true },
{"bVisible": false },
{"bVisible": true },
{"bVisible": false },
{"bVisible": true }
],
"sAjaxSource": pluginScriptPram3.site_url+"/transfers/dataTable_transfer_masters",
"fnServerData": fnDataTablesPipeline
} );
query making bug if i hide auto_id and serch on from date result is this
WHERE `auto_id` LIKE '%2013%' AND `from_date` LIKE '%2013-%' {"sEcho":16,"iTotalRecords":"24","iTotalDisplayRecords":"0","aaData":[]}
it shoiuld be like this
WHERE ` `from_date` LIKE '%2013-%' {"sEcho":16,"iTotalRecords":"24","iTotalDisplayRecords":"0","aaData":[]}
$aColumns = array('auto_id','from_date', 'to_date', 'currency_name','country_code','country_name','status');
transferMasterTable=$('#transferMasterTable').dataTable( {
"bProcessing": true,
"bServerSide": true,
"bStateSave": true,
"bAutoWidth": true,
"sPaginationType": "full_numbers",
"sDom": '<"top fg-color-blue">r t i <"fr" p><"fr" l> ',
"aaSorting": [[1,'desc']],
"aoColumnDefs": [
{ 'bSortable': false, 'aTargets': [ 6] }
],
"aoColumns": [
{"bVisible": false },
{"bVisible": true},
{"bVisible": true },
{"bVisible": true },
{"bVisible": false },
{"bVisible": true },
{"bVisible": false },
{"bVisible": true }
],
"sAjaxSource": pluginScriptPram3.site_url+"/transfers/dataTable_transfer_masters",
"fnServerData": fnDataTablesPipeline
} );
query making bug if i hide auto_id and serch on from date result is this
WHERE `auto_id` LIKE '%2013%' AND `from_date` LIKE '%2013-%' {"sEcho":16,"iTotalRecords":"24","iTotalDisplayRecords":"0","aaData":[]}
it shoiuld be like this
WHERE ` `from_date` LIKE '%2013-%' {"sEcho":16,"iTotalRecords":"24","iTotalDisplayRecords":"0","aaData":[]}
This discussion has been closed.
Replies
Allan