Hello,

Can someone please provide example of how to pass the information from koolreports to datatables to enable correct sorting on a column so it knows the column is date, or number/numeric, instead of default sort by text/alpha?

Thank you

I am using mysql, so I do not sort other than

ORDER BY table.value DESC

at end of the setup query for

->pipe($this->dataStore("result"));

I was expecting datatables would also me to sort by each column and column type, but I guess we must tell datatables what type of data each column is. That is what I am asking how to do.

Got it. For reference to anyone who needs...

Example below declaring the the 3rd column as type date and 8th column as type number.

"columnDefs"=>array(
                array(
                "targets"=>array(2),
                "visible"=>true,
                "type"=>date,
                ),
                array(
                "targets"=>array(7),
                "visible"=>true,
                "type"=>num,
                ),


        ),