International Journal on Science and Technology

E-ISSN: 2229-7677     Impact Factor: 9.88

A Widely Indexed Open Access Peer Reviewed Multidisciplinary Bi-monthly Scholarly International Journal

Call for Paper Volume 16 Issue 3 July-September 2025 Submit your research before last 3 days of September to publish your research paper in the issue of July-September.

Next-Gen Dashboards with Oracle APEX: From Charts to Smart Filters

Author(s) Ashraf Syed
Country United States
Abstract Oracle Application Express (APEX) is a low-code development platform tightly integrated with Oracle Database. APEX provides powerful next-gen dashboard with smart interactive capabilities, combining rich charting, data filtering, and modern UI design. This article surveys APEX dashboard features, emphasizing data visualization options (chart types, stacking, drill-down links), UI/UX enhancements (Universal Theme, template directives, faceted search, smart filters), and data integration (RESTful and external sources). The article enumerate supported chart types (bar, line, area, pie, donut, funnel, gauge, scatter, bubble, heatmap, gauge, stock, and more) and explain how to create stacked bar charts and enable drill- down from charts to detail pages. A novel approach is proposed that leverages APEX’s template components and dynamic actions to improve dashboard usability. Code snippets illustrate building chart regions and filters (e.g. SQL queries for charts and JavaScript API calls), and screenshots show example dashboards. The intended audience includes database professionals, business analysts, researchers, and students interested in practical and advanced APEX dashboard design. This review references official APEX documentation and credible sources to give a complete, current picture of APEX dashboard capabilities.
Keywords Oracle APEX, Interactive Dashboard, Data Visualization, Oracle JET Charts, Universal Theme, Template Components, Faceted Search, Smart Filters, REST Data Source, Drill-Down, Stacked Bar Chart, UI/ UX, Low-Code, Data Integration
Field Engineering
Published In Volume 16, Issue 3, July-September 2025
Published On 2025-09-05
DOI https://doi.org/10.71097/IJSAT.v16.i3.8002
Short DOI https://doi.org/g92ntj

Share this