Datatables Jquery error in console

Question

Uncaught TypeError: Object [object Object] has no method 'fnFilter'

$(document).ready(function () {

var selectedColumn = $('#columnlist').find(":selected").text();

$('#csearchtext').bind("change paste keyup", function () {
    var input = $('#csearchtext').val();

    console.log(input);

    $('#table_id').fnFilter('',4);
});

$('#dblist').on('change', function () {

    var selected = $('#dblist').find(":selected").text();
    tablefill(selected);

});

$('#search').click(function () {

    var selected = $('#dblist').find(":selected").text();
    tablefill(selected);

});

function tablefill(selected) {
    $('.advsearchbar').show();
    $('#stable').show();

    $('#table_id').dataTable({
        "sAjaxSource": '/php/connect/searchtablequery.php',
        "bProcessing": true,
        "sScrollY": "500px",
        "bDeferRender": true,
        "bDestroy": true,
        "sAjaxDataProp": "",
        "fnServerParams": function (aoData) {
            aoData.push({ "name": "db", "value": selected });
        },
        "aoColumns": [
            { "mData": "calldate" },
            { "mData": "recordingfile" },
            { "mData": "uniqueid" },
            { "mData": "src" },
            { "mData": "did" },
            { "mData": "lastapp" },
            { "mData": "dst" },
            { "mData": "disposition" },
            { "mData": "duration" },
            { "mData": "userfield" },
            { "mData": "accountcode"}],
        "iDisplayLength": 20,
        "bJQueryUI": true,
        "sPaginationType": "full_numbers",
        "sDom": '<"H"Tfr>t<"F"ip>',
        "oTableTools": {
            "sSwfPath": "/DataTables/extras/TableTools/media/swf/copy_csv_xls_pdf.swf",
            "aButtons": [
                "copy", "csv", "xls", "pdf",
                {
                    "sExtends": "collection",
                    "sButtonText": "Save",
                    "aButtons": ["csv", "xls", "pdf"]
                }]
        }
    });
}

});

Uncaught TypeError: Object [object Object] has no method 'fnFilter' I am not sure why this is happening the jquery is included because the datatable is being created just fine. Any help on this will be great.

just like the table layout because when it happened to me i did not have enough rows in my aoColumns — Ryan Schlueter
– Ryan Schlueter, Commented Sep 12, 2013 at 21:35

Mamuz · Accepted Answer · 2013-09-12 21:35:36Z

3

You have to chain with dataTable object, like this..

$('#table_id').dataTable().fnFilter('', 4);

answered Sep 12, 2013 at 21:35

Mamuz

1,72012 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user1552172 Over a year ago

That got the error to go away but the table is not filtering anything lol

Mamuz Over a year ago

You try to filter with an empty string!

user1552172 Over a year ago

i derped forgot to change it to a variable, Thank you will mark as answer as soon as possible.

Barbara Laird · Accepted Answer · 2013-09-12 21:36:15Z

2

You need to get the dataTable object, instead of the jQuery object.

$('#table_id').dataTable().fnFilter('',4);

From the docs:

$(document).ready(function() {
  var oTable = $('#example').dataTable();

  // Sometime later - filter...
  oTable.fnFilter( 'test string' );
} );

answered Sep 12, 2013 at 21:36

Barbara Laird

12.7k2 gold badges48 silver badges58 bronze badges

Collectives™ on Stack Overflow

Datatables Jquery error in console

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related