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 data from the database.

Image Removed

what needs to be set up in the Column List.

For the read-only fields, only two columns should be configured. One of them 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.

Image Added

Physical Name

The name of the column used by in the database.

Label

The display column name to that will be used in Jiradisplayed 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 on 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 that should be selected before the user inputs a new valuecomes prefilled in the corresponding input of the Insert form.

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 valuesMarking 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:

Image Added

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 Constrains Constraints for more information about using constraints.