Equals ‘==’

The binary operator ‘==’ is used to evaluate whether two values are equal in JsonQL expressions. It returns a boolean result (true or false).

Operator Priority: 600

Operator Operands

  • Operand 1:

    • Type: any valid JsonQL expression (including invalid path).

    • Description: Any valid JsonQL expression.

  • Operand 2:

    • Type: any valid JsonQL expression (including invalid path).

    • Description: Any valid JsonQL expression.

Type Comparison Rules

  • Numeric comparisons: Integer and double values can be compared (e.g., 15 == 15.00 returns ‘true’)

  • String comparisons: Must be exact matches; no type coercion (e.g., 15 == ‘15’ returns false)

  • Boolean comparisons: Must match exactly; no string conversion (e.g., true == ‘true’ returns false)

  • Date/DateTime comparisons: Date values ignore time components (e.g., ToDate(‘2022-05-23’) equals ToDate(‘2022-05-23T18:25:43.511Z’))

  • Undefined values: Any comparison with undefined returns ‘false’

Examples

{
  "Comment_Operator_==_1": "(15 == invalid.path) is evaluated to false",
  "Operator_==_1": "$value((15 == invalid.path) == false)",
  "Comment_Operator_==_2": "(e.SalaryInvalid == 100000) is evaluated to false for all employees",
  "Operator_==_2": "$value(Count(Companies.Select(c => c.Employees.Where(e => e.SalaryInvalid == 100000))) == 0)",

  "Operator_==_3": "$value(15 == Int1)",
  "Operator_==_4": "$value((15 == '15') == false)",

  "Operator_==_5": "$value(15.00 == Int1)",
  "Operator_==_6": "$value((15.01 == Int1) == false)",

  "Operator_==_7": "$value(TrueValue == true)",
  "Operator_==_8": "$value((TrueValue == 'true') == false)",

  "Operator_==_9": "$value(FalseValue == false)",
  "Operator_==_10": "$value((FalseValue == 'false') == false)",

  "Operator_==_11": "$value(ToDate('2022-05-23') == ToDate('2022-05-23T18:25:43.511Z'))",
  "Operator_==_12": "$value((ToDate('2022-05-23') == ToDate('2022-06-23T18:25:43.511Z')) == false)",

  "Operator_==_13": "$value(Text1 == 'Text1')",
  "Operator_==_14": "$value(Text1 == 'TExt1' == false)"
}