Page Comparison

Column settings allow for options to be set for individual columns that compose the Advanced Row Field.

Important: The field’s Display Type https://appfire.atlassian.net/wiki/spaces/PSJ/pages/540214621/General#Display-Type has a major influence of what needs to be set up in the Column List.

For the read-only fields, only two columns should be configured. One of data from the databasethem acts as primary key, while the other refers to the actual data displayed by the Select/Multiselect/Autocomplete field.

Image Added

For the Generic fields, many more columns can be configured.

Physical Name

The name of the column in the database.

Label

The column 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 that comes prefilled in the corresponding input that corresponds to the columnof the Insert form.

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.