Query
The Query activity retrieves the entries that match the filter string or criteria specified in the datagrid table. Before using the Query activity, you must supply a filter string as an argument. This filter specifies the content of the query, that is, criteria for selecting a subset of rows from the table.
General
In the General tab, you can specify the activity name and a table connection.
The following table describes the fields in the General tab of the Query activity:
Field | Module Property? | Description |
---|---|---|
Name | No | Specifies the name to be displayed as the label for the activity in the process. |
Table Connection | Yes | Click
to select a table connection.
If the datagrid for the required table connection is not found, in the Select FireflyResource Resource Template dialog box that opens, click Create Shared Resource to create a datagrid connection first. See Creating a DataGrid and Adding a Table for details. |
Input
In the Input tab, you can specify the filter and the number of rows to be returned.
The following table describes the fields in the Input tab of the Query activity:
Output
In the Output tab, you can find the operation results.
The following table describes the field in the Output tab of the Query activity:
Output Item | Data Type | Description |
---|---|---|
Activity output | String | Specifies the HasError value, the error, the total count, and the rows that match the filter. It specifies the error message, the total count, and the rows if the HasError value is true. It specifies the total count of rows and the rows if the HasError value is false. |
Fault
In the Fault tab, you can find the error code and error message of the Query activity. See Error Codes for more detailed explanation of the errors.
The following table describes the errors in the Fault tab of the Query activity: