RadGrid filtering with backslash

[Nikoleta Ferdinandova]

Hi,

I have a RadGrid bound server-side to a DataTable and in a RadAjaxManager and a filter on a GridBoundColumn with string values. 

The filter works fine except when I search for a backslash '\'. When escaped "\\" the filter works.

I looked at you basic filter sample (http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/filtering/defaultcs.aspx) 

and it seems this filter doesn't work there either.

Is there a workaround this? 

Thank you

Nikoleta

[Shinu]

Hi Nikoleta,

One workaround would be preventing the user to type ' \ ' in filter textbox. Try the following code in order to achieve this.

C#:

protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e)
{
    if (e.Item is GridFilteringItem)
    {
        GridFilteringItem fItem = (GridFilteringItem)e.Item;
        foreach (GridColumn col in RadGrid1.MasterTableView.Columns)
        {
            (fItem[col.UniqueName].Controls[0] as TextBox).Attributes.Add("onkeyup", "Backslash(this, event)");
        }
    }
}

JavaScript:

<script type="text/javascript">
function backslash(text,e)
{
  var regx, flg;
    regx = /[/]/
    flg = regx.test(text.value);
    if (flg)
    {
        var val=text.value;
        val=val.substr(0,(val.length)-1)
        text.value=val;
    }
}
</script>

Hope this helps,
Shinu.

[Nikoleta Ferdinandova]

Hi Shinu,

Thank you for your prompt reply.

I wasn't trying to ignore the backslash but to include it in the filter expression. I guess I can use the same approach to escape it. 

Is there any particular reason why the filter itself does not escape backslashes?

Nikoleta

[Princy]

Hello Nikoleta Ferdinandova,

It seems that RadGrid does not support filtering using characters like "\", ">", "<", "<>"," LIKE ", " AND ", " OR ", " NULL ", " IS " and '';" . You can find this mentioned in the following forum link as well:
Semicolon ; in column filter generates error

Thanks
Princy.

[NIRUBAMA]

Hi,

I have a RadGrid with radcomboBox inside it.I have allowfilteringcolumn set to true for the radcombobox.
When i try to filter using contains or any other filter operator, I am not getting the fully concatenated string of the Filterexpression.

Formula for Contains filter is as below:
 dataField LIKE '%value%'

I want to filter the concatenated string with "-" and the datafield.

That is if the Griditem.text is a value containing "BUM-Earth Mounding".
Here the Data field is Earth Mounding alone but it is concatenated with the griditem full text as "BUM-Earth Mounding".It shows no results as it is filtered by datafield formula as above alone.

But i want to get if i just give the "BUM", it should fetch the result.
Can anybody help me out. Also wild character "-" is not allowing to filter.Please tell me how to escape wild characters "-".

[Andrey]

Hello,

In order to achieve your goal you could provide a filter expression for RadGrid manually and thus you will have full control on what value the filtering operations is performed on. More information about this approach could be found in this help topic.

All the best,
Andrey
the Telerik team