indivisual colum filter bug

indivisual colum filter bug

vaimeovaimeo Posts: 1Questions: 0Answers: 0
edited August 2013 in General
////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":[]}

Replies

  • allanallan Posts: 63,498Questions: 1Answers: 10,471 Site admin
    I'm not sure I understand what the bug is? Are you passing in the column data index to fnFilter rather than the visible index?

    Allan
This discussion has been closed.