/
Jira values placeholders

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



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



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





parent:environment

value from the environment field of the parent issue





parent:estimate

original estimate of the parent issue

 available only if time-tracking has been enabled by your Jira administrator





parent:logged

logged time spent working on the parent issue

 available only if time-tracking has been enabled by your Jira administrator





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