blocks|key|698196|text|Ok解决了这个问题。但是，由于我使用精确匹配的列有时包含用逗号分隔的多个ID+#，因此我不能使用精确匹配搜索。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|698197|但对那些感兴趣的人来说，答案是：|698198|oTable.fnFilter(+"%5E"%2BTERM%2B"$",+COLUMN+,+true);+//Term,+Column+#,+RegExp+Filter|code-block|syntax|javascript|698199|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Ok solved the problem. However, since the column I am using the exact match on sometimes contains multiple ID #s seperated by commas, I wont be able to use an exact match search.

But for those interested, here is the answer:

<pre><code>oTable.fnFilter( "^"+TERM+"$", COLUMN , true); //Term, Column #, RegExp Filter
</code></pre>

blocks|key|482362|text|这将为您提供列的确切结果。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|482363|+table.column(i)
+.search("%5E"+%2B+$(this).val()+%2B+"$",+true,+false,+true)
+.draw();|code-block|syntax|javascript|482364|即。搜索(输入、正则表达式、smart、caseInsen+)|482365|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

This will give you exact result for a column.

<pre><code> table.column(i)
 .search("^" + $(this).val() + "$", true, false, true)
 .draw();
</code></pre>

ie . search( input , regex, smart , caseInsen )

blocks|key|482453|text|如果你想从一开始就完全匹配，你可以试试这段代码，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|482454|++++var+table+=+$('#myTable').DataTable()
++++$('#filterrow+>+th:nth-child(2)+>+input').on(+'keyup+change',+function+()+{
++++++++table
++++++++.column(+$(this).parent().index()%2B':visible'+)
++++++++.search(+"%5E"+%2B+this.value,+true,+false,+true+)
++++++++.draw();
++++}+);|code-block|syntax|javascript|482455|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If you want the exact match from the beginning you can try this code,

<pre><code> var table = $('#myTable').DataTable()
 $('#filterrow &gt; th:nth-child(2) &gt; input').on( 'keyup change', function () {
 table
 .column( $(this).parent().index()+':visible' )
 .search( "^" + this.value, true, false, true )
 .draw();
 } );
</code></pre>

blocks|key|698454|text|只需将正则表达式和smart设置为false即可。你就会得到确切的结果。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|698455|+$('#yourTableID').DataTable({+
++search:+{
+++++regex:+false,
+++++smart:+false
++}
+})|code-block|syntax|javascript|698456|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

just set the regex and smart false. and you get the exact result.

<pre><code> $('#yourTableID').DataTable({ 
 search: {
 regex: false,
 smart: false
 }
 })
</code></pre>

blocks|key|482256|text|$(document).ready(function()+{
++++tbl+=+$('#example').dataTable();
++++tbl.fnFilter("%5E"+%2B+filter_value+%2B+"$");
});|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|482257|其中filter_value是在筛选器字段中输入的字符串。|unstyled|offset|length|style|CODE|482258|entityMap^0|0|2|C|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|N|8|@$G|O|H|P|I|J]]|9|@]|A|$]]|$1|K|3|-4|5|F|7|Q|8|@]|9|@]|A|$]]]|L|$]]

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

Where <code>filter_value</code> is the string entered in the filter field.

