...
| 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 Condition should be a mathematic expression that results in true or false or a function, such as EQUALS/EMPTY which has a true or false as a result
| ||||||||
| 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) | ||||||||
| ASIN(expression) | Returns the trigonometric ASIN of an angle | ||||||||
| COS(expression) | Returns the trigonometric cosine of an angle (in degrees) | ||||||||
| ACOS(expression) | Returns the trigonometric ACOS of an angle | ||||||||
| TAN(expression) | Returns the trigonometric tangens of an angle (in degrees) | ||||||||
| ATAN(expression) | Returns the trigonometric ATAN of an angle | ||||||||
| 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(value) | Shows file size in MB and KB, instead of long value in bytes | ||||||||
| FORMATMINSECAGO(value) | Shows minutes and seconds ago since the given timestamp | ||||||||
| FORMATHOURMINSECAGO(value) | Shows hours, minutes and seconds ago since the given timestamp | ||||||||
| FORMATHOURMINAGO(value) | Formats given timestamp value as a string with hours and minutes | ||||||||
| FORMATDAYSAGO(value) | Shows days ago since the given timestamp | ||||||||
| FORMATDATEAS(value, format) | Formats date in given format (format pattern should be https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html) | ||||||||
| USER() | Returns current user full name | ||||||||
| USERNAME() | Returns current user username | ||||||||
| EMPTY(value) | Checks if given value is empty | ||||||||
| NOTEMPTY(value) | Checks if given value is not empty | ||||||||
| LEN(value) | Calculates length for given value (length = number of characters) | ||||||||
| LENGTH(value) | Same as LEN(value) | ||||||||
| FORMATNUMBER(value, format) | Where format is a pattern as described here https://docs.oracle.com/javase/7/docs/api/java/text/DecimalFormat.html. Example: FORMATNUMBER([entry.f1], "###,###.00") | ||||||||
| ZEROIFEMPTY("value") | If value is empty, then it will be passed further as 0. Useful when you might have an empty value for a field but would like to format it with FORMATNUMBER function for example | ||||||||
EQUALS(value1, value2) EQUALS("value1", "value2") | Compares two values. Return true if values are equal and false otherwise First example works when values are numeric (EQUALS(value1, value2)), while the 2nd example works for "text" values (EQUALS("value1", "value2")) | ||||||||
CONCAT("value1", "value2")
CONCAT("value1", "value2", <any_number of arguments>) | Will concatenate values together into one Since version 3.5.3 you can supply any number of arguments to CONCAT function For versions before the mentioned please use nestingÂ
| ||||||||
MATCHES("value", regExpPattern)
| Returns true if a given value matches the regular expression given |
...