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:

Adobe Workfront plan*

Any

Adobe Workfront license*

Plan

Access level configurations*

Edit access to Reports, Dashboards, Calendars

Edit access to Filters, Views, Groupings

Note: 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.

Object permissions

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.
 

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

On this page