The following comparison operators are applicable to String and String List types. This operators have the peculiarity that ignores the case of the characters.
OPERATOR | MEANING | EXAMPLES (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. |
!~~ |
doesn't 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~ |
isn't 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 |
COMPARISON OPERATOR | Boolean | Number | String | Number List | String List | Issue List | Multi-Valued Fields |
---|---|---|---|---|---|---|---|
=~ |
- | - | X | - | X | - | - |
!=~ |
- | - | X | - | X | - | - |
~~ |
- | - | X | - | X | - | - |
!~~ |
- | - | X | - | X | - | - |
in~ |
- | - | X | - | X | - | - |
not in~ |
- | - | X | - | X | - | - |
any in~ |
- | - | - | - | X | - | - |
none in~ |
- | - | - | - | X | - | - |
WARNING!: If you are currently using field "Target status" in conditions (not validators nor post-functions), you should replace it with field "Available target statuses" in order to keep the exact same behavior.
# This is a comment
. fieldHistory()
failed with certain fields when used in Calculated Fields.