datatable - 可以在数据表中设置默认搜索窗格值

Question

我正在使用数据表并打开了一个搜索窗格。是否可以将其中一个过滤器设置为默认值，例如 status = 'Active'？

$(document).ready(function() {
$('#controllerList').DataTable
    (
        {
        "paging":   true,
        "ordering": true,
        "info":     true,
        "lengthMenu": [25, 50, 75, 100 ],
        "pageLength":25,
        stateSave: true,
        "responsive": true ,
        language: {
            searchPanes: {
                clearMessage: 'Clear Filter',
                collapse: {0: 'Search Options', _: 'Search Options (%d)'}
            }
        },
        buttons:[
            'searchPanes'
        ],
        dom: 'Bfrtip'
   } );
} );

标签： datatable

Answer 1

我能够弄清楚。

$(document).ready(function() {
    $('#controllerList').DataTable( {
        "paging":   true,
        "ordering": true,
        "info":     true,
        "responsive": true ,
        "deferRender": true,
        "pageLength":25,
        "lengthMenu": [25, 50, 75, 100 ],
        dom: 'Bfrtip',
        columnDefs: [
            {
                searchPanes: {
                    preSelect: ['Active']
                },
                targets:[5]
            }
        ],
        buttons:[
            'searchPanes'
        ],
            language: {
                searchPanes: {
                    clearMessage: 'Clear Filter',
                    preSelect: ['Active'],
                    collapse: {0: 'Search Options', _: 'Search Options (%d)'}
                },
                targets:[3]
            }
    });
});