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
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
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
The tables available for selection are only those provided in the schema of the database previously selected.
Step 4 - Selecting the columns
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
Select Finish. The configuration is created and a minimal set of corresponding scripts are generated.