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