Skip to end of banner
Go to start of banner

Columns

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Current »

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

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. - what is this used for? - data validations on INSERT and (more importantly) - indexing, so you can index a text column as string, and a number column as number, so you can use the correct operators when searching with JQL.

Default 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.

  • No labels