DATA CENTER AND SERVER | CLOUD

Context Items and Properties

The following fields may appear as placeholders. Properties are only available in version 4.18.0 upward.

A custom field can be referred to either by its name (e.g. Classification) or by its internal Jira ID in the format customfield_<ID> (e.g. customfield_10221).

System Fields

Issue Property

Value

Issue Property

Value

key

  • .label : Retrieve field name of Jira

  • .url : Add hyperlink to Jira issue or Confluence page

  • .link : Add hyperlink to issue or page in R4J

Issue key, Folder name, Confluence page

issueType 

  • .label : Retrieve field name of Jira

Issue type, "Folder", "Confluence Page"

summary

  • .label : Retrieve field name of Jira

Issue summary, folder name, Confluence page title

description

  • .label : Retrieve field name of Jira

  • .wiki : Render content, images (as links to Jira), tables not rendered (add as markup), attachments as links to Jira

Issue description, folder description, Confluence page content

creator 

  • .label : Retrieve field name of Jira

  • .displayname: Render login name as display name. Not applicable for folder.

Issue creator, null for folder, Confluence page creator - login name

created

  • label : Retrieve field name of Jira

Issue created, null for folder, Confluence page created date. Store as Excel number (e.g. 44972.4603125), show as Excel "Date" format, e.g. "2/15/2023". Take time zone from user profile.

updated

.label : Retrieve field name of Jira

Issue updated, null for folder, Confluence page last modification date. Store as Excel number (e.g. 44972.4603125), show as Excel "Date" format, e.g. "2/15/2023". Take time zone from user profile.

linkedIssues

  • .label : Retrieve field name of Jira

  • .multiline : Multi line inside cell for multivalued fields

Shows the linked issue keys

linkTypes

  • .label : Retrieve field name of Jira

  • .multiline : Multi line inside cell for multivalued fields

Shows the link type names with their linked issue keys

Coverage Property DAta Center V4.18

Value

coverageHeader

  • .labelName : Column name

  • .source : Filter source

  • .linkTypes : Link types source

Coverage details for header

coverageDetail

  • .issueSize : Number of issues in column

  • .coverageDetail : Coverage completeness percentage

Coverage details for issue size and completeness percentage

coverageIssue

  • .linkTypes : Show issue link type value

    • .label : Show issue link type name

  • displayFieldsRow : Populate field values into rows as defined in display fields selector

  • .displayFieldsColumn : Populate field values into columns as defined in display fields selector

  • .label : Populate field names

  • .suspect : Add "(suspect)" without hyperlink

  • .suspectLink : Add "(suspect)" with hyperlink to suspect report

Coverage issues

Traceability Property DAta Center V4.21

Value

Traceability Property DAta Center V4.21

Value

header

  • .sourceRow : Row filter source

  • .sourceCol : Column filter source

  • .linkTypes : Link types source

  • .scope : Flag to display issues even if there is no existing link

Traceability details for header

traceMatrix : From the position in the sheet, the trace matrix will populate the rows and columns with a 1:1 copy from the traceability view

Traceability issues

Baseline Property DAta Center V4.19

Value

name

  • <default> : .row : Top-down direction

  • .row : Top-down direction

  • .col : Sidewards direction

Baseline name

fields

  • <default> : .row : Top-down direction

  • .label : List the field name from Jira for all tree field context items and baseline fields

    • .row : Top-down direction

    • .col: Sidewards direction

  • .value : List the field value from Jira for all tree field context items and baseline fields

    • .row : Top-down direction

    • .col : Sidewards direction

Baseline item fields stored with issue

Usable in baseline detail and comparison views

path

  • <default> : .row : Top-down direction

  • .row : Top-down direction

  • .col : Sidewards direction

Baseline item path

Other System Fields

Property

Value

Property

Value

affectedVersions

  • .label : Retrieve field name of Jira

  • .multiline : Multi line inside cell for multivalued fields

Affected versions

assignee

  • .label : Retrieve field name of Jira

  • .displayname: Render login name as display name

Assignee

attachments

  • .label : Retrieve field name of Jira

  • .multiline : Multi line inside cell for multivalued fields

Attachment names

comments

  • .label : Retrieve field name of Jira

  • .wiki : Render content, images (as links to Jira), tables not rendered (add as markup), attachments as links to Jira

  • .multiline : Multi line inside cell for multivalued fields

  • .note : Export Jira comment as note

Comments

components

  • .label : Retrieve field name of Jira

  • .multiline : Multi line inside cell for multivalued fields

Component names

dueDate

  • .label : Retrieve field name of Jira

Due date. Store as Excel number (e.g. 44972.4603125), show as Excel "Date" format, e.g. "2/15/2023". Take time zone from user profile.

environment

  • .label : Retrieve field name of Jira

  • .wiki : Render content, images (as links to Jira), tables not rendered (add as markup), attachments as links to Jira

Environment

fixVersions

  • .label : Retrieve field name of Jira

  • .multiline : Multi line inside cell for multivalued fields

Fix versions

labels

  • .label : Retrieve field name of Jira

  • .multiline : Multi line inside cell for multivalued fields

Labels

logWork

  • .label : Retrieve field name of Jira

Log work (in seconds)

originalEstimate

  • .label : Retrieve field name of Jira

