Introduction: –
Oracle APEX offers a robust set of page item types to capture user input effectively. Among these, Select One and Select Many items are particularly versatile for collecting data where users need to choose from a predefined list of options.
Select One
Displays as an item with a list of values icon which supports the selection of one value and search filtering.
When the end user clicks the field, a popup window appears with a list of suggested values. A Select One item provides a more user-friendly option compared to a Select List item and supports filtering, groups, and template directives.
Select Many
Displays a drop-down list that supports multi-select and search filtering.
A Select Many item displays a LOV based item that shows suggestions that allow multi-values. When the end user clicks the field, a popup window appears with a list of suggested values. A Select Many item provides a more user-friendly select item compared to a Popup LOV and supports filtering, groups, and template directives.
The following technologies has been used to achieve the same.
- Oracle APEX
Why we need to do: –
In an Oracle APEX application for managing a company’s internal training programs, the “Select Many” and “Select One” page items are used to streamline the course enrollment process.
When an employee accesses the enrollment form, they can use the “Select Many” item to choose multiple courses they want to attend from a list of available options. Simultaneously, a “Select One” item allows them to select their preferred training location from a drop down menu.
This setup enables employees to quickly and efficiently enroll in multiple courses while ensuring they can attend them at their desired location, making the process both flexible and user-friendly.
Real-Time Supplier Selection in Procurement System
When a procurement manager is creating a new purchase order, they can use the “Select Many” item to choose multiple suppliers from an approved list, ensuring that all necessary materials are sourced efficiently. Concurrently, the “Select One” item allows them to select the priority level for the order, such as “Urgent,” “Standard,” or “Low.”
This setup enables the procurement team to quickly identify and engage with multiple suppliers while clearly indicating the urgency of the order, optimizing the procurement workflow.
How do we solve:
Creating Select One and Select Many Page Items
Create a new page item: In the Page Designer, click the “Create Page Item” button.
Choose the item type: From “TYPE” option choose Select One or Select Many
SELECT ONE:
SELECT MANY:
Create a Shared LOV:
- Navigate to Shared Components -> Lists of Values.
- Click Create.
- Define the LOV properties (name, display value, return value, query).
Choosing the LOV: Choosing the same LOV for both page item
Select one: This drop down contains a list of options that a user can choose from. Only one option can be selected at any given time.
Select Many :It appears as a list or a drop down where users can select more than one option.
Additional settings: Customize display and return values, null values, and other properties as needed.
Conclusion:
Select One and Select Many page items are fundamental components in Oracle APEX for capturing user input. The choice between the two depends on the specific requirements of our application and the nature of the data being collected.
