Applies to:
- Winshuttle Foundation
ADO Net Query
Uses an ADO.NET query to select a task participant.
| 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 |
Argument |
Description |
|
allowselect |
A Yes/No value that indicates whether to allow the user to select the workflow participants if the query returns nothing. |
|
arguments |
Arguments to pass to the query. |
|
connectionstring |
ADO.NET connectionstring. |
|
display |
A Yes/No value that indicates whether to display the selected workflow participant. |
|
isstoredprocedure
|
A Yes/No value that indicates whether the query string is an invocation of a database stored procedure. |
|
poolquery |
Query to run to initially populate the potential workflow participants from which the user can select. |
|
query |
Query to run. |
|
runat |
A Start/End value that indicates when to run the query. |
Note: The pool option allows the user to interactively select the participant(s) from the results returned from the query. This Participant resolver can be used in conjunction with the Rerun Pool Query option in the Ws.WorkflowParticipant custom control to allow you to run the Pool Query when the value in a form field changes.
Example
"connectionstring=Provider=Microsoft.Jet.OleDb.4.0;
Data Source=E:\data.xls;Extended Properties=Excel 8.0;","query=select [Supervisor Login] from Reports where lcase(login) = @svoriginator"