ACCESS
ACCESS(Item, PropertyName)
Tries to access a property/field of the item.
|
Parameter |
Type |
Description |
|---|---|---|
|
|
|
Item containing the property or a key-value map. |
|
|
|
Property or field being accessed. |
|
→ Result |
|
Value in |
Example:
-
ACCESS(epic,"Story Points")
HISTORICAL_VALUE
HISTORICAL_VALUE(Item, Field, Date)
Show value of the field at specified date
|
Parameter |
Type |
Description |
|---|---|---|
|
|
|
Issue item; use "this" for current row. |
|
|
|
Field being accessed |
|
|
|
Date or date/time value; use DATETIME function to convert into it: #DATETIME |
|
|
|
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!")
URL_ENCODE
URL_ENCODE(Value)
Translates a text into application/x-www-form-urlencoded format.
|
Parameter |
Type |
Description |
|---|---|---|
|
|
|
Value to convert |
|
→ Result |
|
|
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 to convert |
|
→ Result |
|
Decoded |
Example:
-
URL_DECODE("http%3A%2F%2Fwww.test.com") → "http://www.test.com/"