Structure (Cloud)
Breadcrumbs

Item Properties

You can access item properties within formulas, using the following notation: item.property. The available properties depend on the item type.

See below for a complete list of item types and their supported properties.

Comment

Accessible via: comment,  lastComment

Property Name

Type

Comments

author

User


updateAuthor

User


created

Number (Date/Time)


updated

Number (Date/Time)


body

Text


Component

Accessible via: components

Property Name

Type

Comments

name

Text


id

Number


description

Text


lead

User


Field History

Accessible via: {field}History, where {field} is the name of the custom field. Ex. statusHistory

Property Name

Type

Comments

from

Variable

Previous value, which corresponds to the field’s type. May be a text value if the value of the field type is impossible to retrieve.

fromText

Text

Text representation of the previous value. This can sometimes be faster than using “from”.

to

Variable

Changed value, which corresponds to field’s type. May be a text value if the value of the field type is impossible to retrieve.

toText

Text

Text representation of the changed value.This can sometimes be faster than using “to”.

time

Number (Date/Time)


Accessible via: issueLinks

Property Name

Type

Comments

source

Issue


destination

Issue


type

IssueLinkType


Accessible via: issueLinks.destination

Property Name

Type

Comments

key

text


url

text


summary

Text


status

Status


status.category

Status


priority

Text


issuetype

Text


Accessible via: issueLinks.source

Property Name

Type

Comments

key

text


url

text


summary

Text


status

Status


status.category

Status


priority

Text


issuetype

Text


Accessible via: issueLinks.type

Property Name

Type

Comments

name

Text


inward

Text


outward

Text


IssueType

Accessible via: issueType

Property Name

Type

Comments

name

Text


id

number


sequence

Number

Used to sort issue types.

isSubtask

Number (Boolean)

True if the type is a sub-task type.

Project

Accessible via: project

Property Name

Type

Comments

name

Text


id

Number


key

Text


url

Text


Sprint

Accessible via: sprint

Property Name

Type

Comments

name

Text


id

Number


startDate

Number (Date/Time)


endDate

Number (Date/Time)


completeDate

Number (Date/Time)


state

Text


boardId

Number


goal

text


Status

Accessible via: status

Property Name

Type

Comments

name

Text


id

Number


description

Text


category

Text


User

Accessible via: assignee, reporter, creator, author

Property Name

Type

Comments

name

Text

User's login name

account

Text


timezone

Text


isActive

Number (Boolean)

True if the user is active

Version

Accessible via: affectsVersion, fixVersion

Property Name

Type

Comments

name

Text


id

Number


description

Text


project

Text

Project name

isArchived

Number (Boolean)


isReleased

Number (Boolean)


startDate

Number (Date)


releaseDate

Number (Date)


Work Logs (Jira)

Accessible via: jiraWorkLogs

Property Name

Type

Comments

author

User


updateAuthor

User


created

Number (Date/Time)


updated

Number (Date/Time)


comment

Text


startDate

Number (Date/Time)


started

Number (Date/Time)

Alias for startDate

timeSpent

Number (Duration)


id

Number


Work Logs (Tempo)

Accessible via: tempoWorkLogs

Property Name

Type

Comments

author

User


created

Number (Date/Time)


updated

Number (Date/Time)


comment

Text


startDate

Number (Date/Time)


started

Number (Date/Time)

Alias for startDate

timeSpent

Number (Duration)


billable

Number (Duration)


id

Number


Tempo Work Attributes

If you’ve created custom Tempo Work Attributes, these values can also be used in formulas: tempoworklogs.<WORKATTRIBUTEKEY> (Replace “<WORKATTRIBUTEKEY>” with the key for the work attribute you want to use.)

If you don’t know a work attribute’s key, create a column with the formula FLATTEN(tempoworklogs.workattributekeys)- this will provide a list of available work attribute keys.