🎯 Oracle APEX 26.1: Making Select Lists Smarter with Quick Picks

-

🚩Introduction 

  • In Oracle APEX 26.1, Select Lists and Popup LOVs come with a new feature called Quick Picks. This feature is designed to make it easier for users to choose values from long lists.

  • Instead of scrolling through a long list every time, users can quickly pick from these suggested values, making data entry faster and more convenient.

📑 Why Quick Picks is Useful in Oracle APEX 26.1

In real-time applications, users often work with long lists in Select Lists or Popup LOVs. Scrolling through these lists again and again can take time and slow down data entry, especially when the same values are used frequently.

Quick Picks becomes useful when:

  • Users frequently select the same values again and again

  • Select Lists or Popup LOVs contain a large number of options

  • Data entry needs to be faster and easier

  • Users want to avoid searching through long lists every time

  • A smoother and more user-friendly experience is needed

This feature helps users save time, reduces unnecessary scrolling, and makes working with Select Lists and Popup LOVs simpler and more efficient in Oracle APEX 26.1.

👉 Use Case: Quick Picks for Select List / Popup LOV in Oracle APEX

In Oracle APEX, users often work with Select Lists and Popup LOVs to choose values from a list. When the list contains many options, finding the same values again and again can take time and make data entry slower.

In this blog, we will see how to use the Quick Picks feature introduced in Oracle APEX 26.1. This helps users quickly access commonly used or recently selected values, making the selection process faster, easier, and more user-friendly.

Step 1: 

In the Page Designer, create the page item of type select list and in the List of Values, select the type as  SQL Query and copy paste the sql query below.
SELECT DISTINCT DNAME D, DEPTNO R FROM DEPT


Step 2 :  

In the properties, navigate to the Quick Picks section which is introduced in the Oracle APEX 26.1 and select the type as SQL Query and copy paste the query below

SELECT DISTINCT DNAME D, DEPTNO R FROM DEPT

Step 3 :  

Under the Quick picks section, in the Link Attributes, copy and paste the below one.

class = "my-quickpick"

 

Step 4 :  

In the page, navigate to the Inlince CSS section, and copy paste the below css code.

------ Inline CSS -------

.my-quickpick {
    display: inline-block;
    padding: 6px 14px;
    margin: 2px 4px 2px 0;
    border: 1px solid #d0d0d0;
    border-radius: 20px;
    background-color: #f8f8f8;
    color: #333 !important;
    text-decoration: none;
    margin-top: 10px;
}

.my-quickpick:hover {
    background-color: #e8f1ff;
    border-color: #0063d1;
    color: #0063d1 !important;
    text-decoration: none;
}

.my-quickpick.is-selected {
    background-color: #0063d1;
    border-color: #0063d1;
    color: white !important;
}


Step 5 :  

In the page, navigate to the Function and Global Variable Declaration section, and copy paste the below Javscript code to highlight the selected value.

//Function and Global Variable Declaration

document.querySelectorAll('.my-quickpick').forEach(function(link) {
  link.addEventListener('click', function() {
    document.querySelectorAll('.my-quickpick')
      .forEach(l => l.classList.remove('is-selected'));

    this.classList.add('is-selected');
  });
});

Step 6:  

Now save and run the page, you will see the page with the select list and it shows the quick picks values. You can select any one of the values from it.

🔥 Conclusion

Thus, in Oracle APEX 26.1, using Quick Picks for Select Lists and Popup LOVs is a simple way to improve the user experience. It helps users quickly choose commonly used or recent values without searching through long lists every time. This makes data entry faster, reduces effort, and keeps the selection process smooth and easy. Overall, it makes the application more user-friendly and efficient.


Comments

Post a Comment

Popular posts from this blog

🔍 Extending Smart Search Filter for Multiple Regions

-
Image
🚩Introduction  In Oracle APEX, the Smart Search filter is a convenient feature that allows users to quickly search data in a Classic Report or Cards region without writing custom code. However, this functionality is limited to a single region , which can be restrictive when a page contains multiple regions that should respond to the same search input. In this tutorial, you will learn how to extend the Smart Search filter to work with multiple regions on the same page . We will implement a solution that allows one Smart Search input to drive filtering across multiple Classic Report ,Cards regions etc. By the end of this tutorial, you’ll have a clear, reusable approach for coordinating search behavior across regions, improving both usability and consistency in your Oracle APEX applications without breaking the declarative nature of APEX. 📑 Why Extending the Smart Search Filter Is Needed The built-in Smart Search filter in Oracle APEX works well when a page contains a single sear...
Read more

💡 Designing Dynamic QuickPicks in Oracle APEX

-
Image
🚩Introduction  Oracle APEX provides Quick Picks as a convenient way to allow users to populate page items with predefined values using a single click. While static Quick Picks are useful, real-world applications often require these values to be generated dynamically based on business rules, user roles, or underlying data. This blog explores how to implement Dynamic Quick Picks in Oracle APEX page items , enabling developers to build more intelligent, flexible, and user-friendly forms by driving Quick Pick values directly from database queries and runtime logic.  📑 Why Dynamic Quick Picks Are Needed   Static Quick Picks in Oracle APEX are useful for simple filtering, but Dynamic Quick Picks become essential when: Filter values must be generated at runtime based on current data, user role, or context Applications require data-driven filters instead of hardcoded values The same Quick Picks must adapt across multiple pages or regions Filter options depend ...
Read more

📌Track Active Tab switch in Region Display Selector without any plugins

-
Image
🚩Introduction  In Oracle APEX applications, Region Display Selector components helps to organize multiple regions efficiently. However, APEX does not provide a built-in declarative option to detect which tab is active when users switch between them, making it challenging to trigger conditional logic based on tab selection. This can be solved by creating the custom dyanamic action to capture the tab change. This approach enables dynamic actions like refreshing regions or executing custom logic whenever a tab becomes active, without requiring any plugins. 📑Why It is Essential to Track Tab Selection in Region Display Selector In APEX applications, pages often organize multiple regions under a Region Display Selector to separate content like Details, History, or Reports. While this improves layout, users actions on different tabs often require specific logic to run, such as refreshing a region, loading dynamic content, or updating page items. Without capturing which tab is active, de...
Read more