Default order about datatables HOT 7 CLOSED

I think it is not necessary.
You can add an option parameter to javascript to order any column you want.

https://datatables.net/reference/option/order

example :

$('#example').dataTable( {
    "order": [[ 3, 'asc' ], [ 1, 'asc' ]]
} );

from datatables.

Btw, that default part works only if there is no header info. Datatables is sending the header info to sort first column as default

from datatables.

I know well datatables option, but I want to have initial order completely different. I can not make that kind of order with columns in datatable.

from datatables.

https://gist.github.com/n1crack/7467a9a991369cb44b1e4d6af4933ac2
I made some changes for you in this gist. let me know about the results. You must add "order": [] to your javascript.

Still when the user sorts the table via clicking columns, it will be ignored.

from datatables.

No it is not good. If I have in order by something like "case when c.data_type = 'STRING' then 1 else 0 end, c.column_name", than I got error Unknown column 'c.data_type' in 'order clause''.

My solution:

.....
$query = preg_replace("/((?:[^()]+|(?R))+)/i", "", $query);
preg_match_all("/SELECT([\s\S]?)((\s_)FROM(?![\s\S]_)))([\s\S]*?)/i", $query, $columns);
$this->hasOrderIn = count(preg_grep("/(order\s+by)\s+(.+)$/i", explode("\n", $query)));
$columns = $this->explode(",", $columns[1][0]);
.....

....
if ( ! is_array($dtorders))
{
return $this->hasOrderIn?"":$orders . $this->columns[0] . " asc"; // default
}
....

from datatables.

Nice one. ty. This will be added in the next patch.

from datatables.

Thx

from datatables.