Hi all,
I have a problem with filtering by GridMaskedColumn.
This is my code:
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.
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
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.
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.
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.
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.
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.
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
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:
Code behind:
I hope this helps.
Greetings,
Martin
the Telerik team
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.
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
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
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