ADO Net Query

Participant Resolvers

Uses an ADO.NET query to select a task participant.

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"