RadGrid Filter showing script error when enter ';' 'Semicolon' in search

[utchi]

Hi,

This is mahali. I am using radgrid for my application.

In that radgrid i have filter options. While i enter some text in filter textbox with semicolon for search, it showing script error 'Index was out of range'.

Please give any suggestion to avoid these kind of error.

Thanks in advance.

Regards
Mahali.

[Princy]

Hi Mahali,

One suggestion would be preventing the entry of : in filter textbox. Have a look at the following code which shows how to accomplish this.

CS:

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", "CheckChar(this, event)");
        }
    }
}

JavaScript:

<script type="text/javascript">
function CheckChar(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>

Thanks,
Princy

[utchi]

Hi Princy,

Thanks for your coding snippet.

But i have text with semicolon in my records. I need to search with semicolons also.

So Could you please tell me some other suggestions to avoid this error and get output.

Thanks in advance.

regards,
mahali

[Pavlina]

Hello Utchi,

I'm afraid that RadGrid do not support filtering using these characters. To be more specific, we consider " LIKE ", " AND ", " OR ", "\"", ">", "<", "<>", " NULL ", " IS " and '';" as unsupported.

I hope this helps.

Regards,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[utchi]

Hi Pavlina

Its ok Pavlina. You dont afraid. I will try to validate my records without that characters.

And thanks for coding snippets and suggestions.

Regards,

mahali

[Mark Breen]

Hello Mahali,

It is nice to see your polite reply.

I am also just normal user of Telerik products, but I was happy to see you reply to Princy,

nice to meet you

Mark

[utchi]

Thanks for your comment... Mark

Keep in touch.

Have a smiley days.

Regards,
Mahali

[Yogesh Vardhmane]

Hi ,
Have you solved this Issue. I am not able search records when i search with "%" i.e. Percentage character.


Thanks & Regards,
Yogesh

[Murugesan Sivathanu]

Hi,

I am also having the same issue when I put semicolon in the filter text box, getting java script error. Is telerik team fixed the issue?

Thanks

[Pavlina]

Hi Murugesan Sivathanu,

The reason for receiving an error is because the semicolon character is internally used to delimit a list of values in a single string. Therefore semicolon should not be allowed in your filter text.

However, you can follow the approach suggested by Shinu on this forum thread.

Regards,
Pavlina
the Telerik team

[Elaine]

I'm also having trouble when I want to search for records that does not contain * in the field. (We have a field that contains "ABC*S" as a value and I want to exclude the records for "ABC*S" and not treat * as a wildcard. Is there a way to escape the * character in the keyup event?

The filter is working fine if I turn "EnableLinqExpressions" to true, but we don't want to turn it to true because we need to pass the filter expression into SQL in another stored proc further down the code without the Linq expressions.

[Pavlina]

Hi Elaine,

Can you please verify that you have tried the solution presented in the forum thread linked in the previous post and it is not working for you?

Greetings,
Pavlina
the Telerik team

[Elaine]

I've tried the code and it's treating the * as a wildcard. I want to use the * as literal, so would need to know how I can escape the * character so that the filter does not use * as a wildcard. See the attached picture. We have data that is "3OB*079" in the data and if I use the "Does not contain" filter, it does not remove those records.

[Pavlina]

Hello,

You can examine the following link and see if it helps to achieve your goal:
http://answers.yahoo.com/question/index?qid=20090501075704AAhMpiQ

Greetings,
Pavlina
the Telerik team