how to search and match exact keyword of only the certain column?

luvji

i am new to datatable and overall programming.(so sorry if my question didnt meet forum rules). in our work database there is a column named "status" , which may be one of these values : 'ACTIVE' , 'INACTIVE', 'IDLE', 'NULL'. (note: there is this criteria , where values other than 'ACTIVE' , is shown as "NOT DEPLOYED") every other search is fine , but in this particular column -"status" when we try to search for ACTIVE it also shows the rows which contain "INACTIVE because it contains the word ACTIVE within it. how to overcome this issue? also , when searching for "NOT DEPLOYED" ( which was changed on the frontend as said earlier) it wont show any relevent results that includes "NOT DEPLOYED".

colin

You would need to use regex search with search(), then do "^" + string + "$". If you're using the standard seach input element, you would need to reuse that element or create your own - Kevin's example from this thread shows how to reuse it.

Colin