Greater Than ‘>’

The binary operator ‘>’ is used to evaluate whether the first value is greater 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., 16 > 15.00 returns true)

  • Date/DateTime comparisons: Both Date and DateTime values can be compared; Date values ignore time components

  • 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 > 14)",
  "Operator_>_4": "$value((Int1 > 15) == false)",

  "Operator_>_5": "$value(Int1 > 14.00)",
  "Operator_>_6": "$value((Int1 > 15.1) == false)",

  "Operator_>_7": "$value(Double1 > 15.20)",
  "Operator_>_8": "$value((Double1 > Double2) == false)",

  "Operator_>_9": "$value(ToDate('2022-06-23T18:25:43.511Z') > ToDate('2022-05-23T18:25:43.511Z'))",
  "Operator_>_10": "$value(ToDate('2022-06-23T18:25:43.511Z') > ToDate('2022-07-23T18:25:43.511Z') == false)",

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

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

  "Operator_>_15": "$value(Text1 > 'Text0')",
  "Operator_>_16": "$value(Text1 > 'Text2' == false)"
}