Collapse
Submit a Service Request
Contact Information for Technical Support
My Service Notifications
Behavior of multiple filters in a report
Answer ID 8868 |
Last Review Date 12/18/2018
Can I have multiple duplicate filters in a report?
Environment:
Analytics / Reports
Oracle B2C Service, All versions
Issue:
I have a report with multiple filters on the same column, each with different values. We are unsure how is it processing those filters.
Resolution:
While it is possible, we recommend that you do not, as it may cause unexpected behavior.
In general, a report will utilize the most restrictive values from all filters. However, if any of the filters has the "Make this filter selectable at run time" option disabled, the report will utilize that filter, even if it is less restrictive than the run-time-selectable filter.