Skip to main content

ComparisonOperator

@webda/ql

Type Alias: ComparisonOperator

ComparisonOperator = "=" | "<=" | ">=" | "<" | ">" | "!=" | "LIKE" | "IN" | "CONTAINS" | "IS NULL" | "IS NOT NULL"

Defined in: packages/ql/src/query.ts:495

All supported comparison operators

  • = / != use loose equality (== / !=)
  • <, <=, >, >= use standard JS comparison
  • LIKE uses SQL-style pattern matching (% = any chars, _ = single char)
  • IN checks membership in a set (field IN ['a', 'b'])
  • CONTAINS checks if an array field contains a value (field CONTAINS 'a')
  • IS NULL matches a missing, undefined or null field (field IS NULL)
  • IS NOT NULL matches any other value (field IS NOT NULL)