Cannot destroy() using "Yet Another DataTables Column Filter" plugin

Question

I'm using DataTables and YADCF to filter a table.

At some point, I need to temporarily unbind both plugins from my table and later bind them again. If I don't use YADCF, I can destroy the datatable and initialise it again. However, when I use YADCF, the filter part of the table isn't destroyed.

HTML:

<a href="#" id="create">Create</a> | <a href="#" id="destroy"> Destroy</a>

<table id="mytable" class="results table table-striped">
    <thead>
        <tr>
            <th>Head 1</th>
            <th>Head 2</th>
            <th>Head 3</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td>12</td>
            <td>13</td>
            <td>14</td>
        </tr>
        <tr>
            <td>12</td>
            <td>13</td>
            <td>14</td>
        </tr>
        <tr>
            <td>152</td>
            <td>13</td>
            <td>154</td>
        </tr>
        <tr>
            <td>1762</td>
            <td>1873</td>
            <td>1874</td>
        </tr>
        <tr>
            <td>124</td>
            <td>1343</td>
            <td>1124</td>
        </tr>
    </tbody>
</table>

JS without YADCF JSFIDDLE:

var oTable = $('table');

$('#create').click(function (e) {
    e.preventDefault();
    oTable.dataTable({
        "bJQueryUI": true,
            "bStateSave": true,
            "bPaginate": false,
            "bAutoWidth": false,
    });

});

$('#destroy').click(function (e) {
    e.preventDefault();
    oTable.fnDestroy();
    oTable.attr('class', '');
});

JS with YADCF JSFIDDLE:

var oTable = $('table');

$('#create').click(function (e) {
    e.preventDefault();
    oTable.dataTable({
        "bJQueryUI": true,
            "bStateSave": true,
            "bPaginate": false,
            "bAutoWidth": false,
    });


    // Add YADCF
    oTable.yadcf([{
      column_number: 1,
      filter_type: 'range_number',
      ignore_char: 'm'
    }, {
      column_number: 2,
      filter_type: 'text',
      filter_default_label: ' '
    },
    ]);


});

$('#destroy').click(function (e) {
    e.preventDefault();
    oTable.fnDestroy();
    oTable.attr('class', '');
});

Can anyone suggest how to destroy the YADCF filter too?

score 1 · Accepted Answer · answered Apr 21 '15 at 05:20

So, this is actually a bug present.

Issue Submitted | Workaround JSFiddle

JS:

var oTable = $('table');
var first = true;

$('#create').click(function (e) {

    e.preventDefault();
    oTable.dataTable({
        "bJQueryUI": true,
            "bStateSave": true,
            "bPaginate": false,
            "bAutoWidth": false
    });

    if (first) {
        first = false;
        // Add YADCF
        oTable.yadcf([{
            column_number: 1,
            filter_type: 'range_number',
            ignore_char: 'm'
        }, {
            column_number: 2,
            filter_type: 'text',
            filter_default_label: ' '
        } ]);
    } else {
        oTable.find('thead').find('[id^=yadcf-filter-wrapper-table]').each(function (i, v) {
            var cloned = $(this).clone(true);
            console.log( $(this) );
            $(this).closest('th').append( cloned );
            $(this).remove();
            oTable.find('.DataTables_sort_wrapper').css('display', 'inline-block');
        });
        oTable.find('[id^=yadcf]').show();
    }

});

$('#destroy').click(function (e) {
    e.preventDefault();
    oTable.fnDestroy();
    oTable.attr('class', '');
    oTable.off();
    oTable.find('[id^=yadcf]').hide();
    oTable = $('table');
});

$('#add-row').click(function (e) {
    e.preventDefault();
    $('table').append('<tr><td>' + getRandom() + '</td><td>' + getRandom() + '</td><td>' + getRandom() + '</td></tr>');
});

function getRandom() {
    return parseInt(10000 * Math.random(), 10);
}

score 0 · Answer 2 · answered Nov 04 '14 at 13:43

0

try the below:

$('#destroy').click(function (e) {
    e.preventDefault();
    oTable.Destroy();
    oTable.attr('class', '');
});

answered Nov 04 '14 at 13:43

Webezine

345
7
22

Won't work. `Destroy()` is used when you use `DataTable` - note the capital `D`. – RRikesh Nov 04 '14 at 13:49
Was worth a try - thought you were using an odl refrence (fn) for the new datatables. – Webezine Nov 04 '14 at 14:30
There are `JSFiddle`s available for you to play with. – RRikesh Nov 05 '14 at 04:49

Cannot destroy() using "Yet Another DataTables Column Filter" plugin

2 Answers2