jquery dataTable reset sorting

Question

I am trying to do a task, just as same as this question.

• I have a working jquery dataTable
• I want a function to reset the sorting, which is before user select any column, same as read in from the HTML.

It lead me to a nice plugin.

http://datatables.net/plug-ins/api/fnSortNeutral

jQuery.fn.dataTableExt.oApi.fnSortNeutral = function ( oSettings )
{
    /* Remove any current sorting */
    oSettings.aaSorting = [];

    /* Sort display arrays so we get them in numerical order */
    oSettings.aiDisplay.sort( function (x,y) {
        return x-y;
    } );
    oSettings.aiDisplayMaster.sort( function (x,y) {
        return x-y;
    } );

    /* Redraw */
    oSettings.oApi._fnReDraw( oSettings );
};

However I dont know "How to make it work". Anyone know what is "oApi", or do I need some more setup before I use this plugin ?

Because my script shows up Uncaught TypeError: Cannot read property 'oApi' of undefined , right after I copy the script, and the error makes the function undefined. What should I do ?

Answer 1

For DataTable 1.10+ can be used order.neutral() plugin

PLUGIN CODE

$.fn.dataTable.Api.register( 'order.neutral()', function () {
    return this.iterator( 'table', function ( s ) {
        s.aaSorting.length = 0;
        s.aiDisplay.sort( function (a,b) {
            return a-b;
        } );
        s.aiDisplayMaster.sort( function (a,b) {
            return a-b;
        } );
    } );
} );

CDN: cdn.datatables.net/plug-ins/1.10.19/api/order.neutral().js

EXAMPLE

// Return table to the loaded data order
  table.order.neutral().draw();

Answer 2

There's a usage example in the link you provided.

var table = $('#example').dataTable();

// Sort in the order that was originally in the HTML
table.fnSortNeutral();

EDIT Try giving it an "order" property when initializing: JSBin

jQuery.fn.dataTableExt.oApi.fnSortNeutral = function ( oSettings )
{
    /* Remove any current sorting */
    oSettings.aaSorting = [];

    /* Sort display arrays so we get them in numerical order */
    oSettings.aiDisplay.sort( function (x,y) {
        return x-y;
    } );
    oSettings.aiDisplayMaster.sort( function (x,y) {
        return x-y;
    } );

    /* Redraw */
    oSettings.oApi._fnReDraw( oSettings );
};

$(document).ready(function() {
    var oTable = $('#example').dataTable({
        "order" : [[ 1, "desc" ]]
    });

    setTimeout(function() {
        oTable.fnSortNeutral()
    }, 1000)

});