Hi ,
I have an input field and a department table. On entering some text in input field , table should show results matching text in departmentName column. Requirement is to implement wild card search on the input text field. e.g. if DepartmentName column has below values and
(1) input text entered was "*ing*" , it should get result as "Marketing" , "Shipping3".
(2) input text entered was "M*ket*g" , it should get result as "Marketing"
IT
Marketing
Shipping3
How can I implement wild card search? How can have view criteria to allow * as wild card character and perform search as specified above?
Thanks