Follow
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 "Creating and Customizing Filters."

For more information about using conditional formatting in Views, see "Using Conditional Formatting in Views."
Filter and Condition Modifiers

For a list of built-in time frame modifiers, see "Built-In Time Frame 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 "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 field but the field has not yet been given a value.

Is Not Blank 

 isnotblank

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

 

 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.

 

 

 

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

 

 

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