Create OR statements in filters
The video explains how to create and use filters with multiple rules in Workfront. By default, Workfront uses “AND” between filter rules, meaning all conditions must be true for an item to appear in the list.
Alternatively, you can change the filter logic to “OR,” which displays items that meet any of the conditions.
The video also demonstrates creating filters for tasks using filter groups. For example, you can create two groups: one for incomplete tasks assigned to the creative team that are late, and another for incomplete tasks assigned to the creative team that are unassigned. Within each group, “AND” logic applies, meaning all conditions in the group must be met. The “OR” logic between groups ensures tasks meeting the conditions of either group are displayed.
OR filter activity
You want to find incomplete tasks that are assigned to you or that aren’t assigned to anyone. You set up a filter to look like the one below. Will this filter give you the results you want? Why or why not?
Answers
No, this filter will not provide the results you’re hoping for—tasks that aren’t finished that are either assigned to you or assigned to no one—because the filter rule for the task completeness is only on one side of the OR.
Instead, this filter will generate a list that shows:
- Tasks assigned to you that are not complete.
- PLUS (OR)
- All unassigned tasks, no matter what the status is.
The filter should look like the one below. Notice this filter has the filter rule for task completeness on both sides of the OR.