While performing server side search, datatable is not adding '%' at pre and post of word

While performing server side search, datatable is not adding '%' at pre and post of word

vishalvarshneyvishalvarshney Posts: 1Questions: 1Answers: 0
edited November 2016 in Free community support

For example:- if i enter name vis in search box
then actual query runs is like
select name for candidates where name like 'vis'
not
select name for candidates where name like '%vis%'

How to fix this ?

This discussion has been closed.