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’s 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 it has a single, but important constraint: its configuration will require 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 - a select that allows just one selection from the list of values that is displayed entirely;
Multi select - a select that allows multiple values to be selected;
Autocomplete - a single select that uses autocomplete to filter the options to display.
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 - selection of the data source
The ‘Select the SQL data source’ input allows you to select from the previously configured data sources (for more information about configuring a data source see Configuring Data Sources (PS)). In addition to those, you can use any JNDI identifier that was internally configured in Jira, but this will have to be manually entered within the same input.
Step 3 - table selection
The tables available for selection are only those directly available in the schema of the database previously selected.
Step 4 - columns selection
For a read-only Advanced Row Field, you should only select two columns - the primary key and the column that holds the values shown by the field. If the originating table has a column marked as primary key, it will be recognized as such here as well.
For an editable Advanced Row Field, there is no limit for the number of selected columns, as the layout of this field allows the display of numerous columns.
Step 5 - finalizing the wizard
After pressing the Finish button, the configuration is created and a minimal set of corresponding scripts are generated.