Greater Than or Equals ‘>=’

The binary operator ‘>=’ is used to evaluate whether the first value is greater or equal than the second value in JsonQL expressions. It returns a boolean result (true or false) for valid comparisons, or undefined when the comparison cannot be performed.

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)

• Date/DateTime comparisons: Both Date and DateTime values can be compared; Date values ignore time components (e.g., ToDate(‘2022-05-23T18:25:43.511Z’) >= ToDate(‘2022-05-23T18:25:43.511Z’) returns true)

• Date with DateTime comparisons: When comparing Date with DateTime, the Date is treated as having a time component (e.g., ToDateTime(‘2022-06-23T18:25:43.511Z’) >= ToDate(‘2022-06-23T18:25:43.511Z’) returns true)

• String comparisons: Strings are compared lexicographically

• Undefined values: Any comparison with undefined returns undefined

• Incompatible types: Comparisons between incompatible types (e.g., number with string, boolean with number) return undefined

Examples

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

  "Operator_>=_3": "$value(Int1 >= 15)",
  "Operator_>=_4": "$value(Int1 >= 14)",
  "Operator_>=_5": "$value((Int1 >= 16) == false)",

  "Operator_>=_6": "$value(Int1 >= 15.00)",
  "Operator_>=_7": "$value(Int1 >= 14.00)",
  "Operator_>=_8": "$value((Int1 >= 15.1) == false)",

  "Operator_>=_9": "$value(Double1 >= 15.25)",
  "Operator_>=_10": "$value(Double1 >= 15.24)",
  "Operator_>=_11": "$value((Double1 >= 15.26) == false)",

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

  "Operator_>=_15": "$value(ToDateTime('2022-05-23T18:25:43.511Z') >= ToDateTime('2022-05-23T18:25:43.511Z'))",
  "Operator_>=_16": "$value(ToDateTime('2022-06-23T18:25:43.511Z') >= ToDate('2022-05-23T18:25:43.511Z'))",
  "Operator_>=_17": "$value(ToDateTime('2022-05-23T18:25:43.511Z') >= ToDateTime('2022-06-23T18:25:43.511Z') == false)",

  "Operator_>=_18": "$value(ToDate('2022-06-23T18:25:43.511Z') >= ToDateTime('2022-05-23T18:25:43.511Z'))",
  "Operator_>=_19": "$value(ToDateTime('2022-06-23T18:25:43.511Z') >= ToDate('2022-06-23T18:25:43.511Z'))",

  "Operator_>=_20": "$value(Text1 >= 'Text1')",
  "Operator_>=_21": "$value(Text1 >= 'Text0')",
  "Operator_>=_22": "$value(Text1 >= 'Text2' == false)"
}