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 "Understanding Text Mode."

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 has not yet been given 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 understanding text mode, see "Understanding 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 understanding text mode, see "Understanding Text Mode."

Contains

cicontains

(Case insensitive) This is the case insensitive version of contains. For example: 'contains inf' will capture any value that contains either "Inf" or "inf".NOTE 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.

cieq

(Case insensitive) This is the case insensitive option of eq. It will only return an exact match of the searched value.

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

This modifier can only be used in text mode filters. For more information about understanding text mode, see "Understanding Text Mode."

ciin

(Case insensitive) This is the case insensitive version of in.

This modifier can only be used in text mode filters. For more information about understanding text mode, see "Understanding Text Mode."

cilike

This is the case insensitive version of like. For example: 'cilike %Current% %Dead%' will return 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 understanding text mode, see "Understanding Text Mode."

cinotin

(Case insensitive) This is the case insensitive version of notin.

This modifier can only be used in text mode filters. For more information about understanding text mode, see "Understanding Text Mode."

contains

(Case sensitive) Searches for the specified text throughout an entire text string.

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

This modifier can only be used in text mode filters. For more information about understanding text mode, see "Understanding Text Mode."

Does Not Contain

cinotcontains

(Case insensitive) It will filter for items that are missing the value specified.

For example, 'does not contain inf' will capture anything with 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 only the choice you specify. If the field contains additional options including the one specified, those results are not filtered from the report.

Does Not Exist

NOTEXISTS

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

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

For example, when searching for projects, using 'in CUR, PLN, CPL' will return 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 will see projects in any of these statuses.

eq

(Case sensitive) This will only return an exact match of the searched value.

For example, when searching for complete projects, 'eq CPL' will return all projects in the complete status. 'eq CPL, CUR' will 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 understanding text mode, see "Understanding Text Mode."

Greater Than

gt

This searches for all results with a value greater than the value entered, not including the entered value.

like

(Case sensitive) Searches for portions of a 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%' will return any note that contains the phrase "Current to Dead". It will 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 understanding text mode, see "Understanding Text Mode."

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.

notcontains

(Case sensitive) It will filter for items that are missing the value specified.

For example, 'notcontains inf' will capture anything with without 'inf', but it displays values that contain 'Inf.'

This modifier can only be used in text mode filters. For more information about understanding text mode, see "Understanding Text Mode."

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 understanding text mode, see "Understanding Text Mode."

Not Equal

notin

(Case sensitive) This is the inverse of in. It will only return results not in the specified list.

This modifier can only be used in text mode filters. For more information about understanding text mode, see "Understanding Text Mode."

NOTE If the field you are filtering for has multiple options, this filters out the results that contain only the choice you specify. If the field contains additional options including the one specified, those results are not filtered from the report.

***

This is temporary - Lilit is fixing this in a future story: NOTE If the field you are filtering for has multiple options, this filters out the results that contain only the choice you specify. If the field contains additional options including the one specified, those results are not filtered from the report. See this document and search for "not equal" for the link to the req doc: https://docs.google.com/document/d/1WA0zZ_wws-2qb908i53BFQ8zDwL3nPJHyIybtJvvnqU/edit

Thank you for taking the time to provide feedback. We appreciate and value your contribution to our site. Feedback provided here is regularly reviewed by our Product Documentation team. Please ensure your comments are specific to improving this help article. Any questions or requests outside this help article content should be directed to our Community User Forum or by submitting a ticket to customer support.