page.JumpToData()

Jump to a page by searching for data from a column

It can be quite useful to jump straight to a page which contains a certain piece of data (a user name for example). This plug-in provides exactly that ability, searching for a given data parameter from a given column and immediately shifting the paging of the table to jump to that point.

If multiple data points match the requested data, the paging will be shifted to show the first instance. If there are no matches, the paging will not change.

Note that unlike the core DataTables API methods, this plug-in will automatically call draw() to redraw the table with the current page shown.

Plug-in code

jQuery.fn.dataTable.Api.register( 'page.jumpToData()', function ( data, column ) {
    var pos = this.column(column, {order:'current'}).data().indexOf( data );

    if ( pos >= 0 ) {
        var page = Math.floor( pos / this.page.info().length );
        this.page( page ).draw( false );
    }

    return this;
} );

CDN

This plug-in is available on the DataTables CDN:

JS

Note that if you are using multiple plug-ins, it is beneficial in terms of performance to combine the plug-ins into a single file and host it on your own server, rather than making multiple requests to the DataTables CDN.

Version control

If you have any ideas for how this plug-in can be improved, or spot anything that is in error, it is available on GitHub and pull requests are very welcome!

Example

var table = $('#example').DataTable();
  table.page.jumpToData( "Allan Jardine", 0 );