Tuesday, 31 December 2019

Customized Faceted Search in Oracle APEX

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








Stop Reading About AI, Start Building It. Your Launchpad is Ready.

For 35 years in the IT industry, and across 22 books, I’ve seen countless technologies change the game. But nothing is more hyped—or more co...