This article describes how to use placeholders in combination with SQL to specify a data source for a grid. Table Grid Next Generation supports placeholders to query Jira values.
| Excerpt | ||
|---|---|---|
| ||
| Get data from Jira objects and use them to populate the grid. |
Jira values can be used to populate the grid with data from Jira objects.
You can
...
query the values from the following Jira-specific objects
...
: issue, project, component,
...
These values are used when the grid is instantiated for the specific issue or when the grid query is refreshed. The grid will not be refreshed when for instance the issue is assigned to a different user. More details on the refresh behavior is available on the Grid reload page.
...
user and custom fields.
For example, you can populate the grid column with a default value retrieved from Jira object.
You can use Jira values to populate the grid with data in different cases:
- initialize grid with data
- set default values for gird columns
- populate select lists with dynamic
...
- options retrieved from Jira
- use custom field values in a grid: get data from
...
- a custom field which has a list of values and populate a grid with these values.
Supported values
Basic Jira Values
| Issue Level specific | Project Level specific |
|---|
...
| Current User Level specific | |
|---|---|
|
...
|
Current User Level specific:
|
Example placeholders for basic Jira values
Below you can find some example of the placeholders with the queries
| Code Block |
|---|
select name,price from sandwich_menu where restaurant={customfield:10010} |
Custom Field Values
Single Value types
- Date (should be treated as dates in our date column types)
- Date Picker
- Date Time Picker
- Numeric (should be treated as dates in our date column types)
- Number Field
- All other custom fields without a specific type should be handled the same way - get custom field value as a string
Multi-Value types
- Checkboxes
- Labels
- Radio Buttons
- Select List (cascading)
- Select List (multiple choices)
- Group Picker (multiple groups)
- User Picker (multiple users)
- Version Picker (multiple versions)
...
Example placeholders for custom field values
| Code Block |
|---|
customfield:{id} |
| Code Block | ||
|---|---|---|
|
...
customfield:12345 // retreives data from the custom field with id 12345 |
This placeholder will take a Custom Field value
...
for Single Value types,
...
and merge values into one separated by a comma for Multi-Value types
| Code Block |
|---|
customfield:{id}:{'all' or the index of the value(all - is default value)}:{'name' or 'value'(name - is default)} |
...
- customfield:12345:all:value
- customfield:12345:all:name - will be treated like simple customfield:12345 since 'all' and 'name' are defaults
- customfield:12345:1:value
- customfield:12345:1:name - might be simple customfield:12345:1 since 'name' is a default
Selecting 'all' will merge values into one separated by a comma