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, 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.