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.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, 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
| Placeholder expression | Result value | ||
|---|---|---|---|
| issue | |||
| issue:id | id of the current issue | ||
| issue:key | key of the current issue | ||
| issue:summary | summary of the current issue | ||
| issue:description | description of the current issue | ||
| issue:environment | value from the environment field of the current issue | ||
| issue:estimate | original estimate of the current issue
| ||
| issue:logged | logged time spent working on the current issue
| ||
| issue:created_date | date when the current issue has been created | ||
| issue:resolution_date | resolution date of the current issue | ||
| issue:updated_date | update date of the current issue | ||
| issue:due_date | due date of the current issue | ||
| issue:votes | number of votes for the current issue | ||
| issue:watchers | number of watchers for the current issue | ||
| issue:security_level | security level id of the current issue
| ||
| parent issue | |||
| parent:id | id of the parent issue | ||
| parent:key | key of the parent issue | ||
| parent:summary | summary of the parent issue | ||
| parent:description | description of the parent issue | ||
| parent:environment | value from the environment field of the parent issue | ||
| parent:estimate | original estimate of the parent issue
| ||
| parent:logged | logged time spent working on the parent issue
| ||
| parent:created_date | date when the parent issue has been created | ||
| parent:resolution_date | resolution date of the parent issue | ||
| parent:updated_date | update date of the parent issue | ||
| parent:due_date | due date of the parent issue | ||
| parent:votes | number of votes for the parent issue | ||
| parent:watchers | number of watchers for the parent issue | ||
| parent:security_level | security level id of the security of the parent issue
| ||
| status | |||
| issue:status:id | status id of the current issue | ||
| issue:status:name | status name of the current issue
issue:status is equal to issue:status:name | ||
| issue:status:description | status description of the current issue | ||
| issue:status:sequence | status order position | ||
| status_category | |||
| issue:status_category:id | id of the status category | ||
| issue:status_category:name | name of the status category
issue:status_category:name is equal to issue:status_category | ||
| issue:status_category:key | status category description of the current issue | ||
| issue:status_category:sequence | status category order position | ||
| resolution | |||
| issue:resolution:id | resolution id of the current issue | ||
| issue:resolution:name | resolution name of the current issue
issue:resolution:name is equal to issue:resolution | ||
| issue:resolution:description | description of the resolution for the current issue | ||
| issue:resolution:sequence | order position of the resolution for the current issue | ||
| priority | |||
| issue:priority:id | current issue priority id | ||
| issue:priority:name | name of the priority for the current issue
issue:reporter:name is equal to issue:reporter | ||
| issue:priority:description | description of the priority for the current issue | ||
| issue:priority:sequence | order position of the priority for the current issue | ||
| type | |||
| issue:type:id | current issue type id | ||
| issue:type:name | current issue type name
issue:type:name is equal to issue:type | ||
| issue:type:description | current issue type description | ||
| issue:type:sequence | order position of the type for the current issue | ||
| assignee | |||
| issue:assignee:id | current issue assignee id | ||
| issue:assignee:key | current issue assignee key | ||
| issue:assignee:name | current issue assignee name
issue:assignee:name is equal to issue:assignee | ||
| issue:assignee:full_name | current issue assignee full name | ||
| issue:assignee:email | current issue assignee email | ||
| issue:assignee:email_domain | current issue assignee email domain | ||
| reporter | |||
| issue:reporter:id | current issue reporter id | ||
| issue:reporter:key | current issue reporter key | ||
| issue:reporter:name | current issue reporter name
issue:reporter:name is equal to issue:reporter | ||
| issue:reporter:full_name | current issue reporter full name | ||
| issue:reporter:email | current issue reporter email | ||
| issue:reporter:email_domain | current issue reporter email domain | ||
| components | |||
| issue:components:id | current issue component id | ||
| issue:components:name | current issue components name, separated by comma
issue:components:name is equal to issue:components | ||
| issue:components:description | current issue components desciption | ||
| fix_versions | |||
| issue:fix_versions:id | current issue fix version id | ||
| issue:fix_versions:name | current issue fix version name
issue:fix_versions:name is equal to issue:fix_versions | ||
| issue:fix_versions:description | current issue fix version description | ||
| affected_versions | |||
| issue:affected_versions:id | current issue affected version id | ||
| issue:affected_versions:name | current issue affected version name
issue:affected_versions:name is equal to issue:affected_versions | ||
| issue:affected_versions:description | current issue affected version description | ||
| labels | |||
| issue:labels:id | current issue labels ids | ||
| issue:labels:name | current issue labels names, separated by comma
issue:labels:name is equal to issue:labels | ||
| attachments | |||
| issue:attachments:id | current issue attachment ids | ||
| issue:attachments:name | current issue attachment names, separated by comma
issue:attachments:name is equal to issue:attachments | ||
| issue:attachments:file_size | current issue attachment file sizes | ||
available only if time-tracking has been enabled by your Jira administrator
Project level specific values
| Placeholder expression | result value | ||
|---|---|---|---|
| project | |||
| project:id | |||
| project:key | |||
| project:name |
project:name is equal to project | ||
| project:url | |||
| project:description | |||
| category | |||
| project:category:id | |||
| project:category:name |
project:category:name is equal to project:category | ||
| project:category:description | |||
| lead | |||
| project:lead:id | |||
| project:lead:key | |||
| project:lead:name |
project:lead:name is equal to project:lead | ||
| project:lead:full_name | |||
| project:lead:email | |||
| project:lead:email_domain | |||
| components | |||
| project:components:id | |||
| project:components:name |
project:components:name is equal to project:components | ||
| project:components:description | |||
| project:components:lead_name | |||
| versions | |||
| project:versions:id | |||
project:versions:name |
project:versions:name is equal to project:versions | ||
| project:versions:description | |||
| project:versions:is_archived | |||
| project:versions:is_released | |||
| project:versions:release_date | |||
| project:versions:start_date |
Project level specific values
| Placeholder expression | Result value | |
|---|---|---|
| current _user | current_user:id | id of the current user |
| current_user:key | key of the current user | |
| current_user:name | name of the current user
current_user:name is equal to current_user | |
| current_user:full_name | ||
| current_user:email | ||
| current_user:email_domain |
Example placeholders for basic Jira values
Below you can find some example of the placeholders with the queries
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
customfield:{id}
customfield:12345 // retreives data from the custom field with id 12345