Search pane content custom order using AJAX data source
Search pane content custom order using AJAX data source
jmuller
Posts: 2Questions: 1Answers: 0
Hi,
I would like to order the table inside a Search Pane based on the values of another column.
Previously, using DOM as data source, I added the data-order attribute to td and it worked.
After I switched to AJAX as data source, I used the createdCell callback to add the same attribute, however sorting did not work as expected.
columnDefs: [
{searchable: true, searchPanes: {show: true, dtOpts: { order: [[ 0, "desc" ]] }}, targets: [0],
'createdCell': function (td, cellData, rowData, row, col) {
$(td).attr('data-order', rowData.date);
}
}
],
Example: https://live.datatables.net/vawoyune/1/edit
Basically I would like to have the names here sorted on reverse order of the second column, i.e. 'Christmas Day' first, then 'Thanksgiving Day' and so on.
Many thanks!
This question has an accepted answers - jump to answer
Answers
By the time
createdCellruns, it is already too late - DataTables has obtained the information needed for sorting and built its data structure for how to read the data for the table.The way to do what you are looking for is a combination of
columns.searchPanes.orthogonalto tell DataTables / SearchPanes a "name" for the data you want and thencolumns.renderas a function to process that and return the correct data type.Here is an updated example showing how it can be done: https://live.datatables.net/vawoyune/4/edit .
Allan
This is great. Thanks a lot for the explanation as well!