Miscellaneous Functions | Tempo Help Center

ACCESS

ACCESS(Item, PropertyName)

Tries to access a property/field of the item.

Parameter	Type	Description
`Item`	`Item`	Item containing the property or a key-value map.
`PropertyName`	`Text`	Property or field being accessed.
→ Result	`Any`	Value in `PropertyName`. Undefined if the `Item` is not an item or key-value map, or it does not have this property. Flattens a value of array-of-arrays.

Parameter

Type

Description

Item

Item containing the property or a key-value map.

PropertyName

Text

Property or field being accessed.

→ Result

Any

Value in PropertyName. Undefined if the Item is not an item or key-value map, or it does not have this property.

Flattens a value of array-of-arrays.

Example:

ACCESS(epic, "Story Points")

GET

GET(Item, PropertyName)

Tries to access a property/field of the item. Almost identical to ACCESS, except that it doesn’t flatten the result.

Parameter	Type	Description
`Item`	`Item`	Item containing the property or a key-value map.
`PropertyName`	`Text`	Property or field being accessed.
→ Result	`Any`	Value in `PropertyName`. Undefined if the `Item` is not an item or key-value map, or it does not have this property. Returns as-is if the value is array-of-arrays.

Parameter

Type

Description

Item

Item containing the property or a key-value map.

PropertyName

Text

Property or field being accessed.

→ Result

Any

Value in PropertyName. Undefined if the Item is not an item or key-value map, or it does not have this property.

Returns as-is if the value is array-of-arrays.

Example:

GET(epic, "Story Points")

HISTORICAL_VALUE

HISTORICAL_VALUE(Item, Field, Date)

Show value of the field at specified date

Parameter	Type	Description
`Item`	`Item`	Issue item; use "this" for current row..
`Field`	`Text`	Field being accessed.
`Date`	`Date/Time`	Date or date/time value; use DATETIME function to convert into it: #DATETIME
`→ Result`	`Any`	Field value at specified date (current value will be used for future dates).

Example:

HISTORICAL_VALUE(this, "cost", DATETIME("15/May/18 6:24 PM")) → 5.55
HISTORICAL_VALUE(this, "cost", NOW()) → 5.55

ME

ME()

Returns the user item of the current user.

Example:

IF(ME() = "admin"; "You're admin!")

STRUCT

STRUCT(Key1, Value1, Key2, Value2, …)

Makes a key-value map, so that STRUCT(Key1, Value1).Key1, STRUCT(Key1, Value1).ACCESS(Key1), STRUCT(Key1, Value1).GET(Key1) return Value1.

Parameter	Type	Description
`KeyX`	`String`	The Xth key for the Xth value. There must be at least Key1.
`ValueX`	`Any`	The Xth value for the Xth key. There must be as many Values as there are Keys.
`→ Result`	`Key-Value Map`	Map holding the specified entries. If KeyX is the same as KeyY, and X < Y, Map will only hold KeyY => ValueY entry.

Example:

STRUCT('name', 'John', 'hours', 40)

URL_ENCODE

URL_ENCODE(Value)

Translates a text into application/x-www-form-urlencoded format.

Parameter	Type	Description
`Value`	`Text`	Value to convert
→ Result	`Text`	`Value` converted to application/x-www-form-urlencoded format.

Example:

URL_ENCODE("http://www.test.com") → "http%3A%2F%2Fwww.test.com"

URL_DECODE

URL_DECODE(Value)

Decodes an application/x-www-form-urlencoded text.

Parameter	Type	Description
`Value`	`Text`	Value to convert
→ Result	`Text`	Decoded `Value`.

Example:

URL_DECODE("http%3A%2F%2Fwww.test.com") → "http://www.test.com/"