Hi,
I've just noticed that if I enable the search [filter] on a data table, and filter the result set, the total or Col6 doesn't update. Is it possible to do recalculate on filter?
DataTables::create(array(
"dataStore"=>$this->dataStore('dataset')
,"columns"=>array(
"Col1"=>array(
"cssStyle"=>"text-align:left;font-weight: bold;color:red;"
)
,"Col2"=>array(
"cssStyle"=>"text-align:left;font-weight: bold;color:red;"
)
,"Col3"=>array(
"cssStyle"=>"text-align:center"
)
,"Col4"=>array(
"cssStyle"=>"text-align:center"
)
,"Col5"=>array(
"cssStyle"=>"text-align:center"
)
,"Col6"=>array(
"footer"=>"sum",
"footerText"=>"<span style='font-size: smaller;font-weight: bold;color:red;'>@value</span>",
"cssStyle"=>"text-align:center"
)
)
,"cssClass"=>array(
"table"=>"table table-hover table-bordered",
"th"=>"cssHeader",
"tr"=>"cssItem"
)
,"showFooter"=>"bottom"
,"options"=>array(
"paging"=>true,
"lengthMenu"=> [ [5, 10, 25, 50, -1], [5, 10, 25, 50, "All"] ],
"pageLength"=>5,
"searching"=>true,
"colReorder"=>true,
"fixedHeader"=>true,
"select"=>true,
"info"=>false,
"ordering" => true,
"order"=>array(
array(5,"desc"), //Sort by fifth column desc
array(0,"asc"), //Sort by first column asc
array(1,"asc"), //Sort by second column asc
array(2,"asc") //Sort by third column asc
),
"search"=> array(
"search"=>"18-24 Female",
"caseInsensitive"=>false
),
)
));