Search

SearchPaneOptions->order( string ) - Specify an order by clause that will

using Options with an order statement where a field

list of parameters, the order for which is not

defined in a specific order when using the link()

depending on the field order if used in a

Editor itself. This load order independence is important for

date field. Fix: JS - order() when called, when the

inserted on display, in order. This allows ordering to occur, and also

Fix - PHP: ORDERY BY (order method) had a couple

New: REST example - in order to keep the example

Sounds like you want to order by number first then the letters. I would first try swapping the order within the sort type, something like this: 18AH, 17AH, 16AH, 15AH, 18PE, 17PE... Kevin

table = $('#WellTestTable').DataTable({ "scrollX": true, "order": [[2, 'desc']] }); }); and I

@colin ok - found an old answer Allan gave that helped internalRowNumber = table.rows( { order: 'applied' } )[0][displayedRowNumber] there's probably an api/easier way to do it - I just inspected the rows object to see where the values were

orderable: false then the orderable: false does not work and I can continue to order the data by all

select firstname from user order by lastname This doesn't

Hi Giuseppe, The $db->select() method returns a Result object so there is no order() method available on it. Instead, what you need to do is use the optional fourth parameter which lets you pass in the ordering information. Regards, Allan

Without seeing the code, are you doing a draw() after the order change, with 'false' as the parameter?

Use the order option Kevin mentioned and set it to be an empty array. That will cause the initial display to be in whatever order the server returned it in. Allan

Yes, I already did that but my function have a setInterval that display value for the and the order() does not work properly for the value that displaying by setInterval. Thank you for you respond!

sequence of the alphabetically ordered columns. In SQL it would refer to ORDER BY column1, column2, column3