Data Table from SIL Script

Before using Data Table custom field with a SIL script, we recommend checking Simple Issue Language™ documentation for a better grasp of SIL™ usage and capabilities.

Before using the data table custom field, configure it as described on the Data Table Configuration page.

Use Case

For this example we will use a SIL script as a data source to show the full names and email addresses of all users that are members of the jira-administrators and jira-developers groups.

So the configuration for our custom field will look like this:

After the field is configured, when you view, create, edit or transition an issue, the data table custom field will be populated with the values retrieved from the configured SIL script.

Table grid where data is displayed offers the following capabilities:

  • Pagination for the cases when more than 10 results were retrieved

  • Refresh button for recalculating the results

  • Reordering and resizing of the columns as shown in the screenshot below.

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 data. Here's an 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 you view or edit a ticket, or use transition on an issue, the issue details are shown in the table grid.

When trying your own SIL examples, make sure that the syntax is correct before saving the script. You do that using the Check button. We also recommend that you check the log files as well.