Skip Navigation
Expand
Combining run time selectable filters
Answer ID 6006   |   Last Review Date 12/22/2019

Is it possible to combine filters to either an AND or OR search for different details?

Environment:

All versions, Analytics, Filters

Issue:

When combining two fields into one filter, we want to filter on an AND condition -- where both fields must meet the filter criteria. Also, what are options for an OR condition -- where the filter criteria needs to be in only one of the combined fields?

Resolution:

The following contains the formatting tips to properly structure Analytics filters when combining two fields into one filter:

OR condition for searching two fields where the filter input can be in either field to meet the selection criteria

AND
-- Selection1
-- Selection2
OR
-- Name  (contacts.firstname)
-- Name  (contacts.lastname)

AND condition for searching two fields where the filter input must be in both fields to meet the selection criteria

AND
-- Selection1
-- Selection2
-- Name (contacts.firstname)
-- Name (contacts.lastname)


For additional information, refer to the 'Edit a logical expression' section in the Online Help User Guide documentation. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.