...
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 and the issue separated by colon | Baseline Property (with type names with their linked issue keys |
Coverage Property
| Value | ||||||
coverageHeader
| Coverage details for header | ||||||
coverageDetail
| Coverage details for issue size and completeness percentage | ||||||
coverageIssue
| Coverage issues |
Traceability Property
|
---|
| 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
| 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 |
...