Multiple GridFilterSettings

[Ben Denham]

Hello,
Within a grid is it possible to to have both Excel Filtering and a Filtering Bar?
From the documentation it looks like you can only specify one e.g.

<GridFilterSettings Type="FilterType.Excel"/>

or

<GridFilterSettings Type="FilterType.FilterBar"/>

We are migrating away from another UI framework where this is possible so keen for any work arounds to allow an easier migration for our users.

Thanks,
Ben

[Monisha Saravanan]

Hi Ben,

Greetings from Syncfuion.

Query: “Within a grid is it possible to have both Excel Filtering and a Filtering Bar?”

We suspect that you are trying to use Excel and FilterBar at the same time in DataGrid. We would like to inform that we cannot use the other filter types along with filterBar type. Because the filterbar type requires UI level changes with other filter types i.e) FilterBar requires input box whereas for other filters filter icon will be rendered. We have already documented this in the below UG section. Kindly check the attached documentation for additional information.

Reference: https://blazor.syncfusion.com/documentation/datagrid/filter-menu#limitations-of-using-different-filter-types-in-different-columns

Other than filterbar we have support to render multiple filters in the same Grid. Kindly refer the below documentation for detailed reference.

https://blazor.syncfusion.com/documentation/datagrid/filtering#enable-different-filter-for-a-column

Please get back to us if you have further queries.

Regards,

Monisha

[Ben Denham]

Hi Monisha,

This is disappointing to hear. Can this be raised as a feature as I am not really sure I understand the limitation of it requiring a UI level change? Other UI frameworks have this functionality so would be nice for this to be available too.

For anyone else looking to implement this, as a workaround we have added a text box into the header template where a user will be able to type a value, we then create a query from that value and apply it to the grid. It's still a POC our end but does seem prove the concept at least. We will have to worry about problems like persistence though, which is why ideally this would be built into the syncfusion grid.

Thanks,
Ben

[Monisha Saravanan]

Hi Ben,

We would like to inform you that besides the necessary UI adjustments there will be other issues while utilizing a combination of filters (filter bar and other filter). For example: there will be conflict in generating and maintaining filter predicates whereas by using checkbox and excel filter we can filter multiple values in the same column. So there will be conflict when multiple filters are applied simultaneously. So it is not possible to provide support to render filterbar with other filter modes.

Please let us know if you have any concerns.