Follow
Creating and Customizing Filters

You can customize existing Filters, create new Filters based on existing Filters, or create new Filters from scratch. 

Your access dictates how filters are saved. If you created the filter originally, you have the ability to save the changes, otherwise you are prompted to save a version. Keep in mind if you make changes to a filter you have shared with others the changes impact them as well. 

Creating or Customizing a Filter

Customize an Existing Filter

  1. Navigate to the report that contains the Filter that you want to customize.
  2. Click the Filter drop-down list.

  3. Select the Filter that you want to customize, then click Customize Filter.
  4. The interface builder for customizing the Filter is launched.
  5. Do any of the following:
    • Modify existing filter rules by clicking the existing rule and selecting a new option.
    • Add a filter rule by clicking Add another Filter Rule, begin typing the name of the option for which you want to add a rule, then click it when it appears in the drop-down list.
      When adding filter rules, use the filter modifiers to establish the condition of your filter. For more information about filter modifiers, see "Filter and Condition Modifiers."
    • Delete an existing filter rule by clicking the 'X' icon.
  6. Click Save Filter to replace the current Filter with your changes.

Creating a New Filter Based on an Existing Filter

  1. Navigate to the report that contains the Filter that you want to use as the basis for your new Filter.
  2. Click the Filter drop-down list.

  3. Select the Filter that you want to use as the basis for your new Filter.
  4. Click the Filter drop-down list, then click Customize Filter.
    The interface builder for customizing the Filter is launched.
  5. Do any of the following:
    • Modify existing filter rules by clicking the existing rule and selecting a new option.
    • Add a filter rule by clicking 'Add another Filter Rule,' begin typing the name of the option for which you want to add a rule, then click it when it appears in the drop-down list.
    • Delete an existing filter rule by clicking the X icon.
  6. Click Save as New Filter to save your changes as a new Filter.

Creating a New Filter From Scratch

  1. Navigate to the report where you want to create your new report.
  2. Click the Filter drop-down list.

  3. Click New Filter.
    The interface builder for customizing the Filter is launched.
  4. Do either of the following:
    • Modify existing filter rules by clicking the existing rule and selecting a new option.
    • Add a filter rule by clicking Add another Filter Rule, begin typing the name of the option for which you want to add a rule, then click it when it appears in the drop-down list.
    • Delete an existing filter rule by clicking the (x) icon.
  5. Click Save Filter.

Creating a New Filter Using the Text Mode Interface

You can build filters using the text mode interface. We recommend to build most of the filter statements using the standard interface, and to edit the code of the filter only as a final step. Building a filter from scratch using the text mode interface alone is not recommended. 

For more information about creating a new filter using the text mode interface, see the "Editing Text Mode in a Filter" section in "Understanding Text Mode."

NOTE When building a filter in text mode and filtering for field values that contain commas, you must add a slash ("/") before the commas separating the values, to ensure that the value is read as one filter option. This only applies for the following field types:

  • Dropdowns
  • Radio Buttons
  • Checkboxes

For example, you have a radio button field on a project called "Color" and the options for it are:

  • Red
  • Blue
  • Red, blue

If you want to build a filter that would find only projects where the third option is selected, the filter statement in the text mode interface should be:

DE:check=red/, blue
DE:check_Mod=in

This syntax ensures that the values are read together, as one option. If you omit the slash, Workfront reads the comma as an 'OR', in which case only the projects that have either the first or the second option would be selected. 

This syntax also applies when building prompts. For more information about using prompts, see "Working with Prompts."

Removing a Filter

The ability to remove a filter functions differently depending on whether you initially created the filter, or the filter was shared with you. You cannot remove a default filter.

  • If you created the filter and you remove it, the filter is removed from the Workfront system. The filter is no longer available to any users who you previously shared it with.
  • If the filter was shared with you and you remove it, the filter is removed only for you. The user who originally created it and any other users it has been shared with still have access to the filter.

To remove a filter:

  1. In the Filter drop-down menu, click Remove Filter.
    The My Filters dialog box is displayed.

    All filters that you have rights to remove are available to remove. Other filters are displayed as dimmed.
  2. Click the (x) next to any filters you want to remove, then click Done.