After the steps from the Configuration page are complete, configure the Data Table 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:
If you are not fully aware of what this implies, it is recommended that you leave the option off.
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 can improve performance, but might have some side effects.
For example, if the value is generated before some other values it depends on are modified, the result might not reflect latest updates.
- Choose from the combo box the desired custom field of type Data Table Information.
- 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:
Before saving the script, please make sure the syntax is correct. You do that using the "Check" button. If needed check also the log files.
For more examples of SIL scripts, please see the Power Scripts for JIRA (formerly known as JJUPIN) documentation.
- Save the settings using the "Save configuration" button.