This is a migrated thread and some comments may be shown as answers.

GridMaskedColumn filtering problem

12 Answers 203 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Oleksandr
Top achievements
Rank 1
Oleksandr asked on 30 Sep 2010, 10:22 AM
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.

12 Answers, 1 is accepted

Sort by
0
Oleksandr
Top achievements
Rank 1
answered on 30 Sep 2010, 11:18 AM
Please, any idea.
I need to solve it urgent.

Thanks to all.
0
Oleksandr
Top achievements
Rank 1
answered on 30 Sep 2010, 01:33 PM
Please, guys don't be silent.
Tell something, at least.
0
Oleksandr
Top achievements
Rank 1
answered on 30 Sep 2010, 03:39 PM
Please, any suggestions.
0
Oleksandr
Top achievements
Rank 1
answered on 01 Oct 2010, 07:54 AM
Dear support/admins,

How long should it take to hear something?

Maybe I should forgot about the issue?

Thank you.
0
Oleksandr
Top achievements
Rank 1
answered on 01 Oct 2010, 12:26 PM
Hi All,

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

Thanks.
0
Oleksandr
Top achievements
Rank 1
answered on 01 Oct 2010, 12:48 PM
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.
0
Oleksandr
Top achievements
Rank 1
answered on 01 Oct 2010, 02:38 PM
so, is it possible to add my own filtering function?
0
Oleksandr
Top achievements
Rank 1
answered on 04 Oct 2010, 11:49 AM

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.

0
Martin
Telerik team
answered on 06 Oct 2010, 09:09 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Oleksandr
Top achievements
Rank 1
answered on 06 Oct 2010, 04:24 PM
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.
0
Oleksandr
Top achievements
Rank 1
answered on 08 Oct 2010, 10:27 AM

Hi all,

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

Thank you.

0
Martin
Telerik team
answered on 11 Oct 2010, 04:00 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
Grid
Asked by
Oleksandr
Top achievements
Rank 1
Answers by
Oleksandr
Top achievements
Rank 1
Martin
Telerik team
Share this question
or