Configuration
Configure the Power Database Fields plugin following the steps below:
1. Log in as JIRA administrator. Go to the Administration->'Add-ons' menu, 'Manage add-ons' sub-menu. Make sure that both plugins katl-commons and Power Database Fields are enabled.
2. From JIRA Administration Administration->'Issues' menu, 'Custom fields' sub-menu add the 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.
- Add as many Database Information or Database Child Information custom fields as you need.
...
- Go to Administration > Add-ons
...
- >Database Custom Field
...
4. Configure the parameters for Database Custom Field
The first parameter to configure is the timeout(in seconds) for the cache of the configuration values. If no value is specified, the default value used is 300.
...
- 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 configuration to save changes.
- 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 added at step 2, there is a set of parameters to configure in on this page. For each entry (main database custom field) choose:specify the following parameters.
| Field | Description |
|---|---|
| Configuration Timeout | Timeout (in seconds) for the cache of the configuration values. If no value is specified, the default value is 300. |
| Type of Custom Field |
...
|
...
|
...
|
...
|
| 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 |
...
...
.
|
...
|
...
| |
| 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. | |
| Add child, Remove child | If you want, you can configure |
...
a list of child database custom fields using |
...
the Add/Remove child |
...
buttons. The child fields are associated to the main database custom field. For each child, configure the following fields:
|
...
|
...
|
...
|
...
|
...
Save the settings using the "Save configuration" button.
5. Configure the parameters for Data Table Custom Field
...
|