Negation expression that inverts the result of another expression.
Matches objects that do NOT match the contained expression. Use this to
exclude objects based on certain criteria, such as "not closed" or
"not in a specific list of values".
The NOT operator can be applied to any type of expression, including
basic comparisons, AND/OR combinations, and IN expressions.
Negation expression that inverts the result of another expression.
Matches objects that do NOT match the contained expression. Use this to exclude objects based on certain criteria, such as "not closed" or "not in a specific list of values".
The NOT operator can be applied to any type of expression, including basic comparisons, AND/OR combinations, and IN expressions.
Example: Find all deals that are NOT closed
Example: Find companies that are NOT in specific industries
Example: Complex, NOT (status is closed AND value under 1000)
See