Using Excel filter and creating a custom filter in the dialog is not possible

[Riley McLaughlin]

I have a Grid that I am binding to a list. I have set TValue and Id for SfGrid, as well as setting AllowFiltering=true and using these filter settings:

Filters work fine for simple column filters but trying to use a two part filter is not possible:

Selecting a filter type like Greater Than Or Equal or Less Than does not actually reflect in the dropdown, so the complex filter cannot be created. If a value is entered in the second field without choosing a filter type, it will filter out all items. When trying to enter the filter menu again, an enum tryparse error is thrown on integer or Date column types. When doing the same thing in string columns the filter is not created and no error is thrown.

Thank you for your help,

Riley

[Monisha Saravanan]

Hi Riley,

Greetings from Syncfusion support.

Query: “Selecting a filter type like Greater Than Or Equal or Less Than does not actually reflect in the dropdown, so the complex filter cannot be created. ”

We have checked your reported query but we could not able to reproduce the reported issue at our end. Kindly check the attached sample and video demo for your reference.

Sample: https://blazor.syncfusion.com/documentation/datagrid/excel-like-filter

Video: https://www.syncfusion.com/downloads/support/directtrac/general/ze/CustomFilter-Video1948033539.zip

If you still face difficulties then kindly share the below details to validate further at our end.

1. Share us entire Grid code snippet along with model class.
2. Share us the Nuget version used at your end.
3. Share us the video demonstration of the issue with detailed replication procedure.
4. If possible share us an simple issue reproduceable sample.

The above-requested details will be helpful for us to validate the reported query at our end and provide the solution as early as possible.

Regards,

Monisha