DataTables column search for exact match

Question

I am using jQuery DataTables plugin in my application. I am trying to search for a string that exactly matches the data in a column.

I checked the this topic and its solution is not working for my case. My search string is a regular expression with | symbols which might look like Logged In|Active|Not Active.

When the search string contains Active(Logged In|Active), records with Not Active are also showing up when I use the following search:

jQuery("#myTable").DataTable()
                .columns("#status")
                .search("^"+status+"$",true,false)
                .draw();

Any help is appreciated. Thanks in advance!

score 9 · Accepted Answer · answered May 16 '17 at 15:00

9

jQuery("#myTable").DataTable()
                .columns("#status")
                .search("(^"+status+"$)",true,false)
                .draw();

This worked!

answered May 16 '17 at 15:00

rav

247
1
6
17

This by far is the simplest answer I've seen. (And it works.) – RandomHandle May 22 '19 at 16:59
You saved my day bro! Worked like a charm. :) – Asad ullah May 28 '21 at 19:57

score 0 · Answer 2 · answered May 16 '17 at 14:18

0

Try below solution:
1. with smart search off (reference)

jQuery("#myTable").DataTable()
                .columns("#status")
                .search(status,false)
                .draw();

2.with double quotes (reference)

jQuery("#myTable").DataTable()
                    .columns("#status")
                    .search('"'+status+'"')
                    .draw();

answered May 16 '17 at 14:18

Bhushan Kawadkar

28,279
5
35
57

Since we have multiple search words, we should be going for a regEx search. So the above solution would not work – rav May 16 '17 at 14:23

score 0 · Answer 3 · answered May 03 '18 at 17:32

0

This worked for me:

 $('#yourTableID').DataTable({ 
  search: {
     regex: false,
     smart: false
  }
 })

You can find more information here: https://datatables.net/reference/option/search

answered May 03 '18 at 17:32

Peter Catalin

1,342
1
14
22

DataTables column search for exact match

3 Answers3

Linked