Condition values act as operators such as equals, not equals, is more than, is less than, contains, does not contain, and so on. Both the Condition and data Value lists are constrained by the Column data type. 

in

Select documents that match one or more values specified in the Value field.

not in

Select documents that do not match one or more values specified in the Value field.

is empty

Select documents with one or more property attributes that are empty.

is not empty

Select documents with one or more property attributes that are not empty.

on

Select documents that have a matching date.

on or before

Select documents that have a date that is before the date specified in the Value field.

on or later

Select documents that have a date that is after the date specified in the Value field.

equals

Select documents that have an exact matching value specified in the Value field.

not equals

Select documents that do not exactly match a value specified in the Value field.

is more than

Select documents that have a value greater than the numeric value specified in the Value field.

is less than

Select documents that have a value less than the numeric value specified in the Value field.

is at least

Select documents that have a value equal to or greater than the numeric value specified in the Value field.

is at most

Select documents that have a value equal to or less than the numeric value specified in the Value field.

contains

Select documents that contain the text specified in the Value field.

is

Select documents that exactly match the text specified in the Value field.

does not contain

Select documents that do not contain the text specified in the Value field.

contains any

Select documents that contain any of the values specified in the Value field.

contains all

Select documents that contain all of the values specified in the Value field.

does not contain any

Select documents that do not contain any of the values specified in the Value field.

does not contain all

Select documents that do not contain all of the values specified in the Value field.

 Multi-user Considerations  

• You can also use the "is empty" or "is not empty" to filter documents by check out status. For example, as an administrator, you may want to create a view that lists all documents that are checked out by any author. To do this, you can create a filter that selects documents that have the Checked Out By column that is "not empty".

Table of Contents