The Query List action allows for list item data queries and stores the results in a workflow variable. The action performs a CAML site data query.
To use the workflow action:
Alternatively
To change the settings used by the action:
For more information on the other options in the drop-down, please refer to the Getting started with the Nintex Workflow designer.
Choose whether to use the UI to build the query, or edit the CAML manually.
In Query builder mode, the following elements will build the query:
Select the list to query data from. Lists in the current team site are displayed.
Check this option to query for items within folders and subfolders.
The criteria that nominated list items must match in order to be selected.
The order in which selected values should be returned.
This option ensures that the inserted tokens will be encoded and is able to support special characters.
Include HTML formatting in rich text columns: This option determines how a value queried from a rich text field is returned. When this option is selected, the HTML mark-up from the field will be preserved. When this option is not selected, HTML mark-up is removed, leaving only the text.
Specify item limit: Specify the maximum number of items to be returned from the query.
The field to retrieve the data from. More than one field can be selected.
Note: If a variable that is not a collection is selected, only the first result will be stored.
When CAML editor is selected, the query can be run on either the current site or an alternate site to the one the workflow is running in.
To query an alternative site, select the Alternative site option and enter the Site URL to a SharePoint site. The site must exist in the same farm as the workflow, but can be in a different site collection or web application.
When the Alternative site is selected, the Query builder mode is disabled.
Include HTML formatting in rich text columns: This option determines how a value queried from a rich text field is returned. When this option is selected, the HTML mark-up from the field will be preserved. When this option is not selected, HTML mark-up is removed, leaving only the text. For more information about CAML queries and Site Data queries, see the SharePoint SDK.
Specify item limit: Specify a number of items to be returned from the query.
Field: The field to retrieve the data from. More than one field can be selected.
1. Select the required field to retrieve the data from and click Add.
2. Specify a workflow variable to store the values selected from the field query.
Note: If a variable that is not a collection is selected, only the first result will be stored.