Filter Operators
Ambition's metric builder offers the following operators when constructing metric logic.
If using an API/FTP/File Upload, or Manual Entry integration, the last column offers a guide to which Ambition Field Types correlate to each available operator.
Available Operator | Usage Guidelines | Compatible Ambition Field Types |
Equals |
Use for an exact match. Specify a single value or multiple values separated with the delimiter ":::". Filter is case-sensitive. |
Email, Dimension, Number, Unique Employee Identifier, Unique Record Identifier |
Not Equal To |
Use to exclude records that do not match the specific value. Specify a single value or multiple values separated with the delimiter ":::". Filter is case-sensitive. |
Email, Dimension, Number, Unique Employee Identifier, Unique Record Identifier |
Contains |
Use to include records that contain the value anywhere in the field. Specify a single value or multiple values separated with the delimiter ":::".. Filter is case-sensitive. |
Email, Dimension, Unique Employee Identifier, Unique Record Identifier |
Does Not Contain |
Use to exclude records that contain the value anywhere in the field. Specify a single value or multiple values separated with the delimiter ":::".. Filter is case-sensitive. |
Email, Dimension, Unique Employee Identifier, Unique Record Identifier |
Regular Expression |
Use to match patterns or partial words, whole words, or even multiple words. We advise only using if you're familiar with Regular Expression syntax. |
Email, Dimension, Unique Employee Identifier, Unique Record Identifier |
Is Blank |
Use to include records that do not contain any value. Within the Metric Builder, no value is needed to be input in the "Value" field when the "Is Blank" operator is used. |
Email, Dimension, Date, Date/Time, Number, Unique Employee Identifier, Unique Record Identifier |
Is Not Blank |
Use to exclude records that do have a value. Within the Metric Builder, no value is needed to be input in the "Value" field when the "Is Not Blank" operator is used. |
Email, Dimension, Date, Date/Time, Number, Unique Employee Identifier, Unique Record Identifier |
Starts With |
Use to include only records that begin with the value in the filter. Narrower search then "Contains". Filter is case-sensitive. |
Email, Dimension, Unique Employee Identifier, Unique Record Identifier |
Ends With |
Use to include only records that end with the value in the filter. Narrower search then "Contains". Filter is case-sensitive. |
Email, Dimension, Unique Employee Identifier, Unique Record Identifier |
Greater Than |
Use to include records that are greater than the specific value. Specify a single value. |
Number |
Greater Than or Equal to |
Use to include records that are greater than or equal to the specific value. Specify a single value. |
Number |
Less Than |
Use to include records that are less than the value you enter. Specify a single value. |
Number |
Less Than or Equal to |
Use to include records that are less than or equal to the value you enter. Specify a single value. |
Number |
Comments
0 comments
Please sign in to leave a comment.