Applies to:
- Winshuttle Foundation
ODBC Query
| Participant Resolvers home |
| Participant resolvers |
| ADGroup |
| ADO Net Query |
| Custom |
| GetFromUserProfile |
| LDAP Query |
| ODBC Query |
| Random from Role |
| Select From Role |
| SharePoint List Query |
| SharePointColumn |
| Site Group Driven |
| Web Service |
| Deprecated |
| Dynamic SharePoint List |
| Dynamic Web Service |
The ODBC Query resolver uses an ODBC query to select a task participant.
Note: This participant revolver type is the same as ADO Net Query. The only difference is the underlying technology. See ADO Net Query for an example.
Argument |
Description |
|
connectionstring |
ADO.NET connection string. (See below for an example.) |
|
query |
Query to run. |
|
poolquery |
Query to run to initially populate the potential workflow participants from which the user can select. |
|
display |
A Yes/No value that indicates whether to display the selected workflow participant. |
|
arguments |
Arguments to pass to the query. |
|
runat |
A Start/End value that indicates when to run the query. |
|
allowselect |
A Yes/No value that indicates whether to allow the user to select the workflow participants if the query returns nothing. |
Note: The pool option allows the user to interactively select the participants from the results returned from the query. This Participant resolver can be used in conjunction with the Rerun Pool Query option in the Workflow Participant element to allow you to run the Pool Query when the value in a form field changes.
Connection String example:
connectionstring= DRIVER={MySQL ODBC 3.51 Driver};SERVER=192.168.1.200;DATABASE=sharevis;UID=svdb;PASSWORD=sharevis;OPTION=3,query= select assignee from assignees where userid = @svoriginator