Starts with Operator Issue in Grid Filter Column

[Dharmesh]

We have column name Member Name in Data Set and we are using following sql query for getting this name into data set.

Select

 

COALESCE(   

   STUFF   

   (   

    (    

     SELECT DISTINCT  

      ''; '' + FirstName + CASE WHEN MI IS NULL THEN '''' ELSE '' '' + MI END + '' '' + LastName  

     FROM  

      TestTable1 

      INNER JOIN TestTable2 on TestTable1.customerid = TestTable2.customerid  

     WHERE  

      TestTable2.MemberID = TestTable1.customerid

     FOR XML PATH('''')     

    )   

   ,1,1,''''   

   ),''N/A'')  AS [Name]

   From TestTable

 

Based on above query we are getting customer name successfully in data set and bind to grid. Now issue is that we are not able to use Starts with operator and column filter is not returning any result. However when we use “Contains” operator we are able to retrieve correct result.

Also we have another column that simply returns column data as below

Select TestTable.PersonName From TestTable

Using above query we are successfully use starts with operator.

So what can be the problem and how can we resolve it?

Regards,

Dharmesh Solanki

[Veli]

Hello Dharmesh,

We cannot identify the cause of this issue from the provided SELECT statement. If you are using a DataSet as RadGrid's data source, then RadGrid should perform filtering internally based on the result from the data set. Consider sending us some runnable project demonstrating your particular scenario attached in a support ticket. Thus we can debug this issue locally. Refer to this forum thread in the ticket.

Veli
the Telerik team