Confluence has been updated to version 6.15.9

Page tree
Skip to end of metadata
Go to start of metadata

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 expressionResult value
issue


issue:idid of the current issue


issue:keykey of the current issue


issue:summarysummary of the current issue


issue:descriptiondescription of the current issue


issue:environmentvalue from the environment field of the current issue


issue:estimate

original estimate of the current issue

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



issue:logged

logged time spent working on the current issue

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



issue:created_datedate when the current issue has been created


issue:resolution_date

resolution date of the current issue



issue:updated_dateupdate date of the current issue


issue:due_datedue date of the current issue


issue:votesnumber of votes for the current  issue


issue:watchersnumber of watchers for the current issue


issue:security_level

security level id of the current issue

(warning) available only if issue security has been enabled by your Jira administrator


status



issue:status:idstatus id of the current issue


issue:status:name 

status name of the current issue

(warning)name is a default value 

issue:status  is equal to issue:status:name



issue:status:descriptionstatus description of the current issue


issue:status:sequencestatus order position 

status_category



issue:status_category:idid of the status category 


issue:status_category:name

name of the status category

(warning)name is a default value 

issue:status_category:name  is equal to issue:status_category



issue:status_category:keystatus category description of the current issue


issue:status_category:sequencestatus category order position

resolution



issue:resolution:idresolution id of the current issue


issue:resolution:name

 resolution name of the current issue

(warning)name is a default value 

issue:resolution:name  is equal to issue:resolution



issue:resolution:descriptiondescription of the resolution for the current issue


issue:resolution:sequenceorder 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

(warning)name is a default value 

issue:reporter:name  is equal to issue:reporter



issue:priority:descriptiondescription of the priority for the current issue


issue:priority:sequenceorder position of the priority for the current issue

type



issue:type:idcurrent issue type id


issue:type:name

current issue type name 

(warning)name is a default value 

issue:type:name  is equal to issue:type



issue:type:descriptioncurrent issue type description


issue:type:sequenceorder position of the type for the current issue

assignee



issue:assignee:idcurrent issue assignee id


issue:assignee:keycurrent issue assignee key


issue:assignee:name

current issue assignee name

(warning)name is a default value 

issue:assignee:name  is equal to issue:assignee



issue:assignee:full_namecurrent issue assignee full name


issue:assignee:emailcurrent issue assignee email


issue:assignee:email_domaincurrent issue assignee email domain

reporter



issue:reporter:idcurrent issue reporter id


issue:reporter:keycurrent issue reporter key


issue:reporter:name

current issue reporter name

(warning)name is a default value 

issue:reporter:name  is equal to issue:reporter



issue:reporter:full_namecurrent issue reporter full name


issue:reporter:emailcurrent issue reporter email


issue:reporter:email_domaincurrent issue reporter email domain

components



issue:components:idcurrent issue components ids separated by comma


issue:components:name

current issue components names separated by comma

(warning)name is a default value 

issue:components:name  is equal to issue:components



issue:components:descriptioncurrent issue components descriptions separated by comma

fix_versions



issue:fix_versions:idcurrent issue fix versions ids separated by comma


issue:fix_versions:name

current issue fix versions names separated by comma

(warning)name is a default value 

issue:fix_versions:name  is equal to issue:fix_versions



issue:fix_versions:descriptioncurrent issue fix versions descriptions separated by comma

affected_versions



issue:affected_versions:idcurrent issue affected versions ids separated by comma


issue:affected_versions:name

current issue affected versions names separated by comma

(warning)name is a default value 

issue:affected_versions:name  is equal to issue:affected_versions



issue:affected_versions:descriptioncurrent issue affected versions description separated by comma

labels



issue:labels:idcurrent issue labels ids separated by comma


issue:labels:name

current issue labels names separated by comma

(warning)name is a default value 

issue:labels:name  is equal to issue:labels


attachments



issue:attachments:idcurrent issue attachments ids separated by comma


issue:attachments:name

current issue attachments names, separated by comma

(warning)name is a default value 

issue:attachments:name  is equal to issue:attachments



issue:attachments:file_sizecurrent 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 expressionResult value
parent




parent:idid of the parent issue


parent:keykey of the parent issue


parent:summarysummary of the parent issue


parent:descriptiondescription of the parent issue


parent:environmentvalue from the environment field of the parent issue


parent:estimate

original estimate of the parent issue

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



parent:logged

logged time spent working on the parent issue

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



parent:created_datedate when the parent issue has been created


parent:resolution_dateresolution date of the parent issue


parent:updated_dateupdate date of the parent issue


parent:due_datedue date of the parent issue


parent:votesnumber of votes for the parent  issue


parent:watchersnumber of watchers for the parent issue


parent:security_level

security level id of the security of the parent issue

(warning) available only if issue security has been enabled by your Jira administrator

Project level specific values



Placeholder expressionresult value
project


project:idcurrent project id


project:keycurrent project key


project:name

current project  name

(warning)name is a default value 

project:name  is equal to project



project:urlcurrent project url


project:descriptioncurrent project description

category


project:category:idcurrent project category id


project:category:name

current project category name

(warning)name is a default value 

project:category:name  is equal to project:category



project:category:descriptioncurrent project category description

lead


project:lead:idcurrent project lead if


project:lead:keycurrent project lead key


project:lead:name

current project lead name

(warning)name is a default value 

project:lead:name  is equal to project:lead



project:lead:full_namecurrent project lead full name


project:lead:emailcurrent project lead email


project:lead:email_domaincurrent project lead email domain

components


project:components:idcurrent project components ids separated by comma


project:components:name

current project components ids separated by comma

(warning)name is a default value 

project:components:name  is equal to project:components



project:components:descriptioncurrent project components descriptions separated by comma


project:components:lead_namecurrent project components leads' names separated by comma

versions


project:versions:idcurrent project versions ids separated by comma


project:versions:name

current project versions names separated by comma

(warning)name is a default value 

project:versions:name  is equal to project:versions



project:versions:descriptioncurrent versions descriptions separated  by comma


project:versions:is_archivedboolean value (true/false) of the current project versions is archived field


project:versions:is_releasedboolean value (true/false) of the current project versions is released field


project:versions:release_datecurrent project versions release dates separated by comma


project:versions:start_datecurrent project versions start dates separated by comma

User specific values


Placeholder expressionResult value
current _user




current_user:idid of the current user
current_user:keykey of the current user
current_user:name

name of the current user

(warning)name is a default value 

current_user:name  is equal to current_user

current_user:full_namefull name of the current user
current_user:emailemail of the current user
current_user:email_domainemail domain of the current user

Custom Field values 

As far as Jira provides different type of custom fields the values are divided by type. Check the table below. 


custom field value typePlaceholder expressionResult value
single value custom fields





urlcustomfield:{id}string value type

textcustomfield:{id}text value type

date pickercustomfield:{id}date value type

date time pickercustomfield:{id} date time value type

userpickercustomfield:{id}user value of the custom field

numbercustomfield:{id}number value of the custom field

select listcustomfield:{id}selected option of the custom field

radio buttons 

customfield:{id}

selected option  name of the custom field

multi value custom fields 





checkboxes 

customfield:{id}

list of available options separated by comma

You can also get a specific option from the custom field using the query. 

get third option name from the custom field with id 10509
customfield:10509:name:3

labels 

customfield:{id}

list of labels names separated by comma


groups pickercustomfield:{id}

list of group names separated by comma

You can also get a specific group name from the custom field using the query. 

get third group name from the custom field with id 10509
customfield:10509:name:3

select list(cascading)

  • customfield:{id}:id
  • customfield:{id}:name
  • customfield:{id}:parent
  • customfield:{id}: sequence
  • id of the custom field
  • names of the options separated by comma
  • parent options names separated by comma
  • order positions of the options separated by comma

select list(multiple choice)customfield:{id}list of options separated by comma

versions picker
  • customfield:{id}:id
  • customfield:{id}:name
  • customfield:{id}:description


user picker
  • customfield:{id}:id
  • customfield:{id}:key
  • customfield:{id}:name
  • customfield:{id}:full name
  • customfield:{id}:email
  • customfield:{id}email domain


Example placeholders for custom field values

You can get custom field values with the help of the custom field id. Check the example below.

example
customfield:10600


You can use the placeholder as a part of the SQL query to get custom field valued.

select name,price from sandwich_menu where restaurant={customfield:10010}

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

See also

Placeholder syntax and examples

  • No labels