blocks|key|482627|text|正则表达式对我来说不是一个方便的解决方案，因为它在代码中需要很多异常。因此，我的解决方案是在jquery.datatable.min.js中添加一个新选项'exactvalue‘，其默认值为false+(以避免兼容性问题)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|482628|++++[...]
p.columns.push({data:n,name:u.sName,searchable:u.bSearchable,exactvalue:u.bExactvalue,orderable:u.bSortable,
++++[...]
d.bFilter&&(m("sSearch_"%2Bl,sa.sSearch),m("bRegex_"%2Bl,sa.bRegex),m("bSearchable_"%2Bl,u.bSearchable),m("bExactvalue_"%2Bl,u.bExactvalue));
++++[...]
q.models.oColumn={idx:null,aDataSort:null,asSorting:null,bSearchable:null,bExactvalue:null,bSortable:null,bVisible:null
++++[...]
q.defaults.column={aDataSort:null,iDataSort:-1,asSorting:["asc","desc"],bSearchable:!0,bExactvalue:false,bSortable:!0,
++++[...]|code-block|syntax|javascript|482629|这个新选项将与帖子中的其他数据一起发送：|482630|+++[...]
+++columns[5][searchable]:+true
+++columns[5][exactvalue]:+true
+++columns[5][orderable]:+true
+++[...]|482631|之后，更改php+ssp类以接受新值。修改ssp中的过滤功能更改：|482632|++++++++++++if+(+$requestColumn['searchable']+==+'true'+)+{
++++++++++++++++if+(+$requestColumn['exactvalue']+==+'true'+)+{
++++++++++++++++++++$binding+=+self::bind(+$bindings,+$str,+PDO::PARAM_STR+);
+++++++++++++++++++++$columnSearch[]+=+($isJoin)+?+$column['db']."+=+".$binding+:+"`".$column['db']."`+=+".$binding;
++++++++++++++++}else{
++++++++++++++++++++$binding+=+self::bind(+$bindings,+'%25'.$str.'%25',+PDO::PARAM_STR+);
+++++++++++++++++++++$globalSearch[]+=+($isJoin)+?+$column['db']."+LIKE+".$binding+:+"`".$column['db']."`+LIKE+".$binding;
++++++++++++++++}
++++++++++++}|482633|，然后重复单个列过滤。|482634|++++++++if+(+$requestColumn['searchable']+==+'true'+&&+$str+!=+''+)+{
++++++++++++if+(+$requestColumn['exactvalue']+==+'true'+)+{
++++++++++++++++$binding+=+self::bind(+$bindings,+$str,+PDO::PARAM_STR+);
+++++++++++++++++$columnSearch[]+=+($isJoin)+?+$column['db']."+=+".$binding+:+"`".$column['db']."`+=+".$binding;
++++++++++++}else{
++++++++++++++++$binding+=+self::bind(+$bindings,+'%25'.$str.'%25',+PDO::PARAM_STR+);
+++++++++++++++++$columnSearch[]+=+($isJoin)+?+$column['db']."+LIKE+".$binding+:+"`".$column['db']."`+LIKE+".$binding;
++++++++++++}
++++++++}|482635|现在，在表columnDefs定义中，只需添加|482636|{'targets':+5,+'exactvalue':+true}|482637|您的列将被过滤成精确值。|482638|entityMap^0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|12|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|14|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|16|8|@]|9|@]|A|$]]|$1|Q|3|R|5|D|7|17|8|@]|9|@]|A|$E|F]]|$1|S|3|T|5|6|7|18|8|@]|9|@]|A|$]]|$1|U|3|V|5|D|7|19|8|@]|9|@]|A|$E|F]]|$1|W|3|X|5|6|7|1A|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]]|Z|$]]

