pagination not working

montoyam

It seems that I can't change pages when a user selects a filter in a searchPane. I am using Bootstrap4. Is this a known issue?

I am using a .net MVC project and can not provide a link. There are no errors displayed in the console. I can change pages no problem when no filter is set.

Here is a the layout of one of my tables. However, I am finding this issue on all of my dataTables in this project

    EquipmentOnLoanTable = $('#EquipmentOnLoan').DataTable({
        dom: 'Pfrtip',
        ajax: 'api/EquipmentOnLoan',
        searchPanes: {
            cascadePanes: true,
            viewTotal: true,
            controls: false,
            layout: 'columns-2',
            threshold: 1,
            //columns: [1, 2, 3, 4], //alertDates, alerts, CaseStatus, openActions
            emptyMessage: "<i><b>none</b></i>"
        },
        columns: [
            {
                title: 'Status',
                data: null,
                render: function (data, type, row) {
                    var status='Ready to Bill';
                    if (row.DeptFundOrg == null) { status = 'Missing Fund/Org' };
                    if (row.RateName == null) { status = 'Missing Rate' };
                    return status;
                }
                , searchPanes: { show: true }
                
            },
            {
                title: "Rates",
                className: 'details-control',
                orderable: false,
                defaultContent: '',
                width: '10%'
                , searchPanes: { show: false }
            },
            { data: "LOANID", title: "Loan ID", searchPanes: { show: false } },
            { data: "DEPTNAME", title: "Department (SD+)", searchPanes: { show: true } },
            { data: "LoanStartDate", title: "Loan Start Date", searchPanes: { show: false } },
            { data: "LoanEndDate", title: "Date Returned", searchPanes: { show: false } },
            { data: "RequestedBy", title: "Requested By", searchPanes: { show: false } },
            { data: "RESOURCENAME", title: "Resource Name", searchPanes: { show: false } },
            { data: "COMPONENTNAME", title: "Device", searchPanes: { show: false } },
            { data: "COMPONENTTYPENAME", title: "Type", searchPanes: { show: false } },
            { data: "DeptFundOrg", title: "Dept/Fund/Org", searchPanes: { show: false } },
            { data: "RateName", title: "Rate Name", searchPanes: { show: false } },
            {
                data: "MonthlyRate", title: "Monthly Rate",
                render: $.fn.dataTable.render.number(',', '.', 2, '$')
                , searchPanes: { show: false }
            }
        ],
        select: { style: 'single' },
        lengthChange: false
    });

montoyam

I am using this cdn

<script type="text/javascript" charset="utf-8" src="https://cdn.datatables.net/v/bs4-4.1.1/jqc-1.12.4/moment-2.18.1/jszip-2.5.0/pdfmake-0.1.36/dt-1.10.21/b-1.6.2/b-html5-1.6.2/r-2.2.5/sp-1.3.0/sl-1.3.1/datatables.min.js"></script>

montoyam

I found this post:
https://datatables.net/forums/discussion/68867/paging-in-searchpanes-not-working-when-cascadepanes-true#latest

however, I added this at the end of my script and am still seeing the same issue:

<script src="https://nightly.datatables.net/searchpanes/js/dataTables.searchPanes.js?_=5c6e38dbaaf467e0d790080ff9947c2c"></script>

kthorngren

Did you change your CDN to remove SearchPanes? If not you are loading it twice which is not recommended. Open the CDN link and it will provide a link to the Download Builder with your selected options. Remove SearchPanes and try with the new CDN.

Kevin

montoyam

ah, yes, that was it.

Is that fix going to make it into the CDN?

kthorngren

At some point the nightly code is rolled into a new production version. The developers might be able to tell you when the next release will be posted.

Kevin

colin

We're aiming to release today or tomorrow - this will be a big one with new version of many of the extensions, so please keep an eye on the blog and the release notes.

Colin