Jira values placeholders
This article describes how to use placeholders in combination with SQL to populate the grid with data. Table Grid Next Generation supports placeholders to query Jira values.
Jira values can be used to initialize the grid with data, as dynamic options or as a default value in a grid column.
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 grid 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
Check the list of the supported values that you can get from Jira objects.
Basic Jira issue 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 available only if time-tracking has been enabled by your Jira administrator |
|
| issue:logged | logged time spent working on the current issue available only if time-tracking has been enabled by your Jira administrator |
|
| 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 available only if issue security has been enabled by your Jira administrator |
| status |
|
|
|
| issue:status:id | status id of the current issue |
|
| issue:status:name | status name of the current issue name is a default value 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 name is a default value 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 name is a default value 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 name is a default value 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 name is a default value 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 name is a default value 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 name is a default value 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 components ids separated by comma |
|
| issue:components:name | current issue components names separated by comma name is a default value issue:components:name is equal to issue:components |
|
| issue:components:description | current issue components descriptions separated by comma |
| fix_versions |
|
|
|
| issue:fix_versions:id | current issue fix versions ids separated by comma |
|
| issue:fix_versions:name | current issue fix versions names separated by comma name is a default value issue:fix_versions:name is equal to issue:fix_versions |
|
| issue:fix_versions:description | current issue fix versions descriptions separated by comma |
| affected_versions |
|
|
|
| issue:affected_versions:id | current issue affected versions ids separated by comma |
|
| issue:affected_versions:name | current issue affected versions names separated by comma name is a default value issue:affected_versions:name is equal to issue:affected_versions |
|
| issue:affected_versions:description | current issue affected versions description separated by comma |
| labels |
|
|
|
| issue:labels:id | current issue labels ids separated by comma |
|
| issue:labels:name | current issue labels names separated by comma name is a default value issue:labels:name is equal to issue:labels |
| attachments |
|
|
|
| issue:attachments:id | current issue attachments ids separated by comma |
|
| issue:attachments:name | current issue attachments names, separated by comma name is a default value issue:attachments:name is equal to issue:attachments |
|
| issue:attachments:file_size | current issue attachments files sizes separated by comma |
Parent issue values
Jira parent issue has the same values as Jira issue. You can use any of the above values either with parent or simple Jira issue.
| Placeholder expression | Result value | |
|---|---|---|---|
parent |
|
|
|
|
| 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 |