Filter and condition modifiers

The filter and condition modifiers allow you to build filters and establish conditions for formatting your report results.

For more information about building filters, see the article Filters overview.

For more information about using conditional formatting in Views, see the article Use conditional formatting in views.

Filter and condition modifiers

Some modifiers are built-in and you can choose them from a drop-down menu inside your filter or conditional formatting statement. Other modifiers can only be used in text mode filters.

For more information about understanding text mode, see Text Mode overview.

For a list of built-in time frame modifiers, see the article Filter reports by time frames.

You can use the following condition modifiers in filters and conditional formatting statements:

Built-in Modifier
Text Mode Modifier
Description
Is Blank
blank
The field exists for the object but the field does not currently have a value.
Is Not Blank
notblank
The field you are filtering for exists and has been given a value.
null

The field is either blank, or does not exist. For example, you want to look for items without a parent task ID. This means that you want to see only standalone tasks. The qualifier for the "parent task ID" would be null, since a task without an ID (in this case the parent) does not exist.

This modifier can only be used in text mode filters. For more information about text mode in filters, see Edit a filter using text mode.

notnull

The field that you are filtering for exists and contains a value other than null.

This modifier can only be used in text mode filters. For more information about text mode in filters, see Edit a filter using text mode.

Contains
cicontains

This is the case insensitive version of contains. For example: cicontains inf captures any value that contains either Inf or inf.

Note: Adobe Workfront searches for the exact word or phrase that you are specifying for each filter statement. For example, if you are searching for any project that contains the phrase new project in the name, Workfront does not display projects that have just new or just project, or new main project in the name. The filter finds only projects with the exact phrase new project in the name.

Does Not Contain
cinotcontains

This is the case insensitive version of notcontains.

This modifier filters for items that are missing the value specified.

For example, does not contain inf captures anything without Inf or inf in the name.

Note: If the field you are filtering for has multiple options, this filters out the results that contain both the choice you specify, as well as the choice you specify and any additional choices.

contains

Searches for the specified case sensitive text throughout an entire text string.

For example, using contains Inf captures anything with Inf in it, such as the word Infinity.

This modifier can only be used in text mode filters.For more information about text mode in filters, see Edit a filter using text mode.

notcontains

It filters for items that are missing the case sensitive value specified.

For example, notcontains inf captures anything without inf, but it displays values that contain Inf.

This modifier can only be used in text mode filters. For more information about text mode in filters, see Edit a filter using text mode.

cieq

This is the case insensitive option of eq. It only returns an exact match of the searched value.

For example, when searching for a task with a specific name, task name cieq test finds tasks where the name is Test, TEST, or Test, but it does not find a task with the name test 123.

This modifier can only be used in text mode filters. For more information about text mode in filters, see Edit a filter using text mode.

cine

This is the case insensitive option of ne, and it is the opposite of the cieq modifier. It only returns results that are not an exact match of the searched value, not taking in account the case of the value.

For example, cine returns any values that do not equal either "current" or "Current".

This modifier can only be used in text mode filters. For more information about text mode in filters, see Edit a filter using text mode.

eq

This modifier returns only an exact, case sensitive match of the searched value.

For example, when searching for complete projects, eq CPL returns all projects in the Complete status. eq CPL, CUR does not return a result because a project cannot be complete and current at the same time.

This modifier can only be used in text mode filters. For more information about text mode in filters, see Edit a filter using text mode.

ne

This is the case sensitive opposite of eq. It returns only results that are not an exact match of the searched value, and it also matches the case of the value.

For example, ne returns any values that do not equal "Current", but it does not return any values that do not equal "current".

This modifier can only be used in text mode filters. For more information about text mode in filters, see Edit a filter using text mode.

ciin

This is the case insensitive version of in.

This modifier can only be used in text mode filters. For more information about text mode in filters, see Edit a filter using text mode.

cinotin

This is the case insensitive version of notin.

This modifier can only be used in text mode filters. For more information about text mode in filters, see Edit a filter using text mode.

Equal
in

This modifier allows you to create a comma-separated list of case sensitive variables to compare to a single attribute evaluated in a filter. The entire list is treated as an OR statement and returns any results that meet the criteria of one or more of the variables.

For example, when searching for projects, using in CUR, PLN, CPL returns all projects that are in the Current, OR Planning, OR Complete status.

The built-in modifier Equal corresponds to the text mode modifier of in. This means that you can choose Equal with multiple values for the field.

For example, you are able to choose a "Status equals Current, Planning, Dead" in a project report and you can view projects in any of these statuses.

Not Equal
notin

This is the case sensitive opposite of in. It returns only results not in the specified list.

This modifier can only be used in text mode filters. For more information about text mode in filters, see Edit a filter using text mode.

Note: If the field you are filtering for has multiple options, this filters out the results that contain both the choice you specify, as well as the choice you specify and any additional choices.

cilike

This is the case insensitive version of like. For example: cilike %Current% %Dead% returns any notes that contain Current to Dead or current to dead.

This modifier can only be used in text mode filters. For more information about text mode in filters, see Edit a filter using text mode.

like

This modifier searches for portions of a case sensitive text string in similar fashion to contains. However, like provides the ability to insert wild card characters to break up the text.

For example, when searching for notes, using like %Current% %Dead% returns any note that contains the phrase "Current to Dead". It does not include any notes that contain "Dead to Current". Each value is searched in the order it is listed. The % represents a wild card to replace characters or segments of text.

This modifier can only be used in text mode filters. For more information about text mode in filters, see Edit a filter using text mode.

Does Not Exist
NOTEXISTS

This modifier is used only with complex filters in an EXISTS statement. These filters refer only to the following objects:

  • Objects that span multiple levels in the object hierarchy
  • Objects that are missing

For information about creating complex filters using EXISTS statements see the article Create Complex Text-Mode Filters Using EXISTS Statements. This is the only modifier used in EXISTS statements.

Greater Than
gt
This searches for all results with a value greater than the value entered, not including the entered value.
Less Than
lt
This searches for all results with a value less than what is entered, not including the entered value.
Greater Than Equal
gte
This searches for all results with values greater than or equal to the entered value.
Less Than Equal
lte
This searches for all results with a value less than or equal to the entered value.
Between
between
Provides two required field values and searches for all results within range of both fields, including the entered values.
notbetween

This is the inverse of between. It provides two required value fields and searches for all results outside the range of both fields including the entered values.

This modifier can only be used in text mode filters. For more information about text mode in filters, see Edit a filter using text mode.

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