Page Comparison

The general settings section allows you to set some basic options for the custom field.

SQL Database Source

Change which data source the field is using. A data source should be preconfigured prior to using this menu. Once configured the data source will be displayed as an option selectable in the SQL Database Source setting.

For more information about settings data sources see https://anovaapps.atlassian.net/wiki/spaces/PSJ/pages/1154973835.

Auto Search

Auto search triggers the search to occur automatically as soon as the user opens the Search dialog using the values that are already on the field.

Refresh type

The Advanced Database Row Field has the option to refresh the data from the source database. This means that if the data is updated in the database it can also be changed in Jira, if that is the desired behavior. Or, it can be set to never update the data in Jira once the options are established from the database. The available options are:

NEVER - The data in Jira will never update even if the source data in the database is changed.

ALWAYS - The data in Jira will always update. This means that when the custom field is viewed it will query the database every time in order to retrieve the most recent values. This operation can be expensive to your system performance and should only be used if the data can change multiple times in a given day.

EXPIRES - The data in Jira will only be updated once a specified amount of time has occurred. So, for example, if a value of “1w” was entered into the setting the data in Jira would refresh its values from the database once a week. Any value can be used as long as it is in the standard Jira time interval format. This is a much less expensive operation the using the ALWAYS setting if set reasonably (12 hours or 1 day would be a examples of reasonable expiration times).

Security Type

Actions

The Security Type setting controls what actions a user are allowed to perform on a field. The available actions are:

Set - Users are allowed to set a value for the field in Jira.

Insert - User can enter a new value in Jira nd the data will be added into the connected database table.

Update - Users can change the value of the data in Jira and the value will be updated in the connected database table.

Delete - Users can remove the data item from Jira and the data will be removed from the connected database table.

Security Settings

These actions can be controlled using different settings, the available settings are:

ALLOW ALL - Any user can perform any database actions (set, insert, update, delete).

DENY ALL - No users are allowed to perform all database actions (set, insert, update, delete).

FIXED - Each action can be set independently.

DYNAMIC - A script can be used to determine if specific permissions are given. The scripts can take a variety of inputs from issue or Jira environment so the script can accommodate many special conditions. See Writing Security Scripts for more information.