Skip to Main Content
Feature Request FR-4248
Product Area Page Components
Status CLOSED

1 Voters

Native Tree-Structured Reports & Searchable LOVs – Unlock Hierarchical Data

yannis Public
· Jan 31 2025

Idea Summary

Enhance Oracle APEX by introducing native Tree-Structured Reporting and Searchable LOVs for Classic Reports, Interactive Reports, Interactive Grids, and Faceted Search. This would enable hierarchical data representation with multiple fields per node, built-in subqueries for aggregations (counts, sums), and a fully searchable Tree-based Popup LOV. Additionally, a Directory-Like Component would provide an intuitive way to navigate hierarchical datasets.

Key Features:

Tree-Structured Reports & Grids

  • Enable native hierarchical data visualization.
  • Allow multiple fields per node with proper alignment.
  • Support built-in subqueries to compute related aggregations (e.g., counts, sums).

Searchable Tree in Popup LOVs

  • Introduce a tree-based Popup LOV, allowing users to search within the hierarchy.

Hierarchical Aggregations

  • Compute counts at the leaf level and aggregate values up to parent nodes.

New Directory-Like Component

  • A file-explorer-style UI for hierarchical navigation.
  • Expand/collapse nodes for easier data exploration.
  • Drag-and-drop support for reordering where applicable.

Use Cases

1. Quality Assurance Management

QA teams track application components in a hierarchical tree, with each node linked to test cases, defects, and executions. Seeing real-time aggregated counts at every level improves progress tracking, while a searchable tree-based Popup LOV helps locate components quickly.

2. Accounting & Financial Reporting

European accounting structures require multi-level hierarchies where credits and debits roll up dynamically from transactions to parent accounts. A tree-based report simplifies financial analysis.

3. Project & Resource Management

Organizations structure data as Departments → Teams → Projects → Tasks or Countries → Regions → Locations. APEX users would benefit from real-time aggregation and drill-down navigation.

4. Directory-Like Component for Hierarchical Navigation

A new directory-style UI would streamline navigating structured data, such as:

  • HR Org Charts: Display departments and employees.
  • Product Catalogs: Browse categories and items.
  • Knowledge Bases: Organize articles in a structured tree.

Preferred Solution (Optional)

A Tree View Rendering Engine could integrate with existing reporting components, leveraging Oracle’s hierarchical SQL (CONNECT BY, WITH RECURSIVE).

For Popup LOVs, support:

  • Lazy loading for large datasets.
  • Full search & filtering.

The Directory Component would function as a hierarchical UI control, with:

  • Drag-and-drop reordering.
  • Expandable/collapsible nodes.
  • Dynamic access control.

By implementing these features, Oracle APEX would revolutionize hierarchical data management, making it a must-have for developers and business users alike.

This request is likely a duplicate of FR-2530.

Comments

Comments

  • fac586 OP 10 days ago

    By implementing these features, Oracle APEX would revolutionize hierarchical data management, making it a must-have for developers and business users alike.

    ChatGPT was feeling particularly hyperbolic on Friday…

  • fac586 OP 10 days ago

    Duplicate of FR-2530

  • vincent morneau Admin OP 10 days ago

    Thanks @fac586 those ChatGPT ideas are becoming very common lately.

  • yannis OP 10 days ago

    I was looking for Tree-related request, but it did not return the FR-2530. Glad it's there. 
    Regarding ChatGPT, yes, it recreated my original idea nicely.  What's wrong with it? It might be a bit hyperbolic, but it caught your eyes.