Query List

The Query List action A feature that supplies the instructions in a botflow. queries a list and puts the results in a new list in a botflow A file that stores the actions and variables designed to automate tasks..

Using the Query List action, you can get a list information from:

  • A list of imported data.
  • Within a list in a botflow.

Some examples of applications for the Query List action:

  • Create a new list from lists created in the Nintex RPA Botflow pane.
  • Update an existing list with items extracted from a list created using the Create List action.

Add a Query List action to a botflow

This example provides the steps necessary to add a Query List action to a botflow.

To add a Query List action to a botflow:

  1. On the Actions List, click Lists and then click Query List from the List list.

    2. The Action Builder window for Query List displays.

  2. Set the Query List settings:

    3. General

    • List: Type a list name to be queried in the List field.
    • Column: Select a column option from the drop-down.
      • Any Column: The query rule is evaluated in each column of the row.
      • Exact Column: The query rule is evaluated in the column specified.
    • Save to: Type a list name to save the queried results to in the Save to field.
    • Overwrite: Select the check box to overwrite a list with the same name.

    Options

    • Rule 1: Select the required rule value from the drop-down and type in the corresponding value.
    • And/Or: Select the check box to enable an and/or condition and Rule 2 selection.
      • And: The conditions of both rules must be met for the query results.
      • Or: One condition of either rule must be met for the query results.
    • Rule 2: Select the required rule value from the drop-down and type in the corresponding value.

  3. If needed, adjust the Run Error Task settings to fine tune how the action runs.
  4. If needed, adjust the Run Switch setting to create the action without running it.
  5. Optionally, add an action note.
  6. Click OK to add the Query List action to the botflow.
Field or button Description
Query List Options/Settings General

  • List: Type a list name to be queried in the List field, select a list from the drop-down, or use the Expression Builder to build the action settings using variable or other token values.
  • Column: Select a column option from the drop-down.
    • Any Column: The query rule is evaluated in each column of the row.
    • Exact Column: The query rule is evaluated in the column specified. Type a list column name to be queried in the Column field, select a list column from the drop-down, or use the Expression Builder to build the action settings using variable or other token values.
  • Save to: Type a list name to save the queried results to in the Save to field, select a list from the drop-down, or use the Expression Builder to build the action settings using variable or other token values.
  • Overwrite: Select the check box to overwrite a list with the same name.

Options

  • Rule 1: Select the required rule value from the drop-down and type in the corresponding value, or use the Expression Builder to build the action settings using variable or other token values.
    • Equal to: The two items are equal.
    • Not equal to: The two items are not equal.
    • Containing: The first item contains the second item.
    • Not containing: The first item does not contain the second item.
    • Less than: The first item is less than the second item.
    • Less than or equal to: The first item is less than or equal to the second item.
    • Greater than: The first item is greater than the second item.
    • Greater than or equal to: The first item is greater than or equal to the second item.
    • Beginning with: The first item begins with the second item.
    • Ending with: The first item ends with the second item.
    • Not beginning with: The first item does not begin with the second item.
    • Not ending with: The first item does not end with the second item.
    • Is blank: The item to compare is blank.
    • Is not blank: The item to compare is not blank.
  • And/Or: Select the check box to enable an and/or condition and Rule 2 selection.
    • And: The conditions of both rules must be met for the query results.
    • Or: One condition of either rule must be met for the query results.
  • Rule 2: Select the required rule value from the drop-down and type in the corresponding value, or use the Expression Builder to build the action settings using variable or other token values.
    • Equal to: The two items are equal.
    • Not equal to: The two items are not equal.
    • Containing: The first item contains the second item.
    • Not containing: The first item does not contain the second item.
    • Less than: The first item is less than the second item.
    • Less than or equal to: The first item is less than or equal to the second item.
    • Greater than: The first item is greater than the second item.
    • Greater than or equal to: The first item is greater than or equal to the second item.
    • Beginning with: The first item begins with the second item.
    • Ending with: The first item ends with the second item.
    • Not beginning with: The first item does not begin with the second item.
    • Not ending with: The first item does not end with the second item.
    • Is blank: The item to compare is blank.
    • Is not blank: The item to compare is not blank.
Run error task
  1. Click Run error task.
  2. Open the On Error drop-down list and select the required setting:
    • Run error task: A botflow containing an error task automatically runs the error task in the event of an error. If the botflow does not contain an error task, the botflow stops in the event of an error.
    • Stop on error: The botflow stops in the event of an error.
    • Ignore errors: The action is skipped in the event of an error and the botflow attempts to execute the next action
  1. Click X to close the drop-down and save the setting.
Note

(Optional) Type a Note to document any special instructions or functionality.    
Run Switch

The Run Switch toggle controls how Nintex RPA runs an action when adding or editing an action in a botflow.

  • Run: To run the action automatically when you click OK, turn the toggle to Run.

  • Don't Run: If you do not want to run the action automatically when you click OK, turn the toggle to Don't Run.
OK/Cancel Click OK to save the action or click Cancel to discard the action or any changes.