Miscellaneous Functions
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. |
PropertyName | Text | Property or field being accessed. |
| → Result | Any | 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 | 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!")
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/"