Filter: create multiple filter rules that reference the same field (“AND” statements)
- Topics:
- Reports and Dashboards
CREATED FOR:
- User
In the standard mode interface, when attempting to create multiple filters that reference the same field (using the AND qualifier), one of the filters is deleted when you save the report and exit the report builder.
Example: You might want to view only tasks that contain the word “green” but do not contain the word “red” in the name. Adobe Workfront does not allow you to save the following filter rules using the standard mode interface because it references the same field (Task Name) but uses different modifiers and refers to different values:
- Task Name > Contains > Green
- Task Name > Does Not Contain > Red
However, you can create this filter using text mode.
Access requirements
You must have the following access to perform the steps in this article:
New:
-
Contributor to modify a filter
-
Standard to modify a report
Current:
-
Request to modify a filter
-
Plan to modify a report
Edit access to Reports, Dashboards, Calendars to modify a report
Edit access to Filters, Views, Groupings to modify a filter
*For information, see Access requirements in Workfront documentation.
Create multiple filter rules that reference the same field
-
Go to a list of tasks.
-
From the Filter drop-down menu, select New Filter.
-
Click Text Mode.
-
In the box displayed, add the following code:
name=green name_Mod=cicontains AND:1:name=red AND:1:name_Mod=cinotcontains
TIPTo build similar filters, build the first statement first. For example:name=green name_Mod=cicontainsCopy and paste the statement as many times as needed. You can then add as many statements as you need to reference the same field (in our case “name”) and make the following modifications to the additional statements:- Precede the two copied lines with “AND:1:”, “AND:2:”, “AND:3:”, etc for each new field possible value.
- Replace the field line with the new field value (after the “=” sign).
- Replace the modifier line (_Mod) with the new modifier.
These statements are case-sensitive. -
Click Apply, then Save as new.