You are viewing the documentation for Blueriq 15. Documentation for other versions is available in our documentation directory.
EQUAL (=)
The operator '=' compares two values and returns the boolean value TRUE if the left value is equal to the right value and FALSE otherwise.
Syntax
value1 = value2
Inputs
value1 - Number, date or attribute of some type of number or date.
value2 - Number, date or attribute of some type of number or date.
When one or both values are a set, the '=' operator is translated to SUBSET OF:
"a" = ["a", "b"]
is equivalent to"a" SUBSET OF ["a","b"]
, which returns true["a", "b"] = "a"
is also equivalent to"a" SUBSET OF ["a","b"]
, note that the arguments are switched. Because we have a set and a single value, there is only one way to interpret this with theSUBSET OF
function.["a"] = ["a", "b"]
is equivalent to["a"] SUBSET OF ["a","b"]
, which returns true["a", "b"] = ["a"]
is equivalent to["a", "b"] SUBSET OF ["a"]
, which returns false. (note that if "set1 = set2" returns true, it does not mean that "set2 = set1" will also return true)
To test if two sets are equal you could use the expression:
L1 SUBSET OF L2 AND L2 SUBSET OF L1
Return type
boolean
Examples
Expression | Result | Type |
---|---|---|
1 = 2 | FALSE | Boolean |
1.0 = 1.0 | TRUE | Boolean |
DATE( 2012 , 1 , 1 ) = TODAY | FALSE | Boolean |
5 + 5 = 10 | TRUE | Boolean |
Overview
Content Tools