Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Green

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

    Status
    colourGreen
    titlebaseline
Status
colour
titleV4.19
Status
colourGreen
titleR4JC V2.10.0

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 and the issue separated by colonname type names with their linked issue keys

Coverage Property

Status
colourGreen
title

baseline
Status
colourGreen
titleV4.19
Status
colourGreen
titleR4JC V2.10.0
  • <default>: .row : Top-down direction

  • .row : Top-down direction

  • .col: Sidewards direction

Baseline name

fields

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

Status
colourGreen
title

baseline

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

Status
colourGreen
titleDAta Center V4.19

status

Value

colourGreentitleR4JC V2.10.0

name

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

  • .row : Top-down direction

  • .col : Sidewards direction

Baseline name

fields

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

  • .label:

Lists
  • List the field name from Jira for all tree field context items and baseline fields

    • .row : Top-down direction

    • .col: Sidewards direction

  • .value :

Lists StatuscolourGreentitleR4JC V2.10.0
  • 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

path
Status
colourGreen
titlebaseline
Status
colourGreen
titleV4.19

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

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

...