Relational Operators in QBE
Relational operators in QBE are comparison operators that allows you to evaluate or check the relationship between two values, returning a Boolean result which allows filtering, searching or sorting the data in your queries.
| GraphQL QBE Relational Operator | Equivalent SQL Operator |
|---|---|
_eq and
_ne |
Equivalent to '=' and
'!='.
|
_lt and
_lte |
Equivalent to '<' and
'<='.
|
_gt and
_gte |
Equivalent to '>' and
'>='.
|
_like |
Equivalent to 'like'.
|
_is_null |
Equivalent to 'where <field> is
null'. Example - Office: {_is_null:
TRUE} |
_in, _nin, and
_between |
Equivalent to IN, NOT
IN, and BETWEEN |