SQL List

The SQL List activity is being marked as obsolete due to the replacement of it with the new SQL Query activity. Refer to this section only when troubleshooting or looking up usage for an existing SQL List activity in a Workflow model.

Sample SQLs: The user is supplied with several examples of an SQL statement to get them started. The samples can be viewed using the combo box drop down list.
List Title: The name of the list under which the results will be stored in the Workflow model instance data. When referencing Imported Model Data, information from this activity will be referenced by the List Title.
Enter your SQL statement here: The SQL statement that will be executed under this activity is defined in this text area. All SQL statements are currently supported here with the exception of reserved words.
Results: The table area reflects the results of testing the SQL statement. When the SQL statement is successful, the resulting rows (up to 100) will be displayed in this area.
Test SQL: Once an SQL statement has been entered in the SQL statement text area, it can be tested by selected the "Test SQL" button. The results, if successful, appear in the Results area of the dialog box.

Execution

When an SQL statement is executed by the Workflow engine, the SQL statement is first parsed into the correct BT20 object and properties. This allows the Workflow Engine to process the results into the predefined BusinessPlus storage containers internally. The SQL statement is executed internally, and each row processed. The resulting information is used to build an internal list in the Workflow Instance's internal data which conforms to BusinessPlus standards and can then be referenced successfully in the Workflow model. When an SQL statement fails, the activity status is set to "X" (Error) and the Workflow Engine passes processing to the Error Handler if one is defined in the Workflow model.