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

RadGrid filtering bug when EnableLinqExpressions=true

6 Answers 169 Views
Grid
This is a migrated thread and some comments may be shown as answers.
RD
Top achievements
Rank 2
RD asked on 29 Jan 2010, 05:53 PM
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:

<

 

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

Sort by
0
Accepted
Tsvetoslav
Telerik team
answered on 02 Feb 2010, 05:24 PM
Hi RD,

 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
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. 
0
Sunil Kaim
Top achievements
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
0
Sebastian
Telerik team
answered on 11 Feb 2010, 12:08 PM
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.
0
Lakshman Maruri
Top achievements
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
0
Sebastian
Telerik team
answered on 27 May 2010, 05:30 PM
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.
Tags
Grid
Asked by
RD
Top achievements
Rank 2
Answers by
Tsvetoslav
Telerik team
RD
Top achievements
Rank 2
Sunil Kaim
Top achievements
Rank 1
Sebastian
Telerik team
Lakshman Maruri
Top achievements
Rank 1
Share this question
or