How to show all rows on table with using Datatable jQuery

Question

I work with datatable library, and i want to show all rows on tapping on the separate button.

I try to use few methods but its not working.

My code:

if (val != '') {
    $('#' + tableId + '').DataTable({
        destroy: true,
        lengthMenu: [[10, 25, 50, -1], [10, 25, 50, "All"]], // this is not working, showing default values
        searchPanes: {
            layout: 'columns-' + length + ''
        },
        columnDefs: [{
            searchPanes: {
                show: true
            },
            targets: '_all'
        }],

        dom: 'Pfrtip'
    });
    $('.dtsp-searchPanes').children().each(function (i, obj) {
        if (!val.includes(i)) $(this).hide();
        else $(this).show();
    });
} else {
    $('#' + tableId + '').DataTable({
        destroy: true
    });
}

$("#showAll").on("click", function () {
   //here i need func
});

I try to use this parameter:

'iDisplayLength': 100

But this is not working for me, plus I need to have this possibility not like parameter but like separate function.

which data table jquery version are you using?

Mohsin Marui
– Mohsin Marui

2020-11-30 09:04:46 +00:00
Commented Nov 30, 2020 at 9:04 — Mohsin Marui
– Mohsin Marui, Commented Nov 30, 2020 at 9:04
@MohsinMarui DataTables-1.10.21

Best Moments
– Best Moments

2020-11-30 09:08:54 +00:00
Commented Nov 30, 2020 at 9:08 — Best Moments
– Best Moments, Commented Nov 30, 2020 at 9:08

andrewJames · Accepted Answer · 2020-11-30 14:39:18Z

1

You can use the page.len() API call to dynamically change the page length.

$("#showAll").on("click", function () {
   $( '#' + tableId + '').dataTable().api().page.len( -1 ).draw();
});

answered Nov 30, 2020 at 14:39

andrewJames

22.6k11 gold badges32 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

How to show all rows on table with using Datatable jQuery

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related