problem with indices

[Vitaliy]

Hello

We use Telerik Grid (in ASP.NET AJAX).
It's convinient to use Column Grid Filters because it let us avoid lot's routine job.
But the bad size is that it used to generate such kind of quieries to our SQL Server:

SELECT *
FROM   [dbo].[OPCatalogue] AS [t0]
WHERE  (CONVERT(NVarChar(MAX), (CASE
                                  WHEN 0 = 1 THEN CONVERT(NVarChar(40), '')
                                  ELSE CONVERT(NVarChar(40), [t0].[SKU])
                                END))) LIKE 'something%' 

This query works without using indecies, so it would be much more prefer to construct the sql like this:
SELECT *
FROM   [dbo].[OPCatalogue] AS [t0]
WHERE  [t0].SKU LIKE 'something%'

this way it's going to use the index and work much faster.

How can we make Telerik Grid generate such kind of simpler queries?

[Pavlina]

Hello,

You can handle ItemCommand event (check that e.CommandName is "FilterCommandName") where you can prevent the initial filtering and build a simpler queries:
http://www.telerik.com/help/aspnet-ajax/grid-operate-with-filter-expression-manually.html

Regards,
Pavlina
Telerik