Carrot reference
Operators

!= (not-equals)

Returns all records where the value of a given field and a given expression are not the same.

Syntax

expression1 != expression2

Sample usage

tenure!=3 returns all records where tenure is not 3.

department!="engineering" returns all records where department is not engineering.

startDate!=('2021-01-01') returns all records where startDate is not 01/01/2021.

Supported data types

  • Evaluated expressions can be of any type.
  • String comparisons are case-insensitive.
  • If either side of the comparison is a List then the comparison will return true if there are any values in common.

See also



Updated 04 Oct 2023
Doc contributor
Doc contributor
Did this page help you?