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

12 Voters

Enhanced Features for Popup LOV in Oracle APEX Column wise search option same like interactive report

parthiban ganesan Public · Dec 26 2024

Enhanced Features for Popup LOV in Oracle APEX Column wise search option same like interactive report

Background:

The column-wise search functionality in Oracle APEX Interactive Reports and Interactive Grids provides users with a powerful tool to search and filter data seamlessly. However, this functionality is currently not available in the Popup LOV component, which limits its usability for advanced search scenarios.

Requirement:

Enhance the Popup LOV component in Oracle APEX to include the following features:

Column-Wise Search:

  • Enable column-wise search functionality for Popup LOVs, similar to what is available in Interactive Reports and Interactive Grids.
  • Users should be able to search within individual columns of the LOV data set, making it easier to locate specific records.

Create or View Button:

  • Add an "Add New" or "Create" button directly within the Popup LOV interface.
  • This button should allow users to create a new record if the desired data is not available in the LOV's current dataset.
  • Include a "View" or "Edit" button to allow users to view or modify the details of an existing record directly from the Popup LOV.

Enhanced Usability:

  • Provide additional configuration options to allow developers to:
    • Define which columns are searchable.
    • Customize the behavior of the "Create" and "View" buttons (e.g., open a modal dialog, navigate to a form page, etc.).
  • Ensure these features are consistent with APEX's low-code philosophy and are easy to integrate into existing applications.

Benefits:

  • Improves the user experience by enabling granular and targeted searches within Popup LOVs.
  • Eliminates the need for users to navigate away from the current page to create or edit master data.
  • Enhances developer productivity by reducing the need for custom development to implement such functionality.

Use Case Example:

  • A user is searching for a customer in a sales order form. If the customer's record is not found in the LOV, the user can immediately create a new customer without leaving the form.
  • While searching for products in a Popup LOV, users can quickly locate items using column-specific filters, such as product category, price range, or availability.

Request Summary:

We request the Oracle APEX development team to consider incorporating these enhancements into future releases of APEX. These features would significantly enhance the functionality and user experience of Popup LOVs, aligning them with the powerful search capabilities of other APEX components like Interactive Reports and Grids.

  1. Below screen shows for popup lov with multiple column.

2. Filter options for the selected column are displayed when clicked.

We reviewed this idea carefully, and while it was interesting, we concluded that it is unlikely to make its way into APEX in the foreseeable future.

Comments

Comments

  • csenthilmurugan OP 1.2 years ago

    we have used plugin, if we get this option in Popup LOV then everyone will get benefit.

  • gokul b OP 1.2 years ago

    This will be a better feature for popup lov.

  • priyaravi OP 1.2 years ago

    If the option to retrieve and display the previously selected value is added to the Popup LOV, it would greatly enhance its usability. This feature would provide consistency and ease of use for all users, similar to other functionalities already implemented

  • vincent morneau Admin OP 1.2 years ago

    While this idea could work, you could consider having a dialog with a more advanced component like the IR on it. We don't typically recommend this, however we can't prioritize improving the popup LOV to resemble more like an IR right now.