feat: add column filters to table

[zemirco]

Prerequisites

• I know how to contribute a proper feature request.
• I agree to follow the Code of Conduct.
• I have searched for existing feature requests that already request this feature, without success.

Describe the feature request

It would be nice to have filters for tabular data. Ideally we would be able to have the following features

• multiple filters for a single column
• multiple filters across columns
• automatically find unique data within a column and provide filter keywords
• resetting / removing the filter

The filter should depend on the type of data within a column, e.g.

• a date column should have a date filter
• a number column should have number filters (above, below, between, etc.)
• a boolean column should have true/false/na filters

We would also need backend interaction. Quite often not all the data is already available in the frontend. The user might only see 10.000 out of 1.000.000 rows. When we apply the filter we should consider pagination and backend interaction.

Describe the use case

We have very scientific and data heavy applications. Sometimes showing all the data is not necessary and can be overwhelming for our users. It would be great to provide filters so our users can focus on the data they need.

Describe preferred solution

https://adazzle.github.io/react-data-grid/#/header-filters

https://mui.com/x/react-data-grid/

https://reactdatagrid.io/demo

https://www.ag-grid.com/react-data-grid/filtering/

https://www.telerik.com/kendo-react-ui/components/grid/filtering/

https://www.infragistics.com/products/ignite-ui-react/react/components/grids/data-grid-column-filtering

https://ej2.syncfusion.com/react/demos/?_gl=1*nt9t34*_ga*MTYyNjIyNDcwMC4xNjczNTk5Nzkw*_ga_WC4JKKPHH0*MTY3MzU5OTc5MC4xLjAuMTY3MzU5OTc5MC4wLjAuMA..&_ga=2.12839479.1625363014.1673599790-1626224700.1673599790#/material/grid/overview

https://ant.design/components/table#components-table-demo-head

Microsoft Excel

Describe alternatives

No response

Related code

It is related to the umbrella issue #469.

Additional information

No response