🎯 Oracle APEX 26.1 New Feature: Exclude Values in Faceted Search

-

🚩Introduction 

  • In Oracle APEX 26.1, a new enhancement is introduced in the Faceted Search which allows users to exclude specific facet values in the filtering the reports. Instead of selecting the required values in the facet, user can now exclude the unwanted values from the results. This makes filtering easier and gives users more control when working with large amounts of data.

  • This feature makes reports searching easier and more flexible. It helps users quickly find the information they need. It also allows developers to build more interactive and user-friendly Oracle APEX applications.

📑 Why This Approach Is Needed

In Oracle APEX applications, users often work with large reports and need an easier way to filter data. In earlier versions, users can only select the values they wanted to include, which sometimes made searching less flexible and more time consuming.

With Oracle APEX 26.1, the new Faceted Search enhancement allows users to directly exclude specific values from report results. This makes filtering easier and helps users quickly focus on the information they actually need. This becomes useful when:

  • Users can easily remove unwanted values instead of selecting many required values

  • Large reports need faster and more flexible filtering options

  • Reports should show more accurate and useful results

  • Applications should help users work faster and search more efficiently

  • A simple and user-friendly filtering experience is important 

This feature makes it easier for users to filter and find the right data in reports. It reduces extra steps and provides a smoother and more user-friendly experience in Oracle APEX applications.

👉 Use Case: Excluding Facet Values in Oracle APEX 26.1 Faceted Search

In Oracle APEX 26.1, users often work with large reports and need an easier way to filter data using Faceted Search. In many cases, it is more convenient to remove unwanted values instead of selecting only the values they want to see. This helps users filter data faster and view more relevant results with less effort.

In this blog, we will see how the new Faceted Search enhancement in Oracle APEX 26.1 allows users to directly exclude specific facet values while filtering reports. This feature makes searching simpler, improves report filtering, and provides a better user experience in Oracle APEX applications.

Step 1: 

In the page designer, create a region and change the type to Classic Report and set the source type as SQL query and copy the SQL Query below.

 Step 2: 

Create a region and select the type as Faceted Search and in the source section, select the classic report which we created in the previous step in the Filtered Region propery. Select the Blank with Attributes in the Template property under the Appearance section. Set the column span to 2 under the layout section.

Step 3: 

By default, search facet will be created in the Faceted Search region. Create another Facet in the Faceted Search region and change the type to Checkbox Group. Enter the value Job in the Facet Label and select Distinct Values in the Type attribute, under the List of Values section.

Step 4:

Now go to the List Entries section and check the Allow to Exclude option, this is the main setup you need to do to use this new exclusion feature.

Step 5: 

Now under the Source section, enter the column value JOB in the Database column and select the respective datatype column. No go to the Classic Report column and uncheck the Start New Row checkbox, to make the Faceted Search region and classwic report in the same row.

Step 6: 

Now save and run the page, you will see the Faceted Search with classic report region. The Facets will be rendered on the left side of the screen. Hover on the Facet value, you will see the icon on the righside and click on the icon to exclude that value from the report.

🔥 Conclusion

Thus, Oracle APEX 26.1 makes Faceted Search more flexible by allowing users to exclude unwanted values while filtering reports. This helps users filter data more easily and quickly find the information they need with fewer steps. It also improves the experience of working with large reports and helps developers create more user-friendly Oracle APEX applications. 

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