To configure Power Database Fields PRO™, perform the following steps:
- Log into your Jira as Admin.
- From Jira administration console, go to Add-ons, and click the Manage add-ons link.
- Ensure that both katl-commons and Power Database Fields PRO™ are enabled.
- On the Administration page, click Issues, and go to the Custom fields section.
- Add custom fields of the following types:
- Database Information (database custom field)
- Database Child Information (child for a database custom field)
- Data Table Information
You must add at least one custom field so that you have something to configure. Add as many Database Information or Database Child Information custom fields as you need.
- Go to Administration > Add-ons > Database Custom Field configuration page.
Configure the parameters as described in the table below. The following picture shows an example of how you can configure the fields.
- Click Save.
- Configure the parameters for the Data Table custom field.
...
| Field | Description | |||||
|---|---|---|---|---|---|---|
| Configuration Timeout | Starting with v4.0.8 this field was moved to the Data Table custom field configuration page. | |||||
| Type |
| |||||
| Multiple values | If checked, you can select multiple values from the database for the given database custom field. If clear, you can configure child custom fields described below. | |||||
| Add none option | Available for the select list types only. You can choose to show None option for each individual database custom field. | |||||
| Accept any value | Available for the autocomplete types only. When this flag is checked, you can enter free text in the dbcf field input, even if the relevant entry is not listed in the database. | |||||
| Database(JNDI name) | The JNDI data source. To configure the data source, see Data Source Configuration. | |||||
| Sql query | The sql query to be run, for instance SELECT col1, col2, col3, col4 FROM testTable. It can either be a simple sql, or a dynamic sql.
| |||||
| Column | One of the columns selected by the sql query, for instance col1. This column will be used to get the values for a given database custom field. You can also make it read only. | |||||
| Cacheable | If selected, this option enables you to get your data faster and enables you to avoid unnecessary queries to the external servers. So, when the request is made for the first time, the results are stored on the local server and all other requests are directed to this server, hence improving the overall app performance.
| |||||
| CacheInterval | Here you specify the time interval between checks for updates to the master database, in seconds. The minimum value is 0 seconds, and it that cache will never be updated. | |||||
| Add Сhild, Delete | You can configure a list of child database custom fields associated to the main database custom field. For each child, configure the following fields:
|
...