Hi, I using DataTables to sort my table files.i have a column of displaying month description.i need to sort the data according to months description.but dataTables sorting data using the alphabetical order. i created my own function, as shown below. [code] var monthsArray=new Array("Gennaio","febbraio","Marzo","Aprile","Maggio","Giugno","Luglio","Agosto","Settembre","Ottobre","novembre","dicembre");
jQuery.fn.dataTableExt.oSort['Month-asc'] = function(x,y) {
alert( "asc");
var indexOfx = monthsArray.indexOf(x);
var indexOfy = monthsArray.indexOf(y);
alert("indexOfx>>"+indexOfx);
alert("indexOfy>>"+indexOfy);
return ((indexOfx < indexOfy) ? -1 : ((indexOfx > indexOfy) ? 1 : 0));
};
jQuery.fn.dataTableExt.oSort['Month-desc'] = function(x,y) {
alert( "desc");
var indexOfx = monthsArray.indexOf(x);
var indexOfy = monthsArray.indexOf(y);
alert("indexOfx>>"+indexOfx);
alert("indexOfy>>"+indexOfy);
return ((indexOfx < indexOfy) ? 1 : ((indexOfx > indexOfy) ? -1 : 0));
};
$(document).ready(function() {
$('#example').dataTable({
"bPaginate": false,
"bLengthChange": false,
"bFilter": false,
"bSort": true,
"bInfo": false,
"aoColumnDefs": [
{ "sType": 'Month'}
],
"bAutoWidth": false
});
} );
[code]
but it is not working properly , any body have idea please...
Thanking usman