Workflow Manager 2013 R2
If you first define a connection to an external SQL Server database, you can choose to populate a single-selection list for a workflow request with real-time data values, obtained from that database.
To do this, create a data element with the Data Type of DB Driven Type. When you select this option from the Data Type list, three new fields appear:
| • | External Datasources—Choose the database you want to pull information from, choosing a connection defined on the External Data Sources Administration page. See Managing External Data Sources. |
| • | SQL Query—Define a query to return the data which you want to display to the workflow consumer. For example, if you want to display the LastName and JobTitle and EmployeeID of all salespeople in the Midwest region, craft a query that would return those rows and columns. |
| • | Persisted Column—Enter the name of the column containing the value you want to store in the database. In the previous example, you would probably want to store the EmployeeID column, because it uniquely identifies the person that will be selected. |
See Also
Defining a Custom Web Page Workflow Step
Defining Specialized Data Elements, Workflow Phases, and Workflow Steps
Workflow Manager 2013 R2 / AdminStudio Enterprise Server 2013 R2 SP1 Help LibraryFebruary 19, 2014 |
Copyright Information | Contact Us |