Versions Compared

Old Version 73

changes.mady.by.user Admin Adminovich

Saved on

compared with

New Version 74

changes.mady.by.user Elena Kolesnik

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

FieldDescription
Configuration TimeoutTimeout (in seconds) for the cache of the configuration values. If no value is specified, the default value is 300.
Type
  • Select list – the values of the field appear in a combo box.
    or
  • Autocomplete – the values of the field appear depending on the letters typed in the field, on the ticket screen.
Multiple valuesIf 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 optionAvailable for the select list types only. You can choose to show None option for each individual database custom field.
Accept Any ValueAvailable 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 Queryquery

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.

Warning
titleOracle

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.


ColumnOne 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 Сhild, Delete

If you want, you can configure a list of child database custom fields using the Add/Delete child buttons. The child fields are associated to the main database custom field.

For each child, configure the following fields:

  • Child Custom Field – One of the child database custom fields that you added. These are visible for selection only when multiple values flag isn't checked for the parent database custom field.
  • Column – One of the columns selected by the sql query, for instance col2. This column will be used to get the value for this child field. The value for the child field is completed automatically after a value for the main database custom field is selected.

...