Data Element Data Types

Workflow Manager 6.5

You can define a data element with any of the following data types:

Available Data Element Data Types

Data Type

Description

Text Entry Box

A single-line, editable text box.

To validate the data that a user enters into this text box, set the Validation Type option to Mask or Regular Expression.

When you select Mask or Regular Expression, two additional options appear: Validation Expression and Validation Message. See Text Entry Box Data Type Validation Options for more information.

Text Area

A multi-line, scrollable, and editable text box.

Single Selection

A drop down list prompting the user to select one value from a list of values. When this option is selected, the Selection list items field appears, where you enter the list values, one per line.

Important: Because a user can only select one value, Single Selection lists can be used to control branching.

Multiple Selection

List in which the user is permitted to select more than one value. When this option is selected, the Selection list items field appears, where you enter the list values, one per line.

Check Box

Square box that is selected or cleared to turn on or off an option. More than one check box can be selected. When this option is selected, the Selection list items field appears, where you enter the check box values, one per line.

Radio Button

A round button used to select one of a group of mutually exclusive options. When this option is selected, the Selection list items field appears, where you enter the radio button values, one per line.

Important: Because a user can only select one value, Radio Buttons can be used to control branching.

Date

A text box where the user is only permitted to either enter a date in date format (such as MM/DD/YYYY) or select a date by clicking on the field's associated Calendar icon.

Document Upload, Application Upload, Dependency Upload

An upload link in a workflow step which enables a user to upload application, documentation, or dependency files to a specific location on the Workflow Manager file server for the selected workflow request.

Downloadable File Upload

An upload link in a workflow step that occurs after the initial data entry step. These files are stored in the Workflow Manager Downloadable Files directory and are listed on the Downloadable Files tab for the selected workflow request. Typically after an administrator has completed his tasks, his next workflow step would be to upload the revised application file.

Directory Service

Select to map the data element to an attribute in a directory service, so that when this field is presented to the user, its value will be pre-populated by the value of the attribute for the current user.

When Directory Service is selected in the Data Type field, two additional fields appear: the Directory Services list, where you pick the directory service that contains the attribute that you want to use, and the Data element list, where you select the attribute that you want to map to.

Dynamic Pick List

A selection list which is populated with values from a user-supplied XML file. When this option is selected, the Data Source File field appears, where you specify the XML file that you want to use, and the Column Value to Select field appears, where you select which column's value in the XML file will be passed to Workflow Manager. By default, the first column is selected.

When a data element with a data type of Dynamic Pick List is displayed in a request, the user is prompted to click a link to make a selection. When the user clicks the Click to Select link, the Dynamic Pick List dialog box opens containing a list of the data in the selected XML file. After the user selects one or multiple items in the list and clicks OK, the selected values then populate the text area, with entries separated by pipes.

Note: See Dynamic Pick List Data Type Options for more information.

DB Driven Type

Select this option to populate a single-selection list with real time data values obtained from an associated SQL Server or Oracle database. When you select DB Driven Type from the Data Type list, three new fields appear:

External Datasources—Select a database connection that was defined on the External Data Sources Administration page. See Creating a New Data Source Connection.
SQL Query—Define a query to select the columns of the database table that you want to include on the selection list that is displayed to the user as a request is worked on. For example, if you want to display the LastName and JobTitle and EmployeeID of all salespersons in the Midwest region, enter a query that would return those values.
Persisted Column—Enter the name of the column containing the value you want to store in the database. In the previous example, you would probably want to store the EmployeeID column as the Persisted Column because it uniquely identifies the person that will be selected.

Note: See DB-Driven Type Data Type Options for more information.

Web Service Call

Select this option to return information from across a web service connection. For more information, see Web Service Results Dialog Box.