Oracle APEX 19.2 introduced Faceted Search, which allows you to apply filters to a classic report. The built-in faceted search page consists of a classic report region, showing search results, and a region of the new Faceted Search type, which holds the facets. The Faceted Search region is linked to the Classic Report region, and each Facet is linked to one of the Classic Report result columns.
I created this custom faceted search utility which contains different facets including a date range facet and is linked to an interactive report, which allows you to apply control breaks, aggregates, chart and group views, and pivot table.
Try Live Demo: https://apex.oracle.com/pls/apex/f?p=2869:5
I created this custom faceted search utility which contains different facets including a date range facet and is linked to an interactive report, which allows you to apply control breaks, aggregates, chart and group views, and pivot table.
Try Live Demo: https://apex.oracle.com/pls/apex/f?p=2869:5