- Query List
- Add action
- Configure action
- Action properties
|List||List or document library to which query will be applied.|
|Filter||Expression to filter items.
There are two options to build filter expression:
There two ways to select items available for Query builder:
Filter expression for OData filter editor is a string in OData format.
|Sort||Order in which selected items will be returned.
Allows to set sequence of the sort rules.
|Maximum number of rows||Maximum number of items which will be returned as result of the query.|
|Output type||Format of the returned value.
There are options:
Choose Single output to store query result in a single variable specified in Output property.
|Column to select||Columns which will be returned by query.|
|Output||Variable where result of the query will be stored at workflow runtime. Only variables of Collection type are available for this property.
If output type is Single output, there will be only one Output propery.
If output type is Separate output per column, there will be an Output propery for each column.
|Items count||Variable to store number of returned items. Only variables of Integer type are available for this property.|