Page Comparison

The Configuration Wizard is the simplest way to get your field going. It consists of a five-step process at the end of which the newly created field should be configured and ready to be used in Jira.

Step 1 -

Choosing the

field type

Image Modified

Depending on how you intend to use it, the Advanced Row Field can be either read-only or editable.

The read-only field supports basic selection of values and

has a single, but important, constraint: its configuration

requires exactly two columns, one of which acts as a primary key.

Depending on how the values need to be displayed or the number of values that need to be selected, it comes in three flavors:

• Single select -

• this allows just one selection from the list of values that is displayed entirely

• ,

• Multi select -

• this allows multiple values to be selected

• ,

• Autocomplete -

• this uses autocomplete to filter the displayed options

• .

The editable field allows an extended list of configuration options and the ability to use more columns and configure extra scripts, making it the most complex of the pack.

Step 2 -

Selecting the data source

Image Modified

The

Select the SQL data source

field allows you to select from the previously configured data sources

. For more information

on configuring a data source

, go to the Configuring Data Sources (PS)

guide.

In addition to

previously configured data sources, you can use any JNDI identifier

internally configured in Jira. However,

this

must be manually entered within the same input.

Step 3 - Selecting the table

Image Modified

The tables available for selection are only those

provided in the schema of the database previously selected.

Step 4 - Selecting the columns

Image Modified

For a read-only Advanced Row Field,

select only

two columns

: the primary key and the column that holds the values shown by the field. If the

original table already has a

primary key column,

the Advanced Row Field automatically uses it.

For an editable Advanced Row Field,

you can select as many columns as needed. The field layout is designed to display numerous columns, providing flexibility in your choices.

Step 5 -

Finalizing the wizard

Image Modified

Select Finish. The configuration is created and a minimal set of corresponding scripts are generated.