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:
However, you can create this filter using text mode.
You must have the following access to perform the steps in this article:
|Adobe Workfront plan*||
|Adobe Workfront license*||
Request to modify a filter
Plan to modify a report
|Access level configurations*||
Edit access to Reports, Dashboards, Calendars to modify a report
Edit access to Filters, Views, Groupings to modify a filter
If you still don’t have access, ask your Workfront administrator if they set additional restrictions in your access level. For information on how a Workfront administrator can modify your access level, see Create or modify custom access levels.
Manage permissions to a report
For information on requesting additional access, see Request access to objects .
To find out what plan, license type, or access you have, contact your Workfront administrator.
Go to a list of tasks.
From the Filter drop-down menu, select New Filter.
Click Switch to Text Mode.
Hover over the text mode area, and click Click to edit text.
In the Set Filter Rules for your Report area, add the following code:
name=green name_Mod=cicontains AND:1:name=red AND:1:name_Mod=cinotcontains
To build similar filters, build the first statement first. For example:
Copy 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:
These statements are case-sensitive.
Click Done, then Save Filter.