Regex was not a handy solution for me as it require lot of exceptions in the code.
So, my solution was to add in the jquery.datatable.min.js a new option 'exactvalue' with default value false (to avoid compatibility problems)
<pre><code> [...]
p.columns.push({data:n,name:u.sName,searchable:u.bSearchable,exactvalue:u.bExactvalue,orderable:u.bSortable,
 [...]
d.bFilter&amp;&amp;(m(&quot;sSearch_&quot;+l,sa.sSearch),m(&quot;bRegex_&quot;+l,sa.bRegex),m(&quot;bSearchable_&quot;+l,u.bSearchable),m(&quot;bExactvalue_&quot;+l,u.bExactvalue));
 [...]
q.models.oColumn={idx:null,aDataSort:null,asSorting:null,bSearchable:null,bExactvalue:null,bSortable:null,bVisible:null
 [...]
q.defaults.column={aDataSort:null,iDataSort:-1,asSorting:[&quot;asc&quot;,&quot;desc&quot;],bSearchable:!0,bExactvalue:false,bSortable:!0,
 [...]
</code></pre>
This new option will be sent along the other data in the post:
<pre><code> [...]
 columns[5][searchable]: true
 columns[5][exactvalue]: true
 columns[5][orderable]: true
 [...]
</code></pre>
After that, change the php ssp class to accept the new value. Modify filter function in the ssp changing:
<pre><code> if ( $requestColumn['searchable'] == 'true' ) {
 if ( $requestColumn['exactvalue'] == 'true' ) {
 $binding = self::bind( $bindings, $str, PDO::PARAM_STR );
 $columnSearch[] = ($isJoin) ? $column['db'].&quot; = &quot;.$binding : &quot;`&quot;.$column['db'].&quot;` = &quot;.$binding;
 }else{
 $binding = self::bind( $bindings, '%'.$str.'%', PDO::PARAM_STR );
 $globalSearch[] = ($isJoin) ? $column['db'].&quot; LIKE &quot;.$binding : &quot;`&quot;.$column['db'].&quot;` LIKE &quot;.$binding;
 }
 }
</code></pre>
and repeat on the individual column filtering
<pre><code> if ( $requestColumn['searchable'] == 'true' &amp;&amp; $str != '' ) {
 if ( $requestColumn['exactvalue'] == 'true' ) {
 $binding = self::bind( $bindings, $str, PDO::PARAM_STR );
 $columnSearch[] = ($isJoin) ? $column['db'].&quot; = &quot;.$binding : &quot;`&quot;.$column['db'].&quot;` = &quot;.$binding;
 }else{
 $binding = self::bind( $bindings, '%'.$str.'%', PDO::PARAM_STR );
 $columnSearch[] = ($isJoin) ? $column['db'].&quot; LIKE &quot;.$binding : &quot;`&quot;.$column['db'].&quot;` LIKE &quot;.$binding;
 }
 }
</code></pre>
Now, in your table columnDefs definition, simply add
<pre><code>{'targets': 5, 'exactvalue': true}
</code></pre>
and your column will be filtered with exact value.

blocks|key|482490|text|Datatables的当前版本支持在列的基础上使用真正的精确匹配。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|482491|table.column(i)
.search($(this).val(),+false,+false,+false)
.draw();|code-block|syntax|javascript|482492|documentation+解释了每个标志。|offset|length|482493|entityMap|0|LINK|mutability|MUTABLE|url|https://datatables.net/reference/api/column().search()^0|0|0|0|E|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

The current versions of Datatables supports using real exact matching on a column basis.

<pre><code>table.column(i)
.search($(this).val(), false, false, false)
.draw();
</code></pre>

The <a href="https://datatables.net/reference/api/column().search()" rel="nofollow noreferrer" title="column&#40;&#41;.search&#40;&#41;">documentation </a> explains each flag.

blocks|key|482435|text|table.column(col_num).search(filter_value+%2B+"$"，true，true，false).draw()；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|482436|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

table.column(col_num).search(filter_value + "$", true, true, false).draw();

Trying to only display exact matches to the search term entered in the search bar. 

For instance, I have a search bar that filters by ID#. I want only records that match the exact # entered to display.

So if <code>123</code> is entered, I don't want <code>12345</code>, <code>91239</code>, etc etc to be displayed. Only <code>123</code>.

Saw some info about <code>bRegex</code> on the FAQ page, but it's not working for me. Any ideas?

jQuery DataTables - Filter column by exact match

尝试仅显示与搜索栏中输入的搜索词完全匹配的内容。例如，我有一个按ID#过滤的搜索栏。我只希望显示与输入的#完全匹配的记录。因此，如果输入了123，我不希望显示12345、91239等。只有123。在常见问题页面上看到了一些关于bRegex的信息，但它对我不起作用。有什么想法吗？

问jQuery DataTables -按精确匹配筛选列
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问jQuery DataTables -按精确匹配筛选列EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问jQuery DataTables -按精确匹配筛选列
EN