1. Feedback
  2. ASP.NET Core
  3. 68703

Welcome to the ASP.NET Core feedback portal. We’re happy you’re here! If you have feedback on how to improve the ASP.NET Core, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

0
Votes

Unable to filter for ForeignKey columns in Datagrid

I have a dataGrid component that has a ForeignKey column. The grid binds to data using UrlAdaptor to my backend service, which reference an Employee table, who has a ForeignKey to the Branch table. 

In the dataGrid, I am showing the employee detail with the Branch info. Everything works great except the excel file filter or the Search control when I search/filter for something for the Branch. I get a null reference exception in the service method when applying the Where.predicates.. if I remove the ForeignKey column from the Where.Predicate list, then filtering/search works fine.

Below is my grid component and backend service for filtering/search.