How to use Absolute sorting but also sort rows underneath by differnt column
How to use Absolute sorting but also sort rows underneath by differnt column
Hello, I'm trying to use the Sorting with Absolute Position plugin to keep a value pinned to the top of the page (works fine) but everything underneath those row I'd like to sort by a different column.
For example in this jsfiddle: https://jsfiddle.net/Ernesto1/4mdogv2a/
the rows with London as the office are pinned to the top but all rows underneath I'd like to sort by age (desc).
However, when I sort the age row I lose the sorting in the office row. Any ideas how I could accomplish this would be greatly appreciated.
This works:
$(document).ready(function() {
var dispType = $.fn.dataTable.absoluteOrder({
value:'London', position:'top'
});
var table = $('#example').DataTable({
"columnDefs" : [
{ targets: 2, type: dispType }
],
order: [[2, 'desc']]
});
});
But of course changing the order line like this results in the London rows no longer being pinned to the top.
order: [[3, 'desc']]
thanks
This question has an accepted answers - jump to answer
Answers
You could use
orderFixedalongside the Absolute plugin, and fix a hidden column, something like this. Without the hidden column, the entire Office column would get sorted too (see here) which is probably not what you want,Colin
Great, works like a charm! Thank you!