After After you complete the steps from the Configuration page are complete, configure the Data Table Custom Field custom field following the steps below:
- Access the 'DataTable Custom Field' configuration page from Administration->'Add-ons' menu, 'DataTable Custom Field' sub-menu:
- The first parameter to configure is the Thread Local Caching:
...
.
- Log into your Jira as Admin.
- Go to Administration > Add-ons >DataTable Custom Field configuration page.
- Configure the parameters on this page.
- Thread Local Caching
If you are not fully aware of what this implies,
- Thread Local Caching
...
- we recommend that you leave the option
...
- as "false".
Because multiple calls to get the value of a SIL Script Custom Field for a certain issue are inevitable, we implemented an option to generate the value only once per HTTP request. This
- as "false".
...
- improves performance, but might have
...
- certain side effects.
...
- For example, if the value is
...
- generated before
...
- certain other values that it depends on are modified, the
...
- result might
...
- not reflect latest updates.
...
- Custom Field
Here you select the necessary custom field of
- Custom Field
...
- the Data Table Information type, see example below.
- the Data Table Information type, see example below.
- Choose from the available options for 'Data Source' like in the image below:
- If Data Source is Database, another 2 parameters are available to be configured: - JNDI name and SQL Query.(Please see the Configuration page for details.)
- If Data Source is set to SIL, SIL Script is the editor where you should type a script like in the image below:
...
- Data Source – select data source, for instance, like in an example below.
- If you selected "Database" for the Data Source field, additional parameters become available to be configured, for more details seeConfiguration page.
- JNDI name
- SQL Query
If you selected "SIL" for the Data Source field, type a script in the SIL Script editor.
Before saving the script,
...
make sure the syntax is correct. You do that using the
...
Check
...
button.
...
You can also check
...
the log files if needed.
Info For more examples of SIL scripts,
...
see the Power Scripts for
...
Jira documentation.
...
- Save the settings using the
...
- Save configuration
...
- button.