appRules Studio includes workflow activites for reading records from a stored procedure. By utilizing the stored procedure related activities, the stored procedure records and the fields they contain can be read from the database and utilized in appRules just like any other records and fields.
Once a stored procedure record is read into an appRules project, the record and its fields can be used in Mappings, Custom Functions, Conditions, and other modules and facilities.
In this post, we will walk through a simple workflow example for reading records from a stored proceedure and viewing the field values using the ViewRuntimeRecords activity.
Below is the sample workflow for reading records from a SQL Server Northwinds sample database stored procedure:
The table below shows the key workflow activities used in composing the workflow:
# | Activity Type | Notes |
1 | initializeProject | Use the default values |
2 | ExecuteMssqlStoredProcedure
(ExecuteSqlServerStoredProcedure) |
This activity is used to define a Source to select the records to be processed.
|
3 | While | Use a While activity to control the flow of the workflow.
|
4 | ViewRuntimeRecords | Use the default values to display the fields read from the stored procedure.
|
5 | GetNextMssqlRecord
(GetNextSqlServerRecord) |
Reads the next record from the stored procedure. |
6 | CloseMssqlSource
(CloseSqlServerSource) |
Closes the connection to the database |
7 | CloseProject | Closes the project, logs statistics and frees resources |
Below are the properties of the ExecuteSqlServerStoredProcedure activity:
This is an example of how you can use appRules workflow activities to read records and associated columns from a stored procedure.
You can download appRules Studio including this sample project at: http://www.appstrategy.com/appRulesTrial