Comparison between Faceted search and Smart filter regions Oracle APEX.
Smart Filters:-
Smart Filters is a new search component that allows users to quickly narrow data down with filter suggestions or search terms. Developers can use this component to provide users with a simplified search experience that eliminates clutter and provides a single control to instantly find the information they are looking for.
Faceted Search:-
A region based on the source of an associated Faceted Search, that provides end-users with numerous facets that are used to narrow search results at run-time.
Multi-Value Facets:-
Easily create facets for multi-value columns stored as a separate string or a JSON array. Chaitanya’s explanation on multi values in Faceted search https://www.youtube.com/watch?v=BneRrJBqtds&t=0s