2011.Q1 quotes and filters

[simone bartoccioni]

Hello

After upgrading to the last release I have a problem with quotes (') and filters.

Example:
I Click on a filter button of a column, and I choose the item :  L'Abbondanza
Then I apply the filter, but the result row is not shown

The grid applyes this wrong filter clause :   RAGSOC = 'L''''Abbondanza' and not  RAGSOC = 'L''Abbondanza'

No problem with previous version....

Thanks in advance
Simone

[Emanuel Varga]

Hello Simone,

I can confirm this issue and i would suggest you open a support ticket on this problem.

Until then i can provide a workaround for this issue:

void radGridView1_FilterChanging(object sender, GridViewCollectionChangingEventArgs e)
{
    if (e.NewItems.Count > 0)
    {
        var compositeFilterDescriptor = e.NewItems[0] as CompositeFilterDescriptor;
        if (compositeFilterDescriptor != null && compositeFilterDescriptor.FilterDescriptors.Count > 0)
        {
            foreach (var filterDescriptor in compositeFilterDescriptor.FilterDescriptors)
            {
                if (filterDescriptor.Value != null)
                {
                    filterDescriptor.Value = filterDescriptor.Value.ToString().Replace("''", "'");
                }

            }
        }
    }
}

This should fix your problem for now.

Hope this helps, if you have any other questions or comments, please let me know,

Best Regards,
Emanuel Varga
Telerik WinForms MVP

[simone bartoccioni]

Thanks Emanuel 

Simone