This is a migrated thread and some comments may be shown as answers.

Grid Filter do not work for "%" character

1 Answer 17 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Yogesh Vardhmane
Top achievements
Rank 1
Yogesh Vardhmane asked on 03 Aug 2010, 10:20 AM
Hi,
I am using 2009.3.1314.20. When i filter for  only "%" character with "contains" filter function, filter do not works (It do not throw any error). But when use any other character with "%" like "10 %" it's showing me correct records. I do not want to change version. Anybody solved this issue, Please let me know.

Thanks,
Yogesh

1 Answer, 1 is accepted

Sort by
0
Tsvetoslav
Telerik team
answered on 06 Aug 2010, 07:41 AM
Hello Yogesh,

Try setting EnableLinqExpressions = true for the grid. If the linq expressions are switched off RadGrid uses sql syntax for fitlering its data and the Contains function employees the sql LIKE operator which requires the % sign as a reserved word. This is the cause of the problem you have encountered. Switching on linq expressions for the grid should provide you with the correct functionality.

Hope it helps.

Regards,
Tsvetoslav
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
Grid
Asked by
Yogesh Vardhmane
Top achievements
Rank 1
Answers by
Tsvetoslav
Telerik team
Share this question
or