Скачать или смотреть Mastering Oracle APEX: Set Multiple Filtering Values in Interactive Reports

Learn how to effectively filter Interactive Reports in Oracle APEX 21.1 by combining values. This guide provides step-by-step instructions to achieve dual filters in a single column.
---
This video is based on the question https://stackoverflow.com/q/73272480/ asked by the user 'Mika Takaki' ( https://stackoverflow.com/u/17622685/ ) and on the answer https://stackoverflow.com/a/73273270/ provided by the user 'Littlefoot' ( https://stackoverflow.com/u/9097906/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: How to set two filtering values in one column of links in an interactive report? (Oracle Apex 21.1)

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Mastering Oracle APEX: Set Multiple Filtering Values in Interactive Reports

In the world of data reporting, creating interactive and dynamic filters is essential for enhancing user experience. If you are using Oracle APEX and need to filter data based on multiple criteria in an Interactive Report, you've landed on the right page. This guide will walk you through how to set two filtering values in one column of links in Oracle APEX 21.1, specifically focusing on the furry friends - cats!

The Problem: Filtering Two Values

Imagine you’ve crafted an Interactive Report featuring a list of cats, where each cat is defined by its unique fur color. Now, you want to create a link in this report that not only filters the second Interactive Report by the specific color of the selected cat but also ensures that the color white is always included in the filter criteria. This scenario can arise when you want to highlight or categorize specific groups of data based on multiple attributes.

The Solution: Combining Filtering Values

Step 1: Setting Up the Link

To begin, you will use the Link Builder to set up your link for the color filtering. Here’s how to do it properly:

Link Builder Configuration:

Name: IR_FUR_COLOR

Value: &P18_FUR_COLOR

This setup allows you to capture the selected fur color from the first Interactive Report.

Step 2: Modifying the Interactive Report Query

After establishing the link, you must adjust the query of the second Interactive Report to accommodate these filtering values. The WHERE clause should be modified to include both the color from the link and the static value of white. The query snippet should look like this:

[[See Video to Reveal this Text or Code Snippet]]

This simple, yet effective adjustment ensures that whenever a user clicks on a cat with a specific fur color, the second report will display results that include both that color and the color white. This strategy not only fulfills your requirement but also enhances the report's usability by diversifying the data presented.

Alternative Approach: Using a Hidden Item

In addition to the method above, you can explore another approach by leveraging a hidden item on the second page. Here’s how it works:

Create a Hidden Item for the fur color on the second report page.

Set its value to white.

Modify the WHERE clause like this:

[[See Video to Reveal this Text or Code Snippet]]

By using this alternative, you maintain the same functionality while keeping your query organized. The hidden item simplifies maintenance and updates to your filters in the future.

Conclusion

By effectively combining filtering values in your Oracle APEX Interactive Reports, you can create a richer and more informative user experience. Whether you choose the direct method or the hidden item approach, you now have the tools necessary to filter your reports dynamically, ensuring that indispensable colors like white are always included. Establishing these kinds of filters not only optimizes data presentation but also empowers users to easily navigate and derive insights from the information displayed.

Thank you for taking the time to enhance your skills with Oracle APEX! Happy reporting!