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








The Future of Sovereign Business Intelligence: Why BizQuery AI is the Ultimate Data Analyst for Global Enterprise

  The Data Dilemma: Why Modern BI is Broken In today’s fast-paced global market, business owners and RevOps managers face a frustrating para...