Page Comparison

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

Image Removed

Image Added

Physical Name

The name of the column in the database.

Label

This is the name that will be displayed in Jira, if you decide to make it visible (details here https://appfire.atlassian.net/wiki/spaces/PSJ/pages/15482145/General+settings+for+generic+fields#Hide-Column-Labels). It is used only for the generic Advanced Row Fields. The read-only fields are simple input fields which don’t display the label.

Type

The data type (such as number, string, date, etc.) is used for data validations when executing INSERT/UPDATE scripts and, more importantly, for 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 used in the Insert form as a default value. It comes prefilled in the input corresponding to this column.

PK

The column is the primary key in the connected database.

Searchable

Marking a column as searchable (value ‘Yes’ in the ‘Searchable’ select) adds it to the list of inputs that will be available to the user in the Search dialog. Setting a value for the Advanced Row field happens when it is selected from the results of a SEARCH script (https://appfire.atlassian.net/wiki/spaces/PSJ/pages/543031310/Configuring+scripts+for+generic+fields#SEARCH ) which is performed based on some criteria.

There is also the option of searching using just one column, marked as ‘Autocomplete’. For the ‘Autocomplete’ column, there are some extra settings (like the minimum number of characters that will need to be entered to trigger the autocomplete) which you can access using the adjacent button:

If any column is marked as ‘Autocomplete’, the ‘Searchable’ flags for all other columns will be reset to ‘No’.

Required

This marks a column as required (via a * next to its label) when executing INSERT/UPDATE operations. The corresponding input must be filled prior to submitting the insert/update form, otherwise an error message will be shown.

Constraints

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