Search

if not in the order that was specified (this

position and in any order in the table (rather

Enable or disable ordering of columns - it is

to do multiple column ordering using columns.orderData, order or order(), it just

in tandem with the order option which provides an initial ordering state for the table

of the original data order might not be desirable, particularly if you want ordering in DataTables to work

which are used to order the content in the

2.2 will have the order event listener applied to them. If orderCellsTop is true then 1

a single object, but order is not guaranteed. Order

Next", "previous": "Previous" }, "aria": { "orderable": "Order by this column", "orderableReverse":

update itemsList -> set itemOrder=(@sequenceNumber:=@sequenceNumber+1) -> order by itemOrder ASC; into

If I understand correctly the nr field is the order you want to display the table. Then use the order options li described earlier to order the table by this column. Kevin

and changed the table order to order: [[ 6, "asc"

to do the sort: ORDER BY ".$columnName." ".$columnSortOrder." So

docs state this: The order must be an array

With "order": [[2, 'asc']], I can order 1 column but is I use: "order": [[ 0, 'asc' ], [ 1, 'asc' ]] OR order": [[2,3,4,5,6, 'asc']], doesn't work

set a date for ordering then date-uk will order the date So how

Are you looking for the order option? Or maybe the order() API? If this doesn't help then please provide more details of what you are trying to acheive. Kevin

the case move the "order": [[ 1, "desc" ]], into that

Yes, misunderstanding, I think. In the example $('#example').dataTable( { "order": [[ 0, 'asc' ], [ 1, 'asc' ]] } ); would like to be something like $('#example').dataTable( { "order": [[ 'col1:name', 'asc' ], [ 'col2:name', 'asc' ]] } ); instead