GridMaskedColumn filtering problem

[Oleksandr]

Hi all,

I have a problem with filtering by GridMaskedColumn.
This is my code:

<telerik:GridMaskedColumn DataField="Customer.PhoneNumbers" DataType="System.String"
                Mask="(###) ###-####" HeaderText="Phone Number" SortExpression="Customer.PhoneNumbers"
                UniqueName="CustomerPhone">
                <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Width="15%" />
                <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" Width="15%" />
            </telerik:GridMaskedColumn>

The problem is:
- If I enter first three numbers in the filter field - it is filtered fine (see the screenshot ok.jpg)
- but if I enter more then three numbers or whole phone number - the filter does not work at all (see the screenshot fail1.jpg and fail2.jpg)

Any suggestions, please.

[Oleksandr]

Please, any idea.
I need to solve it urgent.

Thanks to all.

[Oleksandr]

Please, guys don't be silent.
Tell something, at least.

[Oleksandr]

Please, any suggestions.

[Oleksandr]

Dear support/admins,

How long should it take to hear something?

Maybe I should forgot about the issue?

Thank you.

[Oleksandr]

Hi All,

If I don't understand something, please tell me.

Thanks.

[Oleksandr]

Hi there,

Ok, I can make filtering myself, but can anybody provide me an example like how should I hook a filtering event, or maybe I should override some method.

Thanks to all.

[Oleksandr]

so, is it possible to add my own filtering function?

[Oleksandr]

Hi all,

It seems like I have the issue only.

Anyway, I need to know is it a my mistake or does it have a solution?

Thanks to all.

[Martin]

Hello Oleksandr,

Note that the filtering feature of the GridMaskedColumn uses the 'clear' value (without prompt and literal characters) of its filtering control. Therefore you should ensure that the data field bound to the masked column contains the correct values. The code snippets bellow illustrate this specific and work as expected on my side:

Markup:

<asp:ScriptManager runat="server" ID="ScriptManager1">
</asp:ScriptManager>
<telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="true" OnNeedDataSource="RadGrid1_NeedDataSource">
    <MasterTableView>
        <Columns>
            <telerik:GridMaskedColumn DataField="Col2" DataType="System.String" Mask="(###) ###-####" HeaderText="Phone Number" UniqueName="CustomerPhone">
            </telerik:GridMaskedColumn>
        </Columns>
    </MasterTableView>
</telerik:RadGrid>

Code behind:

protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
    DataTable table = new DataTable();
    table.Columns.Add("Col1", typeof(int));
    table.Columns.Add("Col2");
    for (int i = 0; i < 10; i++)
    {
        table.Rows.Add(i, "123456789" + i);
    }
    RadGrid1.DataSource = table;
}

I hope this helps.

Greetings,
Martin
the Telerik team

[Oleksandr]

Hi Admin,
Thank you for response,


Is there any way to make filtering feature uses not 'clear' value, for example (xxx) aaa-bbbb ?

Thank you.

[Oleksandr]

Hi all,

So it really would be great to have an ability to override (or something like that) filtering behavior.

Thank you.

[Martin]

Hello Oleksandr,

For RadGrid's custom filtering capabilities, I would suggest that you review the following help articles:

Custom option for filtering (FilterListOptions -> VaryByDataTypeAllowCustom)
Custom filter options with handling

I hope this helps.

Regards,
Martin
the Telerik team