| Infotip |
|---|
Before using Data Table custom field with a SIL script check out the , we recommend checking 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 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 the users that are in Developers role members of the current project. jira-administrators and jira-developers groups.
So the configuration for our custom field will look like this:
After the field is configured, when viewing/creating/editing you view, create, edit or transition an issue, as well as in a transition screen, the data table custom field will be populated with the values retrieved from our the configured SIL script:.
The Table grid where data is displayed in a grid that offers the following capabilities such as
...
:
- Pagination for the cases when more than 10 results were retrieved
- 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 Reordering and resizing of the columns 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 SIL script, you can also use issue fields in the script for displaying the data. Below is a basic Here's an example of displaying a couple of issue fields in a data table using a sil scriptSIL script:
After configuring the data table custom field with the sil SIL script as shown above, when viewing/editing an issue or in a transition screen for a particular you view or edit a ticket, or use transition on an issue, the issue details are shown in the table grid:.
| Warningnote |
|---|
When trying your own sil SIL examples, make sure that the syntax is correct before saving the script. You do that using the "Check" button. If needed check also We also recommend that you check the log files as well. |
...