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

Filtering problem

1 Answer 50 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Tomasz
Top achievements
Rank 1
Tomasz asked on 12 May 2011, 11:54 AM
Hello,

I've got a problem with filtering string field using "between" and "not between" options from the standard available filter list. It just throw exception like "Operator '>=' incompatible with operand types 'Object' and 'String' (at index 20)"
ne.
I looked around the forum and I found out it can be "EnableLinqExpression" issue. So I add to my radGrid ( on the aspx page)
EnableLinqExpression=false. And all works fine!

Unfortunately another filter for the datetime field stoped working with "between" and "not between" options. This particular field filtering is handled separately by "OnItemCommand" (to allow filtering date without time).

What could be the best solution for this problem?

My telerik version is: 2008.3.1125.35

Thanks in advance,
Tom
 

1 Answer, 1 is accepted

Sort by
0
Pavlina
Telerik team
answered on 17 May 2011, 11:32 AM
Hi Tomasz,

Indeed the built-in GridDateTimeColumn do not allow between filter since the parsing mechanism of the date input (part of the date picker used for filtering) allows merely one date to be entered. To apply 'Between' filter you should either use the approach with two pickers in the filter template from the demo (OrderDate column) or built-in GridBoundColumn with textbox filter.

Kind regards,
Pavlina
the Telerik team

Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.

Tags
Grid
Asked by
Tomasz
Top achievements
Rank 1
Answers by
Pavlina
Telerik team
Share this question
or