Filter and condition modifiers

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

(Case insensitive) 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.

cieq

(Case insensitive) 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.

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 text mode in filters, see Edit a filter using text mode.

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.

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 creating filters using text mode, see Edit a filter using text mode.

contains

(Case sensitive) Searches for the specified 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.

Does Not Contain

cinotcontains

(Case insensitive) It 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.

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.

Equal

in

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

eq

(Case sensitive) This returns only an exact 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 using text mode to create filters, see Edit a filter using 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%" 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.

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 filters for items that are missing the value specified.

For example, "notcontains inf" captures 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 text mode in filters, see Edit a filter using 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 text mode in filters, see Edit a filter using text mode.

Not Equal

notin

(Case sensitive) This is the 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.

(Case sensitive) This is the 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.

(Case insensitive) 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.