The built-in filter wouldn’t work for this one. You need to create a custom filter.
The best UI/UX practice from my experience for the case is the following:
-
Make it work:
1.1. Create a column per every parameter that the collection is filtered by in the user profile table;
1.2. Add a title action for the collection and make it open up a new screen for the current user’s profile as a slide-in screen (or overlay);
1.3. In that new screen you need to add all the input components that will write to the columns created in the first step;
1.4. In the user profile table create a query column that will take the collection in question as a source and filter it by the values from the columns created in the first step. Build some defaulting logic if needed — usually you wanna use ITE columns that will return a value that won’t filter out any elements if the according writeable column is empty. Use those ITE in the query I mentioned above;
1.5. Display the results of the query in the collection. -
Make it nice:
2.1. For the title action button pick an outlined filter icon from the legacy section;
2.2. Duplicate the collection and in the second one set the icon of the title action button to the same legacy filter, but solid. Display the first collection if all the filtering parameters in the user profile are empty, and the second one otherwise.
That way you’ll have a neat visual indication that filters are applied.