ExpressionBuilder.Expression(filters) in Kendo MVC grid not working for navigation collection

0 Answers 42 Views
Grid
Kyle
Top achievements
Rank 1
Kyle asked on 15 Dec 2021, 11:43 AM

Hi

Reasking the same question below that some else asked in 2016 from here https://www.telerik.com/forums/expressionbuilder-expression(filters)-in-kendo-mvc-grid-not-working-for-navigation-collection 

Is this still the same answer 5 years on?

Cheers

Kyle

Original Question from 2016

"We are using Kendo MVC Grid in our application. We are using LINQ to EF to query the tables.

Following is a query in our application:

query.Where(ExpressionBuilder.Expression<ParentTable>(command.Request.Filters))

This works fine as long as the filters are any columns from the "ParentTable". However, the ParentTable has a navigation collection ICollection<ChildTable> and the ChildTable has a property ChildProperty and the method ExpressionBuilder.Expression fails when we use this ChildProperty for filtering.

Any solution for this problem?

Thanks"

Original Answer

"Hi,

I'm copying my reply to your support ticket here for customer reference.

I'm afraid the Where extension does not support filtering by collection.
This is not a design goal of the data engine.

Regards,
T. Tsonev
Telerik"

No answers yet. Maybe you can help?

Tags
Grid
Asked by
Kyle
Top achievements
Rank 1
Share this question
or