Farhaj Lodhi's :: Ilm Sub Ke Liye

  Introduction Oracle APEX is Oracle’s low-code application development platform that enables developers to rapidly build secure, scalable, data-driven web applications directly on Oracle Database. It reduces development effort while providing powerful features such as Interactive Reports, Interactive Grids, Workflows, and dashboards. Organizations worldwide use Oracle APEX to build enterprise applications, self-service portals, and reporting systems. One of the key strengths of APEX is its flexible navigation model, which allows developers to pass values between pages for drill-down reporting and master-detail application. Oracle APEX provides several ways to navigate between pages. One of the most practical techniques is Column Links , which allow users to click a value in a report and navigate to another page while automatically passing selected values as parameters. This approach is useful when building drill-down reports, dashboards and master-detail pages where users ...

  Overview Oracle APEX has powerful features for building interactive dashboards and data-driven applications.   In this article, we discuss how a Pie Chart can pass the selected supplier value to a Hidden Page Item, which is then used to dynamically filter an Interactive Grid and display only the relevant records.   Objective A common requirement is to filter dashboard data based on user interaction with charts. Prerequisites Before implementing this, ensure the following are available. An Interactive Grid region. A Pie Chart region displaying Top five supplier information by QA Result. A Hidden Page Item to store the selected supplier. A report query that supports filtering using bind variables. What is a Hidden Page Item? In Oracle APEX, a Hidden Page Item stores values that are not visible to end users but remain available during page processing, validations, computations, Dynamic Actions, and PL/SQL execution  How t...