Query a table

Use the Tables - Query a table action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. to query records in a table. You can also specify conditions to limit the results retrieved.

Note: The maximum number of rows you can query is 1000.

For more information about Nintex Tables, see Tables.

Configure the Tables - Query a table action

1. Add the action to the workflow and open the action configuration panel. For more information, see Add an action to the workflow.

2. Select the table you want to query in Table name.
3. Select the Columns from which you want to retrieve records.
   Important: 

   • The maximum number of Reference type columns you can select is five, but there is no limit to the number of other column types you can select.

   • All columns from the source table are available for selection. If the source table includes a Reference column, the columns from the referenced table are also available based on the reference field. These columns are displayed with the name of the reference column, followed by the source table’s columns within brackets.

4. Click Add condition to define conditions and specify which records to retrieve.

   The Condition builder panel is displayed.

5. Select the condition When and Operator values.

6. Specify the Value that must be matched.

7. In the Sort by field, select a column you want to sort the query results by and select Ascending or Descending as the sort order.

   You can sort by the Created date and Modified date columns, or columns with sorting enabled. For more information, see Column sorting.

8. Specify the number of rows to return in Row limit.

9. Create or select a variable to store the action output in Result.

Tables - Query a table action fields and settings

Section	Field	Description	Variable types
Table	Table name	The name of the table to query.	Text, Decimal, Integer, Boolean, DateTime, Collection
	Columns	The columns to query. Important:  The maximum number of Reference type columns you can select is five, but there is no limit to the number of other column types you can select. All columns from the source table are available for selection. If the source table includes a Reference column, the columns from the referenced table are also available based on the reference field. These columns are displayed with the name of the reference column, followed by the source table’s columns within brackets.	(n/a)
Conditions	Add conditions/Edit conditions	Define conditional statements to use for the query. Displays the condition builder to define new conditions or edit existing conditions. Add conditions - Displayed when there are no existing conditions specified for the action. Edit conditions - Displayed when there are existing conditions set for the action. You can edit the conditions. The Condition builder supports nested conditions, enabling you to create conditions within another condition. For more information the condition builder and the fields, see Condition builder.	(n/a)
Sorting	Sort by	Sort the results in ascending or descending order. The columns displayed in the drop-down list are associated with the table you select and only the columns you can sort by are displayed. You can sort by the Created date and Modified date columns, or columns with sorting enabled. For more information, see Column sorting.	Text, Decimal, Integer, Boolean, DateTime, Collection
	Row limit	The maximum number of rows to return from the query. Note: The maximum number of rows you can query is 1000.	Integer
Output	Result	Stores the result of the action as an object with the following variables: Number of rows returned: (Integer) The total number of rows retrieved from this query. Row ID(s): (Collection) The ID(s) of all the returned rows. Table ID: (Text) The ID of the Tables that's queried. Rows: (Collection) Collection of objects with all rows. First row: (Object) The properties of the first row in the query.	Object