Before using Data Table custom field with a SIL script check out the Simple Issue Language documentation for a better grasp of SIL usage and capabilities.
Before using the data table custom field, you have to configure it as described in the Data Table Configuration page.
For this example we will use a SIL script as a data source to show the full names and email addresses of all the users that are in Developers role of the current project. So the configuration for our custom field will look like this:
After the field is configured, when viewing/creating/editing an issue, as well as in a transition screen, the data table custom field will be populated with the values retrieved from our configured SIL script:
The data is displayed in a grid that offers capabilities such as
- paging when the number of retrieved results exceeds ten
- search button to filter the entries
- refresh button for recalculating the results
- export to excel button that export the table to a csv
- reordering of the entire table based on a column (in alphabetical order)
- reordering and resizing of the columns
as shown in the below image:
There is no searcher defined for the data table custom field type, but its value is displayed in the search results, as shown below:
Using issue fields in a SIL script for data table
When configuring a data table custom field to use a sil script, you can also use issue fields in the script for displaying the data. Below is a basic example of displaying a couple of issue fields in a data table using a sil script:
After configuring the data table custom field with the sil script as shown above, when viewing/editing an issue or in a transition screen for a particular issue, the issue details are shown in the table grid:
When trying your own sil examples, make sure the syntax is correct before saving the script. You do that using the "Check" button. If needed check also the log files.
That's it.