Example Using Query Database Widget

Example Using Query Database Widget

Query Employee Leave Balance

The following Query Database widget configuration retrieves the leave balance for an employee from a SQL database and stores it in a workflow variable. The contents of the variable can then be used later in the workflow.

For example, the results could be used to update a SharePoint list using the Update Item widget, or they could be e-mailed to the employee using the Send Email widget.

sa08QueryDatabaseEx1-Properties.jpg
Notice that in the SQL Server Selection properties (shown here), actual data was used to test the database connection. This is because lookup values are not determined until the workflow runs. Lookups were inserted into the Query String after the database connection was configured and tested. sa08QueryDatabaseEx1-TestDB.jpg

Return to:

Widget Properties

External Data Widgets

See Also: