Webdatatables default sort (asc/desc) not working Ask Question Asked 4 years, 11 months ago Modified 4 years, 11 months ago Viewed 6k times 0 i tried to fetch data to a mysql table using this $query=$conn->query ("SELECT * FROM users ORDER BY id_user ASC"); this is my table structure users WebI'm working with DataTable (1.10.19) on my project and this table have 3 columns: ID / FIRST_NAME / LAST_NAME. What happens is when i try to sort first_name column, DataTables sort by id and not by A-Z/Z-A. Below are the codes that fetch and display table on page using Ajax: Plain text
Change orderData order for multi columns. — DataTables forums
WebFeb 12, 2014 · Should be Concat instead of Concate but other then that it works here. – dkozl. Feb 12, 2014 at 11:42. Show 6 more comments. 2. OrderByDescending does not "sort in place". It rather returns an IOrderedEnumerable that you must assign to a variable. var orderedLeaves = leaves.OrderByDescending (e => e.StartDate); Share. WebMulti sort is working. As an example sort the Position column. Watch the Developer rows then shift click Office. You will see the order change by the Office. orderMulti is on by … bernard zins ベルナール ザンス
Server side sorted data not showing in same order …
Webtest by turning StateSave off. If the problem you are asking about is with the initial Datatable load then stateSave is likely picking up changes in the column ordering by the user. Is this what you are asking about? Or is it that ordering the 4th column isn't working as expected. WebApr 6, 2024 · 1 Answer. You can overwrite the default sorting from dataTable in order to achieve the desired result: var table = $ ('#empTable').DataTable ( { processing: true, serverSide: true, serverMethod: 'post', order: [], ajax: " { { url ('my url') }}", columns: [ {data: 'reference_no', name: 'reference_no'} ] }); By default dataTable will sort the ... WebSep 16, 2015 · //G_DataTable is the datatable instance. // 'column-reorder' event should be binded manually to datatable to listen to those changes. G_DataTable.on ('column-reorder',function (e, settings, defaults) { G_DataTable.state.save (); // to save the current state explicitly }); Share Improve this answer Follow answered Mar 27, 2024 at 20:16 … 原爆とは