...
Read-Only
Editable
...
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.
Step 2 - selection of the data source
...
The ‘Select the SQL data source’ input allows you to select from the previously configured data sources (Datasources page of the Power Apps Config). In addition to those, you can use any JNDI identifier that was internally configured in Jira, but this will have to be entered manually in the same field.
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 multiple columns.
Step 5 - finalizing the wizard
...
After pressing the Finish button, the configuration is created and the corresponding scripts are generated.