Expr provides basic arithmetic operations, comparisons, text operations and logical operations.
|
Operations |
Comments |
|---|---|
|
|
Basic operators. When used, the value is converted to a number. Follows the general precedence rules for arithmetic, so (2 + 3 * 4 = 14). |
|
|
Equality and non-equality: if either part of the comparison is a number, the other part is also converted into a number. If both values are texts, then text comparison is used. Text comparison ignores leading and trailing whitespace and is case-insensitive (according to Jira's system locale). |
|
|
Numerical comparisons. When used, both values are converted to numbers. |
|
|
Logical operations. |
|
|
An operation that joins together two text strings. Works similar to the function of the same name: |
|
|
Parentheses can be used to group the results of operations prior to passing them to other operations. |
Order of Operations
When several types of operations are used, they are done in the following order:
-
Arithmetic operations
-
Text operations (CONCAT)
-
Comparison operations
-
Logical operations.
For detailed specification, see Expr Advanced Reference .