Page Comparison

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

Physical Name

The name of the column in the database.

Label

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.

The list of possible types include BOOLEAN, NUMBER, REAL, STRING, DATE, DATETIME and SEQUENCE (for PKs that are autogenerated numbers). The type of a column will determine the constraints that can be configured for it.

Default Value

The value used in the Insert form as a default value. It comes prefilled in the input that corresponds to the 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. This allows for its value to be used in the SEARCH script (https://appfire.atlassian.net/wiki/spaces/PSJ/pages/543031310/Configuring+scripts+for+generic+fields#SEARCH ).

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.