...
Function* | Description | ||
---|---|---|---|
NOT(expression) | Boolean negation, 1 (means true) if the expression is not zero | ||
IF(condition,value_if_true,value_if_false) | Returns one value if the condition evaluates to true or the other if it evaluates to false | ||
RANDOM() | Produces a random number between 0 and 1 | ||
MIN(e1,e2) | Returns the smaller of both expressions | ||
MAX(e1,e2) | Returns the bigger of both expressions | ||
ABS(expression) | Returns the absolute (non-negative) value of the expression | ||
ROUND(expression,precision) | Rounds a value to a certain number of digits, uses the current rounding mode | ||
FLOOR(expression) | Rounds the value down to the nearest integer | ||
CEILING(expression) | Rounds the value up to the nearest integer | ||
LOG(expression) | Returns the natural logarithm (base e) of an expression | ||
SQRT(expression) | Returns the square root of an expression | ||
SIN(expression) | Returns the trigonometric sine of an angle (in degrees) | ||
COS(expression) | Returns the trigonometric cosine of an angle (in degrees) | ||
TAN(expression) | Returns the trigonometric tangens of an angle (in degrees) | ||
SINH(expression) | Returns the hyperbolic sine of a value | ||
COSH(expression) | Returns the hyperbolic cosine of a value | ||
TANH(expression) | Returns the hyperbolic tangens of a value | ||
RAD(expression) | Converts an angle measured in degrees to an approximately equivalent angle measured in radians | ||
DEG(expression) | Converts an angle measured in radians to an approximately equivalent angle measured in degrees | ||
FORMATDATE(expression) | Formats date (timestamp) using date format configured in Confluence | ||
FORMATDATETIME(expression) | Formats datetime (timestamp) using datetime format configured in Confluence | ||
NOW() | Useful for tracking last updated timestamps (could be used together with FORMATDATE or FORMATDATETIME) see below | ||
FORMATFILESIZE(expression) | Shows file size in MB and KB, instead of long value in bytes | ||
FORMATMINSECAGO(expression) | Shows minutes and seconds ago since the given timestamp | ||
FORMATHOURMINSECAGO(expression) | Shows hours, minutes and seconds ago since the given timestamp | ||
FORMATDAYSAGO(expression) | Shows days ago since the given timestamp | ||
USER | Returns current user full name | ||
USERNAME | Returns current user username |
*Functions names are case insensitive.
...