DocumentationWorkfrontWorkfront Guide

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

Last update: Tue May 23 2023 00:00:00 GMT+0000 (Coordinated Universal Time)

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:

Adobe Workfront plan*
Any
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

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:

    code language-none 
    name=green
name_Mod=cicontains
AND:1:name=red
AND:1:name_Mod=cinotcontains
    note tip
    TIP
    To build similar filters, build the first statement first. For example:
    code language-none 
    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.

recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43