How to fill in a list with dynamic options
You can fill in your Single Select List or Multi Select List with data from a data source by using dynamic options.
It is possible to combine static and dynamic options in one list.
Dynamic options configuration
Create or edit a Single Select List or a Multi Select List column.
Add Dynamic options by pressing .
Select a data source in the Data Source drop-down. You can either choose your Jira database available by default or connect an external data source.
Enter the queries to get data based on your data source:
For REST data sources, specify the JSON Path query. You can also enter the Relative URL, Headers, and Path Parameters, if necessary. Check JSON Path in REST data source article for examples of JSON paths.
For SQL or Jira data sources, enter the SQL query.
Preview your results with Get data.
Configure Mapping for the label and value.
Press
to save dynamic options settings.
After you save dynamic options settings they will look as follows:Press Add.
See also
How to configure a Single Select List or a Multi Select List column
How to fill in a list with static options
How to create a Formula column
How to add option attributes to a list