Help Center>Foundation Help

Applies to:

  • Winshuttle Foundation

ADO Net Query

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"