Columns

Column settings allow for options to be set for individual columns of data from the database.

Open

Physical Name

The name of the column used by the database.

Label

The display name to be used in Jira.

Type

The data type (such as number, string, date, etc.) is used for data validations on INSERT and, more importantly, indexing. A text column can be indexed as a string and a number column as number so you can use the correct operators when searching with JQL.

Default Value

The value that should be selected before the user inputs a new value.

PK

The column is the primary key in the connected database.

Searchable

The column data should be searchable. This setting makes the column appear or not appear in the search window. The search script should also be updated in order to make sure the results for this column are being returned.

Required

The column should be required and must be filled in prior to the user updating the values.

Constraints

Settings that require the input data to match certain conditions prior to the user saving the values. See Constrains for more information about using constraints.