...
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Сhild, Remove child Delete | If you want, you can configure a list of child database custom fields using the Add/Remove Delete child buttons. The child fields are associated to the main database custom field. For each child, configure the following fields:
|
...