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 |