Using the WHERE clause in List All Records activities

Overview

UiPath uses a generic pattern for activities such as List All Records in Integration Service activities. In List All Records, a Where clause is available to allow for more advanced filtering.

Note:

Not all List All Records activities include a Where property. Availability depends on each connector.

Older versions of Integration Service activity packages may also include List Record activities. List Record has been deprecated and replaced with List All Records. We recommend you always use the latest package version available.

Using the WHERE property

The Where clause, or the CEQL search expression, provides a standard way to search across records. The Where clause specifies what to search and what objects to return in our result set.

A Where clause has three components:

• The left­hand side (LHS) element of the condition
• The operator
• The right­hand side (RHS) element of the condition

1. Add a List All Records activity to your workflow.

2. Select the object from the dropdown menu.

3. Use the Manage Properties option to view any additional fields available for the selected object. These may include:

   • Max records - Defines the maximum number of records to return.
   • Order by or Sort by- The order in which results should be sorted.
   • Where - The CEQL search expression, or the where clause, without the WHERE keyword, in a typical SQL query.

Valid operators

You can use the following operators inside a Where clause:

• AND - TRUE if all the conditions separated are TRUE
• OR - TRUE if any of the conditions separated are TRUE
• = - Equal to
• != - Not equal to
• < - Less than
• > - Greater than
• <= - Less than or equal to
• >= - Greater than or equal to
• LIKE - TRUE if the operand matches a pattern
• IN - TRUE if the operand is equal to one of a list of expressions
• IS NULL - TRUE if a NULL value is found
• LIMIT - Limit the number of records to the specified number