...
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 |
...