Page Comparison

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

If the field is This section is simplified for read-only , this section is simplified fields because some of the settings which are normally present here only make sense for editable fields. Here are the general settings for all read-only fields (simple select, multi select or autocomplete):

SQL Database Source

Select 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 Configuring Data Sources (PS)

In addition to those, you can use any JNDI identifier that was internally configured in Jira, but this will have to be manually filled in.

Use Auto-Bind

If you configure your field to depend on another field(s), setting this flag will allow you to intercept changes in that other field and to trigger the recalculation of the values of your field each time the fields it depends on change.

However, this may not be what you want. A better control of the field may be achieved via the Live Fields feature of Power Scripts Live Fields

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 then using the ALWAYS setting if set reasonably (12 hours or 1 day would be a examples of reasonable expiration times).