I am trying to implement the following custom filter: rather than looking for "Contains", that can return irrelevant results, it would look for "Contains Whole Word Only" through that specific column.
Please advise.
The filter I would like to implement is not same as "Contains" or "EqualTo". It is in a way similar to "Contains" but searches by whole word. This is an example:
Let's say my grid has a column called "Description", storing the company name:
1. General Merchandising Inc
2. Bob Chandler Services Inc.
3. Adler Merchandising Sys. Inc.
4. Bobby Shandler - ABC
5. Tom & Hellen Hand Flowers
If I filter by the word "hand", then "Contains" returns all 5 descriptions above (because 'hand' is also a substring); this is not very helpful from an user point of view.
An "EqualTo" filter returns no results (because there is no company called "hand")
The function I want to inplement, "Contains Whole Word Only" would return one result:
5. Tom & Hellen Hand Flowers
I would also like to suggest to Telerik team to implement this feature in a future version of grid because it makes perfect sense to filter by a whole word. This would eliminate any irrelevant results.