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 |
---|---|
key
| Issue key, Folder name, Confluence page |
issueType
| Issue type, "Folder", "Confluence Page" |
summary
| Issue summary, folder name, Confluence page title |
description
| Issue description, folder description, Confluence page content |
creator
| Issue creator, null for folder, Confluence page creator - login name |
created
| 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
| Shows the linked issue keys |
linkTypes
| Shows the link type names with their linked issue keys |
Coverage Property DAta Center V4.18 | Value |
coverageHeader
| Coverage details for header |
coverageDetail
| Coverage details for issue size and completeness percentage |
coverageIssue
| Coverage issues |
Traceability Property DAta Center V4.21 | Value |
---|---|
header
| 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
| Baseline name |
fields
| Baseline item fields stored with issue Usable in baseline detail and comparison views |
path
| Baseline item path |
Other System Fields
Property | Value |
---|---|
affectedVersions
| Affected versions |
assignee
| Assignee |
attachments
| Attachment names |
comments
| Comments |
components
| Component names |
dueDate
| 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
| Environment |
fixVersions
| Fix versions |
labels
| Labels |
logWork
| Log work (in seconds) |
originalEstimate
| Original estimate (estimated time in seconds) |
storyPoints
| Story points |
parentLink
| Parent link |
priority
| Priority |
project
| Project |
remainingEstimate
| Remaining estimate (estimated time in seconds) |
reporter
| Login name of issue reporter |
resolution
| Resolution |
resolved
| 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
| Security level |
status
| Status |
subTasks
| Sub-tasks |
targetEnd
| 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
| 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
| Team |
timeSpent
| Time spent |
Custom Field Types
Property | Value |
---|---|
Checkboxes
| Checkboxes custom fie type |
Date Picker
| 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
| 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)
| Group Picker (multiple groups) custom field type |
Group Picker (single group)
| Group Picker (single group) custom field type |
Labels
| Labels custom field type |
Number Field
| Number Field custom field type |
Parent Link
| Parent link custom field type |
Project Picker (single project)
| Project picker custom field type |
R4J Issue Revision
| R4J issue revision custom field type |
R4J Suspect
| R4J suspect custom field type |
Radio Buttons
| Radio buttons custom field type |
Select List (cascading)
| Select list (cascading) custom field type |
Select List (multiple choices)
| Select list (multiple choices) custom field type |
Select List (single choice)
| Select list (single choice) custom field type |
Target end
| Target end custom field type |
Target start
| Target start custom field type |
Team
| Team custom field type |
Text Field (multi-line)
| Text field (multi-line) custom field type |
Text Field (read only)
| Text field (read only) custom field type |
Text Field (single line)
| Text field (single line) custom field type |
URL Field
| URL field custom field type (rendered as hyperlink) |
User Picker (multiple users)
| User picker (multiple users) custom field type |
User Picker (single user)
| User picker (single user) custom field type |
Version Picker (multiple versions)
| Version picker (multiple versions) custom field type |
Version Picker (single version)
| Version picker (single version) custom field type |
Other Custom Field Types
Property | Value |
---|---|
Epic Color
| Epic color custom field type |
Epic Link
| Epic link custom field type |
Epic Name
| Epic name custom field type |
Epic Status
| Epic status custom field type |
Sprint
| Rendered as sprint name |