- Release notes
- Before you begin
- Managing access
- Getting started
- Integrations
- Working with process apps
- Working with dashboards and charts
- Working with process graphs
- Working with Discover process models and Import BPMN models
- Showing or hiding the menu
- Context information
- Export
- Filters
- Sending automation ideas to UiPath® Automation Hub
- Tags
- Due dates
- Compare
- Conformance checking
- Process simulation
- Root cause analysis
- Simulating automation potential
- Starting a Task Mining project from Process Mining
- Triggering an automation from a process app
- Viewing Process data
- Creating apps
- Loading data
- Transforming data
- Structure of transformations
- Tips for writing SQL
- Exporting and importing transformations
- Viewing the data run logs
- Merging event logs
- Configuring Tags
- Configuring Due dates
- Configuring fields for Automation potential
- Activity Configuration: Defining activity order
- Making the transformations available in dashboards
- Data models
- Adding and editing processes
- Customizing dashboards
- Publishing process apps
- App templates
- Notifications
- Additional resources
Process Mining
Description
Checks if the first field or expression value is equal to the second value.
-
Returns
trueif the field or expression values are equal. -
Returns
falseif the values are not equal.
Syntax
<Comparison field or Expression> = <Comparison field or Expression>
Supported values
All values can be used. Both values must be of the same kind.
NULL handling
NULL, the result is always NULL or unknown, not true or false.
Example
Actual date = Expected date
Description
Checks if the first field or expression value is equal to or greater than the second value.
-
Returns
trueif the first field or expression value is greater than or equal to the second value. -
Returns
falseif the first value is less than the second value.
Syntax
<Comparison field or Expression> >= <Comparison field or Expression>
Supported values
All values can be used. Both values must be of the same kind.
NULL handling
NULL, the result is always NULL or unknown, not true or false.
Example
Actual date >= Expected date
Description
Checks if the first value is greater than the second value.
-
Returns
trueif the first field or expression value is greater than the second value. -
Returns
falseif the first value is equal to or less than the second value.
Syntax
<Comparison field or Expression> > <Comparison field or Expression>
Supported values
All values can be used. Both values must be of the same kind.
NULL handling
NULL, the result is always NULL or unknown, not true or false.
Example
Actual date > Expected date
Description
Checks if the first field or expression value is equal to or less than the second value.
-
Returns
trueif the first field or expression value is less than or equal to the second value. -
Returns
falseif the first value is greater than the second value.
Syntax
<Comparison field or Expression> <= <Comparison field or Expression>
Supported values
All values can be used. Both values must be of the same kind.
NULL handling
NULL, the result is always NULL or unknown, not true or false.
Example
Actual date <= Expected date
Description
Checks if the first field or expression value is less than the second value.
-
Returns
trueif the first field or expression value is less than the second value. -
Returns
falseif the first value is equal to or greater than the second value.
Syntax
<Comparison field or Expression> < <Comparison field or Expression>
Supported values
All values can be used. Both values must be of the same kind.
NULL handling
NULL, the result is always NULL or unknown, not true or false.
Example
Actual date < Expected date
Checks if the first field or expression value is not equal to the second value.
-
Returns
trueif the values are not equal. -
Returns
falseif the first value is equal to the second value.
Syntax
<Comparison field or Expression> != <Comparison field or Expression>
Supported values
All values can be used. Both values must be of the same kind.
NULL handling
NULL, the result is always NULL or unknown, not true or false.
Example
Actual date != Expected date
Description
Checks if the first field or expression value matches one of the values in a specified list.
-
Returns
trueif the field or expression value matches either one of the expression, field, or contant values specified in a list values. -
Returns
falseif the field or expression value matches none of the specified values.
Syntax
<Field or Expression> IN <Expression or Field or Constant> [+<Expression or Field or Constant> + ...]
Supported values
All values can be used. Values must be of the same kind.
NULL handling
NULL, the result is NULL. NULL values in the list of values are not taken into account.
Example
Activity IN ("Create purchase order", "Create purchase order item"
Description
NULL.
-
Returns
trueif the field or expression value isNULL. -
Returns
falseif the value is notNULL.
Syntax
<Field or Expression> IS NULL
Supported values
All values can be used.
NULL handling
N/A
Example
Automated IS NULL
Description
NULL.
-
Returns
trueif the field or expression value is notNULL. -
Returns
falseif the value of isNULL.
Syntax
<Field or Expression> IS NOT NULL
Supported values
All values can be used.
NULL handling
N/A
Example
Automated IS NOT NULL
