Less Than of Equals ‘<=’

The binary operator ‘<=’ is used to evaluate whether the first value is less 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., ToDate(‘2022-06-23T18:25:43.511Z’) <= ToDateTime(‘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 <= 16)",
  "Operator_<=_5": "$value((Int1 <= 14) == false)",

  "Operator_<=_6": "$value(Int1 <= 15.00)",
  "Operator_<=_7": "$value(Int1 <= 16.00)",
  "Operator_<=_8": "$value((Int1 <= 14.9) == false)",

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

  "Operator_<=_12": "$value(ToDate('2022-05-23T18:25:43.511Z') <= ToDate('2022-05-23T18:25:43.511Z'))",
  "Operator_<=_13": "$value(ToDate('2022-05-23T18:25:43.511Z') <= ToDate('2022-06-23T18:25:43.511Z'))",
  "Operator_<=_14": "$value(ToDate('2022-06-23T18:25:43.511Z') <= ToDate('2022-05-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-05-23T18:25:43.511Z') <= ToDate('2022-06-23T18:25:43.511Z'))",
  "Operator_<=_17": "$value(ToDateTime('2022-06-23T18:25:43.511Z') <= ToDateTime('2022-05-23T18:25:43.511Z') == false)",

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

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