Filtering grid column using startswith is suddenly broken

[Stefan]

Hi support team,

 

sadly, we ran out of support so I'll try the forum for help.

 

We have bound column

 

   columns.Bound(c => c.BusinessPartner.Name).Title("Customer").Groupable(true)
       .Filterable(f => f.Multi(false).Search(true).Cell(c => c.ShowOperators(false).Operator("startswith"))).Width(250)
       .ClientTemplate(@"
           #= data.BusinessPartner.Number # #= data.BusinessPartner.Name #
           #if (data.BusinessPartner.PostalAddress != null) {#
               <span class='d-flex'> (#= data.BusinessPartner.PostalAddress.City #)</span>
           #}#");

 

From now on the filter using "startswith" is broken. Let me explain. Yesterday when entering "e" it displays all customers starting with "e". But suddenly some customers are not shown any more. Yesterday the list contained two entries and today only 1 entry any more.

I examined the SQL query behind the scenes but this is ok.

What could be wrong here?

[Stefan]

I assume there is an issue filter on navigation (or nested) properties

[Ivaylo]

Hello Stefan,

Thank you for the details provided.

I created a sample application using product version 2024.2.514 and .NET 8, implementing the code from the provided snippet. Everything worked as expected. The application is attached. Please check if the column filtering works as per your expectations. Otherwise, provide more details or reproduce the issue in the attached project. This will help us investigate and provide the respective solution.

Also, could you share the product version you are using?

I hope the application will be helpful.

Kind Regards,
Ivaylo
Progress Telerik