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. |
Example:
ACCESS(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!")