...
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, there is a set of parameters to configure on this page. For each entry (main database custom field) 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 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. | |||||
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:
|