There appears to be a bug with the AutoFilter logic when EnableLinqExpressions is set to true.
Lets say I have a string column called "PartnerName", defined as follows:
Lets say the user wants to locate a partner whose name starts with "Briar's". They enter this text in the filter column, and hit enter.
On the back end, the filter expression is defined within the grid.MasterTableView.FilterExpression is set to:
(iif(PartnerName == null, "", PartnerName).ToString().ToUpper().Contains("briar''s".ToUpper()))
Notice that the grid has replaced the single quote in Briar's with two single quotes. While this logic makes sense if we're sending the filter expression back to a database directly, it does not make sense when used as part of a Dynamic Linq statement, and in fact results in the query not returning any values..
There doesn't seem to be any way to work around this bug at the moment, short of some invasive string manipulation. Is there a way to force the grid to not replace the single quote with two single quotes?
Roy
Lets say I have a string column called "PartnerName", defined as follows:
<
telerik:GridBoundColumn DataField="PartnerName" DataType="System.String" HeaderText="Name"
SortExpression="PartnerName" UniqueName="PartnerName" CurrentFilterFunction="Contains"
ShowFilterIcon="false" AutoPostBackOnFilter="true" />
Lets say the user wants to locate a partner whose name starts with "Briar's". They enter this text in the filter column, and hit enter.
On the back end, the filter expression is defined within the grid.MasterTableView.FilterExpression is set to:
(iif(PartnerName == null, "", PartnerName).ToString().ToUpper().Contains("briar''s".ToUpper()))
Notice that the grid has replaced the single quote in Briar's with two single quotes. While this logic makes sense if we're sending the filter expression back to a database directly, it does not make sense when used as part of a Dynamic Linq statement, and in fact results in the query not returning any values..
There doesn't seem to be any way to work around this bug at the moment, short of some invasive string manipulation. Is there a way to force the grid to not replace the single quote with two single quotes?
Roy
6 Answers, 1 is accepted
0
Accepted
Hi RD,
Tsvetoslav
the Telerik team
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Follow the status of features or bugs in PITS and vote for them to affect their priority.
You completely correct in you observation - thanks for turning our attention to this issue. I am also glad to inform you that it has already been addressed and the fix will be available in the next latest internal build.
I have updated your Telerik points accordingly.
Regards,Tsvetoslav
the Telerik team
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Follow the status of features or bugs in PITS and vote for them to affect their priority.
0
RD
Top achievements
Rank 2
Rank 2
answered on 02 Feb 2010, 05:30 PM
Thanks Tsvetoslav,
Is it possible to get access to these internal builds? Or do I have to wait until the next quarter's release comes out?
Thanks,
Roy
--- Edit: oops - strike this question - just noticed the "internal builds download" from my accounts page.
Is it possible to get access to these internal builds? Or do I have to wait until the next quarter's release comes out?
Thanks,
Roy
--- Edit: oops - strike this question - just noticed the "internal builds download" from my accounts page.
0
Sunil Kaim
Top achievements
Rank 1
Rank 1
answered on 10 Feb 2010, 06:34 PM
To telerik
Can we use the internal build in production.
Are they stable enough.
Thanks
Can we use the internal build in production.
Are they stable enough.
Thanks
0
Hello Sunil,
All internal builds passed our automated tests before uploaded on telerik.com. However, they are not recommended to be used in production since their release quality is not 100% guaranteed.
Best regards,
Sebastian
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.
All internal builds passed our automated tests before uploaded on telerik.com. However, they are not recommended to be used in production since their release quality is not 100% guaranteed.
Best regards,
Sebastian
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
Lakshman Maruri
Top achievements
Rank 1
Rank 1
answered on 27 May 2010, 04:19 PM
Did we have the latest build that has the fix for the above issue? If not when can we expect the new latest build??
Thanks
Lakshman Maruri
Thanks
Lakshman Maruri
0
Hello Lakshman,
The issue should be addressed in the latest official release 2010.1.519 of RadControls for ASP.NET AJAX (Q1 2010 SP2). Upgrade instructions are available here.
Best regards,
Sebastian
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.
The issue should be addressed in the latest official release 2010.1.519 of RadControls for ASP.NET AJAX (Q1 2010 SP2). Upgrade instructions are available here.
Best regards,
Sebastian
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.