Filter grid with quotes, AND, OR or other special symbols

RELATED TO:

AUTHOR: Tsvetomir Milchev

DATE POSTED: August 06, 2018

DESCRIPTION 

RadGrid control considers quotes, "AND", "OR" and other similar meaningful statements in query context as illegal when filtering. These are the default values of this collection:

" LIKE , AND , OR ,\",>,<,<>, NULL , IS "

 

SOLUTION

You can remove the "AND" and "OR" statements from the forbidden filter string collection. This could be achieved in the Page_Load() event handler as following:

protected void Page_Load(object sender, EventArgs e)
{
    GridFilterFunction.IllegalStrings = new string[] { " LIKE ", ">", "<", "<>", " NULL ", " IS " };
    RadGrid1.EnableLinqExpressions = false;
}
Important

Telerik does not bear responsibility when you change this collection.

If you are using CheckList or HeaderContext (Excel-like) filtering mode, you can additionally set the following property:
<telerik:RadGrid ... >
    <FilterMenu EnableTextHTMLEncoding="false"></FilterMenu>

More Resources

  • Forums

    Find answers to thousands of questions or reach out to our active community.

  • Demos

    Browse 1,200+ demos with source code covering basic and advanced scenarios.

  • Sample Applications

    Learn how to integrate the controls in real-world examples.

  • Feedback Portal

    Vote and follow the features you want to see added to Telerik UI for ASP.NET AJAX.

  • User Voice

    Get answers directly from the people who build the product.

  • Documentation

    Benefit from detailed help articles and API references for all controls.

  • Knowledge Base

    Learn how to achieve common scenarios from a multitude of tutorials and working examples.

  • Code Library

    Browse sample projects submitted by Telerik staff and community members.

  • Blog

    Stay up-to-date with the latest functionality, how-to articles and industry trends.

  • Release History

    Up-to-date release notes for all new features and improvements.