Page History

Versions Compared

Old Version 26

changes.mady.by.user Christian Czaia

Saved on Mar 04, 2020

compared with

New Version Current

changes.mady.by.user Marcel Frank

Saved on Apr 05, 2023

Key

This line was added.
This line was removed.
Formatting was changed.

Page properties

hidden	true

Status

Tech review

Status

title
colour	Green

todo

done

Style guide

Status

colour	Green
title	done

Page status

Status

title

colour	Green

todo

complete

Status

title	todo

Status

colour	Yellow
title	Ready for review

Status

colour	Green
title	done

Status

colour	Red
title	flagged

Panel

Comparison operators

The operators, their meaning and the application applicable data types you can use them with are listed below.

UI Text Box

type	tip

A comparison always returns a

Status

subtle	true
title	boolean

value.

[

UI Expand

title	Overview of all case-sensitive comparison operators

UI Text Box

type	info

All operators respect the case of the characters.

Operator Meaning Examples (all examples return true)

=

equal to

Code Block

language	bash
linenumbers	true

1=1
true = true

//comment


[1, 2, 3] = [1, 2, 3]

Code Block
true = true

Code Block
[1, 2, 3] = [1, 2, 3]

Code Block


["blue", "red", "green"] = ["blue", "red", "green"]

UI Text Box

type	info

When working with

lists

Lists, each elements' existence and its order are being evaluated.

!=

not equal to

Code Block

language	bash
linenumbers	true

0 != 1


"HELLO" != "Hello"


%{issue.description} != "Hello"


true != false


[1, 2, 3] != [1, 3, 2]


["blue", "red", "green"] != ["blue", "green", "red"]

UI Text Box

type	info

When working with

lists

Lists, each elements' existence and its order are being evaluated.

<

lower

less than

Code Block

language	bash
linenumbers	true

1 < 2


"abc" < "bbc"


"abc" < "abcd"

>

greater than

Code Block

2 > 1

language	bash
linenumbers	true

2 > 1
"bbc" >

"bbc" >

"abc"


"abcd" > "abc"

<=

less than or equal to

Code Block

language	bash
linenumbers	true

3 <= 3

>=

greater than or equal to

Code Block

language	bash
linenumbers	true

"Hello world! Hello *" >= "Hello world"

~

contains

Code Block

language	bash
linenumbers	true

"Hello world!" ~ "world"

, checks whether a string contains a substring.

 #true. The text "world" is contained in the first text.
%{issue.components.leads} ~ %{system.currentUser}

, checks

 #checks whether "Component leads" contains the "Current user".


[1, 2, 3, 2, 2, 4] ~ [2, 1, 2]

, when used with lists cardinalities of every single instance of an element must match.["blue", "red", "green",

 #true
["blue", "red", "green", "red", "white", "red"] ~ ["red", "green", "red"]

(

 #true
["green", "red"] ~ ["red", "green", "red"]

) = false

 #false

!~

does not contain

Code Block

language	bash
linenumbers	true

"Hello world!" !~ "

Hello

world

!" %{issue.fixVersions} !~

" #false. The text "world" is contained in the first text.
%{issue.fixVersions} !~ %{issue.versions}

, checks whether "Fix

 #false if all "Affects version/s"

doesn't contain all versions in "Affects

 are also selected as "Fix version/s".


[1, 2, 3, 2, 2, 4] !~ [2, 1, 1, 4]

, when used with lists cardinalities of every single instance of an element must match.

 #true
["blue", "red", "green", "red", "red"] !~ ["red", "green", "green", "red"] #true

in

is contained in

Code Block

language	bash
linenumbers	true

"world" in "Hello world!"

, to check whether a substring is contained in a string.

 #true. The text "world" is contained in the first text.
%{system.currentUser} in %{issue.components.leads}

, checks whether "Current user" is contained in "Component leads".
[1, 1, 2] in [2, 1, 1, 1, 4] , cardinalities of every single element must match.

 #true if current user is a component lead of any of the issue's components 
[1, 1, 2] in [2, 1, 1, 1, 4] #true
["blue", "red", "red"] in ["red", "green", "blue", "red", "red"]

, cardinalities of every single instance of an element must match.
2 in

 #true
2 in [1, 2, 3]

 #true
"blue" in ["red, "blue", "white"] #true

not in

is not contained in

Code Block

language	bash
linenumbers	true

"Hello world!" not in "world"

 #true
%{issue.versions} not in %{issue.fixVersions}

, checks whether not all versions in

 #false if all "Affects version/s"

are contained in

 are also selected as "Fix version/s".


[1, 1, 2, 2] not in [2, 1, 1, 1, 4]

, cardinalities of every single element must match.

 #true
["blue", "red", "red", "blue"] not in ["red", "blue", "red", "red"]

, cardinalities of every single instance of an element must match.
5 not in

 #true 
5 not in [1, 2, 3, 3, 4]

 #true
"orange" not in ["blue", "red", "white"] #true

any in

some

any element is in

Code Block

language	bash
linenumbers	true

%{issue.versions} any in %{issue.fixVersions}

, checks whether any version in

 # true if any selected "Affects version/s"

is contained in

 has also been selected as "Fix version/s".

 
[1, 3] any in [3, 4, 5]

 #true
["blue", "white"] any in ["black", "white", "green"] #true

none in

no single element is in

Code Block

language	bash
linenumbers	true

%{issue.versions} none in %{issue.fixVersions}

, checks whether there isn't a single version "Affects

 #true if no selected "Affects version/s"

 has also been selected as "Fix version/s".

 
[1, 2] none in [3, 4, 5]

 #true
["blue", "red"] none in ["black", "white", "green"] #true

ui-

title	Overview of all case ignoring comparison operators

Info

The following comparison operators are applicable to

Status

subtle	true
title	string

and

Status

subtle	true
title	string list

data types.

All operators ignore the case of the characters.

OperatorMeaningExamples (all examples return true) =~ equal to "HELLO" =~ "Hello"
"up" =~ "UP"
["blue", "red", "green"] =~ ["Blue", "RED", "Green"] !=~ not equal to " HELLO" !=~ "Hello"
"up" !=~ "down"
("up" !=~ "UP") = false
["blue", "red"] !=~ ["Blue", "green"]
["blue", "red"] !=~ ["Red", "BLUE"]
(["blue", "red", "green"] !=~ ["Blue", "RED", "Green"]) = false ~~ contains "Hello World!" ~~ "world" , checks whether a string contains a substring.
"A small step for a man" ~~ "STEP" , checks whether a string contains a substring.
["one", "two", "three"] ~~ ["TWO", "One"] , checks whether a string list contains all the elements of another string list. !~~ does not contain "Hello World!" !~~ "bye" , checks whether a string doesn't contain a substring.
"A small step for a man" !~~ "big" , checks whether a string doesn't contain a substring.
["one", "two", "three"] !~~ ["Four"] , checks whether a string list doesn't contain one element of another string list.
(["one", "two", "three"] !~~ ["TWO"]) = false in~ is contained in "world" in~ "Hello World!" , checks whether a substring is contained in another string.
"STEP" in~ "A small step for a man" , checks whether a substring is contained in another string.
["TWO", "One"] in~ ["one", "two", "three"] , checks whether all the elements of a string list are contained in another string list. not in~ is not contained in "bye" not in~ "Hello World!" , checks whether a substring is not contained in another string.
"big" not in~ "A small step for a man" , checks whether a substring is not contained in another string.
["Four"] not in~ ["one", "two", "three"] , checks whether any of the elements of a string list are not contained in another string list.
(["TWO"] not in~ ["one", "two", "three"]) = false any in~ some element is in ["blue", "violet"] any in~ ["Blue", "Red", "Green"]
["Five", "One"] any in~ ["FOUR", "FIVE", "SIX"] none in~ no single element is in ["Orange"] any in~ ["red", "blue", "green"]
(["orange"] any in~ ["Red", "Orange"]) = false UI Expand

title	Applicable data types

Info
Below you find a comprehensive matrix of all operators and applicable data types.

Comparison Operator

Status

subtle	true
title	BOOLEAN

Status

subtle	true
title	number

Status

subtle	true
title	Text

Status

subtle	true
title	number list

Status

subtle	true
title	text list

Status

subtle	true
title	issue list

Status

subtle	true
title	MULTI-value field

=

XXXXX != XXXXXXX < XX---- > -XX---- <= -XX---- >= -XX---- ~ --XXXXX !~ --XXXXX in --XXXXX not in --XXXXX any in ---XXXX none in ---XXXX =~ --X-X-- !=~ --X-X-- ~~ --X-X-- !~~ --X-X-- in~ --X-X-- not in~ --X-X-- any in~ ----X-- none in~ ----X--

Info

title	Things to be aware of

Please be aware the both operators of the respective comparison must have the same data type. The only exceptions are the following:

Automatic casting from Number to String: Whenever you write a numeric term at the right-hand side of a comparison operator like =, and the left-hand side is occupied by a string term, the parser will automatically transform the right-hand side term into a string (e.g. "30" = 30 will be interpreted the same way as "30" = "30")
Single values as operator in list operations: Operators ~, !~, in and not in can be used for checking a single element (number or string) against a
Status
subtle true
title number list
or a
Status
subtle true
title text list
Comparison with the null value: A field which is not set or an empty string is interpreted as null. A field returning
Status
subtle true
title number
, which doesn't contain a number, is also interpreted as null.

UI Expand

title	Things to remember

NoteRememberExampleOperators ~, !~, in and not in can be used for checking a single element (number or text) against a number list or a text list

1 in [1, 2, 3]
["blue", "red"] ~ "blue" .

Operators ~, !~, in and not in when used with a text are useful to look for substrings in another string.

"I love coding" ~ "love"
"I don't like Mondays" !~ "Fridays"
"love" in "I love coding"
"Fridays" not in "I don't like Mondays".

Operators ~, !~, in and not in respect cardinality, i.e., container list must have at least the same number of elements as contained list.

[1, 1] in [1, 1, 1]
[1, 1] not in [1, 2, 3] .

Operators = and != , when used for comparing lists, require to have the same elements, with the same cardinality and the same order.

[1, 2, 3] = [1, 2, 3]
[4, 5, 6] != [4, 6, 5] .

Operators <, >, <= and >= work according to lexicographical order when comparing strings.

Image RemovedLogical operators

The table below lists all logical operators that can be used for linking logical terms in an expression.

Logical operators take logical terms (which return

Status

subtle	true
title	boolean

values) as operands and can thus be built using:

a boolean value
a comparison
a logical term enclosed by brackets ()
two logical terms connected with a logical operator, where boolean literals and comparisons themselves are logical terms

UI Expand

title	Overview of all logical operators

Operator

Meaning

Precedence

NOT or ! logical negation1 (highest) AND or & logical conjunction2 OR or | logical disjunction3 XOR exclusive or, i.e., a XOR b is equivalent to a AND !b OR !a AND b 3 IMPLIES or IMP logical implication, i.e., a IMPLIES b is equivalent to !a OR b 4 XNOR or EQV logical equivalence, i.e., a EQV b is equivalent to a IMPLIES b AND b IMPLIES a 4 (lowest)

Info

A single logical term can be enclosed by brackets () in order to increase the readability of the expressions or to define a precedence which differs from the given one.

Logical operators can also be written in lower case (e.g. and, or)

Image RemovedConditional operator (IF - THEN -ELSE)

The conditional operator ? : is a powerful operator to construct conditional expressions.

It basically allows you to construct the following expression: IF boolean_expression true THEN term_1 ELSE term_2.

Code Block

linenumbers	true

<boolean_expression> ? <term_1> : <term_2>

UI Text Box

type	tip

The conditional operator is extremely helpful when being used in calculated fields.

UI Expand

title	Examples of using the conditional operator

ExpressionDescription

Code Block

linenumbers	true

%{issue.priority} = "Highest" ? "Please have a look at this issue immediately" : "No stress, come back later"

IF the priority of an issue is Blocker,

THEN this function will return the Statussubtletruetitletext "Please have a look at this issue immediately"ELSE it will return the Statussubtletruetitletext "No stress, come back later".

Code Block

linenumbers	true

{issue.duedate} != null ? ({...duedate} - {...currentDateTime}) / {HOUR} : 0

IF an issue does have a due date set (due date is not null),

THEN this function will return the

Status

subtle	true
title	number

of hours from the current date-time to the due date

ELSE it will return the

Status

subtle	true
title	number

0.

Code Block

linenumbers	true

%{issue.somefield} = "Red" ? "Color" : "No color"

IF a custom field (e.g. a select list) has a value of Red,

THEN this function will return the text Color,

ELSE it will return No color.

Code Block

linenumbers	true

timePart({...currentDateTime}, LOCAL) > 21:00 AND timePart({...currentDateTime}, LOCAL) < 7:00 ? "Night" : "Day"

IF the current time is between 21:00 and 7:00

THEN this function will return the Statussubtletruetitletext "Night" ,ELSE it will return the Statussubtletruetitletext "Day".

text-box

type	tip

When comparing lists, the exact number of occurence (cardinality) per element must match.

Parser expression Output Description

Code Block

language	bash
linenumbers	true

["blue", "red", "green", "red", "white", "red"] ~ ["red", "green", "red"]

true

This expression returns true , since the element (text) red appears at least twice in the first list and the element (text) green occurs at least once in the first list.

Code Block

language	bash
linenumbers	true

["green", "red"] ~ ["red", "green", "red"]

false

This expression returns false , since the element (text) red does not appear twice in the first list.

UI Expand

title	Overview of all case ignoring comparison operators

UI Text Box

type	info

The following comparison operators can be used with

Status


subtle	true
title	text

and

Status


subtle	true
title	text list

data types .

All operators ignore the case of the characters.

Operator Meaning Examples (all examples return true)

=~

equal to

Code Block

language	bash
linenumbers	true

"HELLO" =~ "Hello" #true
"up" =~ "UP" #true
["blue", "red", "green"] =~ ["Blue", "RED", "Green"] #true

!=~

not equal to

Code Block

language	bash
linenumbers	true

" HELLO" !=~ "Hello" #false, since there is a whitespace in the first text
"up" !=~ "down" #true
("up" !=~ "UP") #false 
["blue", "red"] !=~ ["Blue", "green"] #true
["blue", "red"] !=~ ["Red", "BLUE"] #true
["blue", "red", "green"] !=~ ["Blue", "RED", "Green"] #false

~~

contains

Code Block

language	bash
linenumbers	true

"Hello World!" ~~ "world" #true, checks whether a text contains a substring. 
"A small step for a man" ~~ "STEP" #true
["one", "two", "three"] ~~ ["TWO", "One"] #true, checks whether a text list contains all the elements of another text list.

!~~

does not contain

Code Block

language	bash
linenumbers	true

"Hello World!" !~~ "bye" #true, checks whether a text does not contain a substring. 
"A small step for a man" !~~ "big" #true
["one", "two", "three"] !~~ ["Four"] #true, checks whether a text list does not contain a single element of another text list. 
(["one", "two", "three"] !~~ ["TWO"]) = false

in~

is contained in

Code Block

language	bash
linenumbers	true

"world" in~ "Hello World!" #true, checks whether a substring is contained in another text. 
"STEP" in~ "A small step for a man" #true 
["TWO", "One"] in~ ["one", "two", "three"] #true, checks whether all the elements of a text list are contained in another text list.

not in~

is not contained in

Code Block

language	bash
linenumbers	true

"bye" not in~ "Hello World!" #true, checks whether a substring is not contained in another text. 
"big" not in~ "A small step for a man" #true
["Four"] not in~ ["one", "two", "three"] #true, checks whether any of the elements of a text list are not contained in another text list. 
["TWO"] not in~ ["one", "two", "three"] #false

any in~

any element is in

Code Block

language	bash
linenumbers	true

["blue", "violet"] any in~ ["Blue", "Red", "Green"] #true
["Five", "One"] any in~ ["FOUR", "FIVE", "SIX"]"bye" #true

none in~

no single element is in

Code Block

language	bash
linenumbers	true

["Orange"] none in~ ["red", "blue", "green"] #true, checks whether none of the elements of a text list are not contained in another text list. 
["orange"] none in~ ["Red", "Orange"] #false

UI Expand

title	Applicable data types

Below you find a comprehensive matrix of all operators and applicable data types .

Comparison Operator

Status

subtle	true
title	BOOLEAN

Status

subtle	true
title	number

Status

subtle	true
title	Text

Status

subtle	true
title	number list

Status

subtle	true
title	text list

Status

subtle	true
title	issue list

=

!=

< - - - -

> - - - -

<= - - - -

>= - - - -

~ - -

!~ - -

in - -

not in - -

any in - - -

none in - - -

=~ - - - -

!=~ - - - -

~~ - - - -

!~~ - - - -

in~ - - - -

not in~ - - - -

any in~ - - - - -

none in~ - - - - -

UI Text Box

title	Things to be aware of
type	info

Please be aware the both operands of the respective comparison must have the same data type. The only exceptions are the following:

Automatic casting from
Status
subtle true
title number
to
Status
subtle true
title text
: Whenever you write a numeric term at the right-hand side of a comparison operator like =, and the left-hand side is occupied by a text term, the parser will automatically transform the right-hand side term into a text (e.g. "30" = 30 will be interpreted the same way as "30" = "30")
Single values as operand in list operations: Operators ~, !~, in and not in can be used for checking a single element (
Status
subtle true
title number
or
Status
subtle true
title text
) against a
Status
subtle true
title number list
or a
Status
subtle true
title text list
Comparison with the null value: A field which is not set or an empty text is interpreted as null. A
Status
subtle true
title number
field, which doesn't contain a number, is also interpreted as null .

UI Expand

title	Things to remember

Remember Examples

Operators ~, !~, in and not in can be used for checking a single element (

Status

subtle	true
title	number

or
Status
subtle true
title text
) against a

Status

subtle	true
title	number list

or a

Status

subtle	true
title	text list

Code Block

language	bash
linenumbers	true

1 in [1, 2, 3] 
["blue", "red"] ~ "blue"

Operators ~, !~, in and not in when used with a text are useful to look for substrings in another string.

Code Block

language	bash
linenumbers	true

"I love coding" ~ "love"
"I don't like Mondays" !~ "Fridays"
"love" in "I love coding"
"Fridays" not in "I don't like Mondays"

Operators ~, !~, in and not in respect cardinality, i.e., container list must have at least the same number of elements as contained list.

Code Block

language	bash
linenumbers	true

[1, 1] in [1, 1, 1]
[1, 1] not in [1, 2, 3]

Operators = and != , when used for comparing lists, require to have the same elements, with the same cardinality and the same order.

Code Block

language	bash
linenumbers	true

[1, 2, 3] = [1, 2, 3]
[4, 5, 6] != [4, 6, 5]

Operators <, >, <= and >= work according to lexicographical order when comparing text.

Code Block

language	bash
linenumbers	true

1 < 2
"abc" < "bbc"
"abcd" > "abc"

Image AddedLogical operators

The table below lists all logical operators that can be used for linking logical terms in an expression.

Logical operators take logical terms (which return

Status

subtle	true
title	boolean

values) as operands and can thus be built using:

a boolean value
a JWT expression parser function returning a boolean value
a comparison
a logical term enclosed by brackets ()
two logical terms connected with a logical operator, where boolean literals and comparisons themselves are logical terms.

UI Text Box

type	note

Logical operators can only be used in logical expressions in the Logical mode or in combination with the conditional operator.

UI Expand

title	Overview of all logical operators

Operator	Meaning	Precedence
`NOT` or `!`	logical negation	1 (highest)
`AND` or `&`	logical conjunction	2
`OR` or `\|`	logical disjunction	3
`XOR`	exclusive or, i.e., `a XOR b` is equivalent to `a AND !b OR !a AND b`	3
`IMPLIES` or `IMP`	logical implication, i.e., `a IMPLIES b` is equivalent to `!a OR b`	4
`XNOR` or `EQV`	logical equivalence, i.e., `a EQV b` is equivalent to `a IMPLIES b AND b IMPLIES a`	4 (lowest)

UI Text Box

type	info

A single logical term can be enclosed by brackets () in order to increase the readability of the expressions or to define a precedence which differs from the given one.

Logical operators can also be written in lower case (e.g. and , or )

Image AddedConditional operator

The conditional operator ? : is a powerful operator to construct conditional expressions.

It basically allows you to construct the following expression: IF logical_expression true THEN term_1 ELSE term_2.

Code Block

linenumbers	true

<logical_expression> ? <term_1> : <term_2>

Image Added

UI Text Box

type	tip

The conditional operator is extremely helpful when being used in calculated fields.

UI Expand

title	Examples of using the conditional operator

Expression Description

Code Block

linenumbers	true

%{issue.priority} = "Highest" ? "Please have a look at this issue immediately" : "No stress, come back later"

IF the priority of an issue is Blocker,

THEN this function will return "Please have a look at this issue immediately"

ELSE it will return "No stress, come back later".

Code Block

linenumbers	true

{issue.duedate} != null ? ({...duedate} - {...currentDateTime}) / {HOUR} : 0

IF an issue does have a due date set (due date is not null),

THEN this function will return the number of hours from the current date-time to the due date

ELSE it will return 0 .

Code Block

linenumbers	true

%{issue.somefield} = "Red" ? "Color" : "No color"

IF a custom field (e.g. a select list) has a value of Red,

THEN this function will return "Color",

ELSE it will return "No color".

Code Block

linenumbers	true

timePart({...currentDateTime}, LOCAL) > 21:00 AND timePart({...currentDateTime}, LOCAL) < 7:00 ? "Night" : "Day"

IF the current time is between 21:00 and 7:00

THEN this function will return "Night" ,

ELSE it will return "Day".

Image AddedList operators

Page properties report

firstcolumn	Function
headings	Short description, Output
cql	label = "list_managment_operator" and space = currentSpace()

UI Expand

title	Order of operations

If you use multiple operators in a single expression, they will follow a certain order in which they are processed or a precedence.

OPERATORS	PRECEDENCE	ASSOCIATIVITY
INTERSECT	1 (highest)	Left-to-right
APPEND, EXCEPT, UNION	2 (lowest)	Left-to-right

UI Text Box

type	tip

When using the list operators, you have to make sure that both lists that you compare are of the same type.
All operators are case insensitive, i.e., they can also be written in lower case: append, union, intersect and except .
There are four equivalent functions available for each type of list, and their behavior is exactly equivalent to that of its corresponding operator.
This way, you can choose to use operators or functions according to your preference. Although operators yield shorter expressions and with fewer parentheses, the usage of functions produces a more functional consistent syntax.

Excerpt Include

	DECADIS:Contact support
	DECADIS:Contact support
nopanel	true

Content

Space Tools

Versions Compared

Old Version 26

New Version Current

Key

On this page

Comparison operators

Image RemovedLogical operators

Image RemovedConditional operator (IF - THEN -ELSE)

Image AddedLogical operators

Image AddedConditional operator

Image AddedList operators