QueryBySQL
The QueryBySQL activity retrieves the entries that match the filter string or criteria specified in the datagrid. Before using the QueryBySQL 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 datagrid.
General
In the General tab, you can specify the activity name and a datagrid connection.
The following table describes the fields in the General tab of the QueryBySQL activity:
Field | Module Property? | Description |
---|---|---|
Name | No | Specifies the name to be displayed as the label for the activity in the process. |
DataGrid | Yes | Click to select a DataGrid shared resource. If the required datagrid 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 for details. |
Output
In the Output tab, you can find the operation results.
The following table describes the fields in the Output tab of the QueryBySQL activity:
Output Item | Data Type | Description |
---|---|---|
Activity output | String | Specifies the HasError value, the error, the total count, and the rows that match the SQL query. It specifies the error message, the total count, and select fields of rows if the HasError value is true. It specifies the total count of rows and select fields of the rows if the HasError value is false. The ROW element can have multiple Field elements which contains Name, Type, and Value elements. |
Fault
In the Fault tab, you can find the error code and error message of the QueryBySQL activity. See Error Codes for more detailed explanation of the errors.
The following table describes the errors in the Fault tab of the QueryBySQL activity: