Page Comparison

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

hidden	true

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, 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 specificProject Level specificCurrent User Level specific

issue/parent
- id
- key
- summary
- environment
- estimate
- logged
- description
- created_date
- resolution_date
- updated_date
- due_date
- votes
- watches
- security_level
status
- id
- name (default)
- description
- sequence
status_category

id
name (default)
key
sequence

resolution
- id
- name (default)
- description
- sequence
priority
- id
- name (default)
- description
- sequence
type
- id
- name (default)
- description
- sequence
assignee
- id
- key
- name (default)
- full_name
- email
- email_domain
reporter
- id
- key
- name (default)
- full_name
- email
- email_domain
components
fix_versions

id
name (default)
description

affected_versions
- id
- name (default)
- description
labels
- id
- name (default)
attachments
- id
- name (default)
- file_size

project
- id
- key
- name
- url
- description
category

id
name (default)
description

lead
- id
- key
- name (default)
- full_name
- email
- email_domain
components
versions
- id
- name (default)
- description
- is_archived
- is_released
- release_date
- start_date

current_user

id

key

name (default)

ull_name

email

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
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
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

parent:watchers number of watchers for the parent issue

parent:security_level
security level id of the security of the parent 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 component id

issue:components:name
current issue components name, separated by comma
name is a default value
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
name is a default value
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
name is a default value
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
name is a default value
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
name is a default value
issue:attachments:name is equal to issue:attachments

issue:attachments:file_size current issue attachment file sizes

Project level specific values

		Placeholder expression	result value
project
		project:id
		project:key
		project:name	name is a default value project:name is equal to project
		project:url
		project:description
	category
		project:category:id
		project:category:name	name is a default value project:category:name is equal to project:category
		project:category:description
	lead
		project:lead:id
		project:lead:key
		project:lead:name	name is a default value 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	name is a default value project:components:name is equal to project:components
		project:components:description
		project:components:lead_name
	versions
		project:versions:id
		project:versions:name	name is a default value 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 name is a default value 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

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

title	example

customfield:12345 // retreives data from the custom field with id 12345

Version	Old Version 4	New Version 5
Changes made by	svitlana (Deactivated)	svitlana (Deactivated)
Saved on	Jul 30, 2019	Jul 31, 2019

Versions Compared

Key

Supported values

Basic Jira Values

Project level specific values

Project level specific values

Example placeholders for basic Jira values

Custom Field Values

Single Value types

Multi-Value types

Example placeholders for custom field 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
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 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
		parent:watchers	number of watchers for the parent issue
		parent:security_level	security level id of the security of the parent 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 component id
		issue:components:name	current issue components name, separated by comma name is a default value 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 name is a default value 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 name is a default value 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 name is a default value 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 name is a default value issue:attachments:name is equal to issue:attachments
		issue:attachments:file_size	current issue attachment file sizes