!= (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 = (equals) docid 50o8vwta5zp6sv8dqdwjl != (not equals) docid\ g6prxutgm2vrcnw7hcqry ! (not) docid\ hdagli50afseam4jx6b8n