I am working with jquery datatables and i have a column that contains a combination of these values. A date, a string 'A' and another string 'B'. When i click on that column i want the column to be sorted with 'A' appearing first then sorted by date and then 'B' appearing next. Is there a way to achieve this functionality?
Add a comment
|
2 Answers
Client Side :
$.extend($.fn.DataTable.ext.oSort, {
/*
*
*custom_date sorting
*/
"custom_date": function (a) {
return a;
},
"custom_date-asc": function (x, y) {
var x = getCustomEuroDateValue(x);
var y = getCustomEuroDateValue(y);
return ((x < y) ? -1 : ((x > y) ? 1 : 0));
},
"custom_date-desc": function (x, y) {
var x = getCustomEuroDateValue(x);
var y = getCustomEuroDateValue(y);
return ((x < y) ? 1 : ((x > y) ? -1 : 0));
},
});
function getCustomEuroDateValue(strDate) {
// return a string by spiting and merging the date as you need
// B A 02/11/2013 to A20131102B
//
// Example :
// var frDatea = $.trim(strDate);
// var frDatea1 = frDatea.split(' ');
// var frDatea2 = frDatea1[2].split('/');
// var x = (frDatea1[1] + frDatea2[2] + frDatea2[1]+ frDatea2[0] + frDatea1[0]);
// return x;
}
Then add this to your otable properties
"aoColumns": [ { }, { },{ "sType": "custom_date" },{ } ],
Comments
If using client side, detect the DataTables sort listener and then attach your own that calls http://www.datatables.net/ref#fnSort
This is much easier to achieve using server-side with database, as you can always include a static order by clause in your select statement as the secondary sort option
post some more code if additional help is needed
