
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
Plagiarism is checked by the leading plagiarism checker
Call for Paper
Volume 16 Issue 3
July-September 2025
Indexing Partners



















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


CrossRef DOI is assigned to each research paper published in our journal.
IJSAT DOI prefix is
10.71097/IJSAT
Downloads
All research papers published on this website are licensed under Creative Commons Attribution-ShareAlike 4.0 International License, and all rights belong to their respective authors/researchers.
