Blazor DataGrid Excel Filters with server side data not showing entries

[Thomas Vasilakis]

Hi,

I have a Blazor grid working with remote data via an UrlAdaptor and the filtering operations work except when using Excel style filters. Specifically, the filter UI doesn't populate with distinct entries for that column and always only shows the following:

I've examined the request sent from the server and there are indeed distinct entries arriving at the client, however they're not displaying in the UI. Please note that there are no server or client side exceptions being raised. I also read another couple of threads that suggested the problem was with the number of records being filtered but the total records in this case is 364.

Please help :)

[Dhivya Rajendran]

Hi Thomas, 

Greeting from Syncfusion support. 

As per the provided information, we have validated with our end and tried to reproduce the reported problem but we could not face this problem at our sample and we have attached a sample for your reference. For further validation, could you share the below details that will help us to validate and provide an appropriate solution as soon as possible. 

Sample : https://www.syncfusion.com/downloads/support/directtrac/general/ze/URLAdaptor1784783138  

• The reported problem occurred for any particular column or all columns ?
• Based on the server data we have performed distinct in client side and bind the result to check list so could you please check and confirm whether did you returned all 364 records from server when click filter menu?
• Share the grid settings and server side code example for further validation.
• Also, share Syncfusion Nuget Package Version.

Regards, 

R.Dhivya