Configuring Power Database Fields PRO™
- Radu Dumitriu (Deactivated)
- Admin Adminovich (Deactivated)
- Service Account
To configure Power Database Fields PRO™, perform the following steps:
- Log into your Jira as Admin.
- From Jira administration console, go to Add-ons > Manage add-ons.
- Ensure that both SIL Engine™ and Power Database Fields PRO™ apps are enabled.
- On the Administration page, click Issues, and go to the Custom fields section.
- Add one of the following database custom fields. The fields are of the following types:
- Database Information – database custom field
- Database Child Information – a child field for the database custom field
- Data Table Information
- Database Row Field – database row custom field, this field is available starting with v4.5.0 of the app.
You must add at least one custom field so that you have something to configure. You can 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.
This is it! If everything is configured correctly, in the Create or Edit page for a ticket you should be able to see the values for the main database custom fields configured, and when selecting one of the values for a main database custom field, the values for the child fields for the main database custom field will be automatically filled in.
Fields description
For each main database custom field that you add, there is a set of parameters to configure on the field configuration page.
| 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. Oracle If you use Oracle, the ";" character placed at the end of the query causes a SQL error because ";" is considered to be an invalid character. Remove this character from the query. |
| 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. |
Indexable Field Name | It is used to fetch the row field data from the external database when the ticket is viewed or edited. The value of this field is saved in Jira. Should be unique. Availability This feature is available starting with version 4.5 of the app. |
| Indexable Field Label | Customized read-only label for the indexable field. Availability This feature is available starting with version 4.5 of the app. |
| Selectable Column Name | Use this field to select the necessary table row. Availability This feature is available starting with version 4.5 of the app. |
| Selectable Column Label | Customized read-only label for the selectable column field. Availability This feature is available starting with version 4.5 of the app. |
| Cacheable | If selected, this option enables you to get your data faster and enables you to avoid unnecessary queries to the external servers. When the request is made for the first time, its results are stored in Jira cache, so all other requests for the field's values will return cached values, hence improving overall performance. The cache is shared and synchronized over the Data Center deployments. Availability This feature is available starting with version 4.0.12. |
| 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:
|