Filter: create multiple filter rules that reference the same field (“AND” statements)

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:

To find out what plan, license type, or access you have, contact your Workfront administrator.

Create multiple filter rules that reference the same field

1. Go to a list of tasks.

2. From the Filter drop-down menu, select New Filter.

3. Click Switch to Text Mode.

4. Hover over the text mode area, and click Click to edit text.

5. 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
   

   TIP

   To build similar filters, build the first statement first. For example:

   name=green
   name_Mod=cicontains
   

   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:

   1. Precede the two copied lines with “AND:1:”, “AND:2:”, “AND:3:”, etc for each new field possible value.
   2. Replace the field line with the new field value (after the “=” sign).
   3. Replace the modifier line (_Mod) with the new modifier.

   These statements are case-sensitive.

6. Click Done, then Save Filter.