Allow to filter/sort/search at collection element level

When we display records in a collection element the data are filtered at the data source level by filters created by the application designer. However sometimes we want the table to be filterable/sortable/searchable by the end user.

For instance the end user might want to see only tasks with "To do" state and to sort them by "Due date".

In this case we could add a way to define filters/sort/search at the element level. The filters and search are applied ON TOP of the existing filters for the data source. The data source filters/search are a security feature so they shouldn't be overiden by the end user operations. Regarding the sort, it replaces the sort defined by the data source. As consequence, the filtering/sorting/searching operation has to be executed by the backend.

The application designer can decide on a per-element level whether the filtering/sorting/searching are enabled. The search only could be allowed for instance.

UX design needed: A table element that allows filtering/sort/ordering.