Returns all records where the value of a given field and a given expression are not the same.
expression1 != expression2
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.
- 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.