Suppose I have a RadGrid, such as the one in your demo, here: http://demos.telerik.com/aspnet-ajax/grid/examples/programming/filteringtemplatecolumns/defaultcs.aspx.
If I type liz in the Contact name filter box, and select Contains from the filter drop down, I get the three people in the list whose names contain the letters "liz". Pretty obvious.
Now, if I type liz and lin in the Contact name filter box, and select Contains from the filter drop down, I get an empty list, because no names in the list contain the string "liz and lin". Also, not too surprising.
But, if I type liz AND lin in the Contact name filter box (note the upper case AND), and select Contains from the filter drop down, the list contains the full set of names again. This also happens if I enter liz OR lin.
It appears that the RadGrid is trying to treat the uppercase strings AND and OR as a boolean operator, failing, and then punting and returning the entire list. Whatever the reason, this is causing us problems. Our users tend to copy and paste stuff into the filter box, and it is often in upper case, and it sometimes has the word AND or OR in the copied string. This causes the application to behave unexpectedly for them, and leads to complaints.
I haven't been able to find any way to turn this behavior off. Do you have any suggestions?
Thanks for any help.
-Ken
If I type liz in the Contact name filter box, and select Contains from the filter drop down, I get the three people in the list whose names contain the letters "liz". Pretty obvious.
Now, if I type liz and lin in the Contact name filter box, and select Contains from the filter drop down, I get an empty list, because no names in the list contain the string "liz and lin". Also, not too surprising.
But, if I type liz AND lin in the Contact name filter box (note the upper case AND), and select Contains from the filter drop down, the list contains the full set of names again. This also happens if I enter liz OR lin.
It appears that the RadGrid is trying to treat the uppercase strings AND and OR as a boolean operator, failing, and then punting and returning the entire list. Whatever the reason, this is causing us problems. Our users tend to copy and paste stuff into the filter box, and it is often in upper case, and it sometimes has the word AND or OR in the copied string. This causes the application to behave unexpectedly for them, and leads to complaints.
I haven't been able to find any way to turn this behavior off. Do you have any suggestions?
Thanks for any help.
-Ken