Filter Operations

Oomnitza's Search Pane, Workflow Begin Block, Connector Filtering, and Role Configuration allow for filters to be created, which define the sets of Objects that are affected or available by certain actions.

The actions available when creating a filter vary depending on the type of data being filtered. 

Available Filters:

Equals: 

Filters based on exact matches.

Supported by: Shorttext, Dropdown, Autocomplete, Longtext, Numeric, Decimal, Location, User list, Date, Stockroom, SaaS, Software, Checkbox

Not equals:

Filters based on absence of an exact match.

Supported by: Shorttext, Dropdown, Autocomplete, Longtext, Numeric, Decimal, Location, User list, Date, Stockroom, SaaS, Software, Checkbox

Begins with:

 Filters based on matching text at the beginning of a text-based field. 

Supported by: Shorttext, Dropdown, Autocomplete, Longtext, Numeric, Decimal, Location, User list, Stockroom, SaaS, Software

Does not begin with: 

Filters based on absence of matching text at the beginning of a text-based field. 

Supported by: Shorttext, Dropdown, Autocomplete, Longtext, Numeric, Decimal, Location, User list, Stockroom, SaaS, Software

< :

Less than.

Supported by: Numeric, Decimal, Date

<= :

Less than or equal to.

Supported by: Numeric, Decimal, Date

> :

Greater than.

Supported by: Numeric, Decimal, Date

>= :

greater than or equal to.

Supported by: Numeric, Decimal, Date

Contains: 

Filters based on a partial match within the text of a field.

Supported by: Shorttext, Dropdown, Autocomplete, Longtext, Numeric, Decimal, Location, User list, Stockroom, SaaS, Software

Does not contain: 

Filters based on the absence of a partial match within the text of a field.

Supported by: Shorttext, Dropdown, Autocomplete, Longtext, Numeric, Decimal, Location, User list, Stockroom, SaaS, Software

Ends with:

Filters based on matching text at the end of a text-based field. 

Supported by: Shorttext, Dropdown, Autocomplete, Longtext, Numeric, Decimal, Location, User list, Stockroom, SaaS, Software

Does not end with:

Filters based on absence of matching text at the end of a text-based field. 

Supported by: Shorttext, Dropdown, Autocomplete, Longtext, Numeric, Decimal, Location, User list, Stockroom, SaaS, Software

is Empty: 

Filters if a field is empty.

Supported by: Shorttext, Dropdown, Autocomplete, Longtext, Numeric, Decimal, Location, User list, Date, Stockroom, SaaS, Software

is not Empty: 

Filters for fields that are not empty. 

Supported by: Shorttext, Dropdown, Autocomplete, Longtext, Numeric, Decimal, Location, User list, Date, Stockroom, SaaS, Software

Days before: 

Filters for dates that are X days before the date populated in the field.

Supported by: Date

Day of: 

Filters for today's date.

Supported by: Date

Days after:

Filters for dates that are X days after the date populated in the field.

Supported by:Date

Has been changed: 

Filters for objects that have been changed. 

Supported by: Shorttext, Dropdown, Autocomplete, Longtext, Numeric, Decimal, Location, User list, Date, Stockroom, SaaS, Software, Checkbox

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk