Operators

• Number of operators are supported in JsonQL. All of them are described in sections below.

• New operators can be added or existing ones can be modified by providing custom implementations of some interfaces in dependency injection setup (like everything else in JsonQL).

• JsonQL operators are assigned numeric priorities which determine the order in which operators are applied, if braces are not used to change operator execution order.

  Operators assigned smaller priority values are executed before operators with higher values of priorities.

  Note

  Operator priorities are set in constructor of JsonQL.Compilation.UniversalExpressionParserJsonQL.JsonQLExpressionLanguageProvider.

  For example arithmetic operators ‘+’ and ‘-‘ have a priority 500 and operators ‘*’ and ‘/’ have a priority 400. Because of differences in priorities of these operators, the expression “x + 2*z” will be evaluated to the same value as the expression “x + (2*z)”. To change the execution order of operators in this examples, braces can be used, as in this expression: “(x + 2) * z”.

• Arithmetic Operators
  • Add ‘+’
    • Operator Operands
    • Examples
  • Subtract ‘-‘
    • Operator Operands
    • Examples
  • Multiply ‘*’
    • Operator Operands
    • Examples
  • Divide ‘/’
    • Operator Operands
    • Examples
  • Modulus ‘%’
    • Operator Operands
    • Examples
  • Negate ‘-‘
    • Operator Operands
    • Examples
  • Examples
• Comparison Operators
  • Equals ‘==’
    • Operator Operands
    • Type Comparison Rules
    • Examples
  • Not Equals ‘!=’
    • Operator Operands
    • Type Comparison Rules
    • Examples
  • Less Than ‘<’
    • Operator Operands
    • Type Comparison Rules
    • Examples
  • Less Than of Equals ‘<=’
    • Operator Operands
    • Type Comparison Rules
    • Examples
  • Greater Than ‘>’
    • Operator Operands
    • Type Comparison Rules
    • Examples
  • Greater Than or Equals ‘>=’
    • Operator Operands
    • Type Comparison Rules
    • Examples
  • Examples
• Logical Operators
  • And ‘&&’
    • Operator Operands
    • Evaluation Rules
    • Short-circuit Evaluation
    • Examples
  • Or ‘||’
    • Operator Operands
    • Evaluation Rules
    • Short-circuit Evaluation
    • Examples
  • Negate ‘!’
    • Operator Operands
    • Evaluation Rules
    • Examples
  • Examples
• Text Matching Operators
  • ‘contains’
    • Operator Operands
    • Evaluation Rules
    • Examples
  • ‘starts with’
    • Operator Operands
    • Evaluation Rules
    • Examples
  • ‘ends with’
    • Operator Operands
    • Evaluation Rules
    • Examples
  • Examples
• Value is Null or Undefined Check Operators
  • ‘is null’
    • Operator Operands
    • Evaluation Rules
    • Examples
  • ‘is not null’
    • Operator Operands
    • Evaluation Rules
    • Examples
  • ‘is undefined’
    • Operator Operands
    • Evaluation Rules
    • Examples
  • ‘is not undefined’
    • Operator Operands
    • Evaluation Rules
    • Examples
  • Examples
• Other Operators
  • ‘assert’
    • Syntax
    • Operator Operands
    • Evaluation Rules
    • Use Cases
    • Implementation Details
    • Best Practices
    • Notes
    • Examples
  • Default Value ‘:’
    • Syntax
    • Operator Operands
    • Evaluation Rules
    • Return Value
    • Use Cases
    • Implementation Details
    • Best Practices
    • Notes
    • Examples
  • Arrow Function ‘=>’
    • Syntax
    • Operator Operands
    • Common Usage Patterns
    • Evaluation Rules
    • Use Cases
    • Examples
      • Filtering with Where
      • Projection with Select
      • Complex Filtering
      • Nested Property Access
      • Sorting with OrderBy
      • Conditional Checks
      • Chaining Operations
      • Lambda with Calculations
    • Best Practices
    • Notes
    • Advanced Examples
      • Filtering with Multiple Conditions
      • Nested Collection Processing
      • Conditional Expressions
  • Named Parameter ‘->’
    • Syntax
    • Operator Operands
    • Named Parameter Structure
    • Evaluation Rules
    • Advantages of Named Parameters
    • Use Cases
    • Examples
      • Basic Named Parameter Usage
      • Multiple Named Parameters
      • Order Independence
      • Skipping Optional Parameters
      • Mixed Named and Positional
      • Complex Expressions as Values
      • Improving Readability
      • Date/Time Functions
      • String Manipulation
      • Mathematical Functions
    • Best Practices
    • Notes
    • Comparison with Positional Parameters
    • Error Scenarios
      • Invalid Parameter Name
      • Duplicate Parameter
      • Mixed Order Error
  • ‘typeof’
    • Syntax
    • Operator Operands
    • Return Values
    • Evaluation Rules
    • Use Cases
    • Implementation Details
    • Best Practices
    • Notes
    • Examples