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 online documentation for the version your site is currently running. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.

Available Languages for this Answer:

Notify Me
The page will refresh upon submission. Any pending input will be lost.