Original estimate (estimated time in seconds)

storyPoints

  • .label : Retrieve field name of Jira

Story points

parentLink

  • .label : Retrieve field name of Jira

Parent link

priority

  • .label : Retrieve field name of Jira

Priority

project

  • .label : Retrieve field name of Jira

Project

remainingEstimate

  • .label : Retrieve field name of Jira

Remaining estimate (estimated time in seconds)

reporter

  • .label : Retrieve field name of Jira

  • .displayname: Render login name as display name

Login name of issue reporter

resolution

  • .label : Retrieve field name of Jira

Resolution

resolved

  • .label : Retrieve field name of Jira

Resolved. Store as Excel number (e.g. 44972.4603125), show as Excel "Date" format, e.g. "2/15/2023". Take time zone from user profile.

securityLevel

  • .label : Retrieve field name of Jira

Security level

status

  • .label : Retrieve field name of Jira

Status

subTasks

  • .label : Retrieve field name of Jira

  • .multiline : Multi line inside cell for multivalued fields

Sub-tasks

targetEnd

  • .label : Retrieve field name of Jira

Target end. Store as Excel number (e.g. 44972.4603125), show as Excel "Date" format, e.g. "2/15/2023". Take time zone from user profile.

targetStart

  • .label : Retrieve field name of Jira

Target start. Store as Excel number (e.g. 44972.4603125), show as Excel "Date" format, e.g. "2/15/2023". Take time zone from user profile.

team

  • .label : Retrieve field name of Jira

Team

timeSpent

  • .label : Retrieve field name of Jira

Time spent

Custom Field Types

Property

Value

Property

Value

Checkboxes

  • .label : Retrieve field name of Jira

  • .multiline : Multi line inside cell for multivalued fields

Checkboxes custom fie type

Date Picker

  • .label : Retrieve field name of Jira

Date picker custom field type. Store as Excel number (e.g. 44972.4603125), show as Excel "Date" format, e.g. "2/15/2023". Take time zone from user profile.

Date Time Picker

  • .label : Retrieve field name of Jira

Date time picker custom field type. Store as Excel number (e.g. 44972.4603125), show as Excel "Date" format, e.g. "2/15/2023". Take time zone from user profile.

Group Picker (multiple groups)

  • .label : Retrieve field name of Jira

  • .multiline : Multi line inside cell for multivalued fields

Group Picker (multiple groups) custom field type

Group Picker (single group)

  • .label : Retrieve field name of Jira

Group Picker (single group) custom field type

Labels

  • .label : Retrieve field name of Jira

  • .multiline : Multi line inside cell for multivalued fields.

Labels custom field type

Number Field

  • .label : Retrieve field name of Jira

Number Field custom field type

Parent Link

  • .label : Retrieve field name of Jira

Parent link custom field type

Project Picker (single project)

  • .label : Retrieve field name of Jira

Project picker custom field type

R4J Issue Revision

  • .label : Retrieve field name of Jira

R4J issue revision custom field type

R4J Suspect

  • .label : Retrieve field name of Jira

R4J suspect custom field type

Radio Buttons

  • .label : Retrieve field name of Jira

Radio buttons custom field type

Select List (cascading)

  • .label : Retrieve field name of Jira

  • .multiline : Multi line inside cell for multivalued fields

Select list (cascading) custom field type

Select List (multiple choices)

  • .label : Retrieve field name of Jira

  • .multiline : Multi line inside cell for multivalued fields

Select list (multiple choices) custom field type

Select List (single choice)

  • .label : Retrieve field name of Jira

Select list (single choice) custom field type

Target end

  • .label : Retrieve field name of Jira

Target end custom field type

Target start

  • .label : Retrieve field name of Jira

Target start custom field type

Team

  • .label : Retrieve field name of Jira

Team custom field type

Text Field (multi-line)

  • .label : Retrieve field name of Jira

  • multiline : Multi line inside cell for multivalued fields

Text field (multi-line) custom field type

Text Field (read only)

  • .label : Retrieve field name of Jira

Text field (read only) custom field type

Text Field (single line)

  • .label : Retrieve field name of Jira

Text field (single line) custom field type

URL Field

  • .label : Retrieve field name of Jira

URL field custom field type (rendered as hyperlink)

User Picker (multiple users)

  • .label : Retrieve field name of Jira

  • .multiline : Multi line inside cell for multivalued fields

  • .displayname: Render login name as display name

User picker (multiple users) custom field type

User Picker (single user)

  • .label : Retrieve field name of Jira

  • .displayname: Render login name as display name

User picker (single user) custom field type

Version Picker (multiple versions)

  • .label : Retrieve field name of Jira

  • .multiline : Multi line inside cell for multivalued fields

Version picker (multiple versions) custom field type

Version Picker (single version)

  • .label : Retrieve field name of Jira

Version picker (single version) custom field type

Other Custom Field Types

Property

Value

Property

Value

Epic Color

  • .label : Retrieve field name of Jira

Epic color custom field type

Epic Link

  • .label : Retrieve field name of Jira

Epic link custom field type

Epic Name

  • .label : Retrieve field name of Jira

Epic name custom field type

Epic Status

  • .label : Retrieve field name of Jira

Epic status custom field type

Sprint

  • .label : Retrieve field name of Jira

Rendered as sprint name