ODBC Query

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.

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 Ws.WorkflowParticipant custom control to allow you to run the Pool Query when the value in a form field changes.

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