如何在jQuery DataTable中搜索确切的字符串? [英] How to search for an exact string in a jQuery DataTable?

问题描述

我怎么只能过滤令人满意的东西.

how can i filter satisfactory only.

ive尝试了此脚本，但无法正常工作

ive tried this script but its not working

<script>
$(document).ready(function() {
    tbl = $('#example').dataTable();
    tbl.fnFilter("^" + filter_value + "$");
});

$(document).ready( function() {
    $('#example').dataTable( {
        "oSearch": {"bSmart": false}
    } );
} )

oTable.fnFilter( "^"+TERM+"$", COLUMN , true); //Term, Column #, RegExp Filter
oSettings.aoPreSearchCols[ iCol ].sSearch = "^\\s*"+'1'+"\\s*$";
oSettings.aoPreSearchCols[ iCol ].bRegex = false;
oSettings.aoPreSearchCols[ iCol ].bSmart= false;
</script>

推荐答案

解决方案

使用下面的 DataTables 1.10 + 代码对表中的所有列执行完全匹配:

Use the code below for DataTables 1.10+ to perform exact match for all columns in the table:

var table = $('#example').DataTable();

$('.dataTables_filter input', table.table().container())
    .off('.DT')
    .on('keyup.DT cut.DT paste.DT input.DT search.DT', function (e) {

        // Uncomment this loop for large datasets for performance
        // to search only on ENTER key
        // if (e.keyCode == 13) {

            var term = $.trim(this.value).toLowerCase();
            if (term !== "") {
                $.fn.dataTable.ext.search.push(
                    function (settings, data, dataIndex) {
                        var isFound = false;
                        $.each(data, function (index, value) {
                            if (value.toLowerCase() === term.toLowerCase()) {
                                isFound = true;
                            }
                            return !isFound;
                        });

                        return isFound;
                    }
                );
            }

            table.draw();

            if (term !== "") {
                $.fn.dataTable.ext.search.pop();
            }

        // Uncomment this loop for large datasets for performance
        // to search only on ENTER key
        // }
});

演示

有关代码和演示，请参见此jsFiddle .

See this jsFiddle for code and demonstration.

这篇关于如何在jQuery DataTable中搜索确切的字符串?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！