Guide To Writing Queries
Operators
12 min
each operator can also be prefixed by not not , which denotes its negation, e g not = not = , not smaller than not smaller than , etc equality the rhs can be either a field or a value symbol example = = , equal equal comparison the rhs can be either a field or a value symbol example smaller than smaller than , < < larger than larger than , > > smaller than or equal smaller than or equal , <= <= larger than or equal larger than or equal , >= >= between the between between operator expects two arguments on the guide to writing queries docid\ zbj6atbbc9 s7nlsnwchh the arguments can be separated by either a comma , or semicolon ; either, or both, of the rhs arguments can be fields x x between between y y , z z is equivalent to x x >= >= y y and and x x <= <= z z membership in the in in operator expects one or more arguments on the rhs it tests whether the guide to writing queries docid\ zbj6atbbc9 s7nlsnwchh argument is equal to any of the rhs arguments any of the rhs arguments can be fields contains the contains contains operator tests whether the lhs argument contains the value on the rhs it is not case sensitive ( "abc" "abc" is the same as "abc" "abc" , "abc" "abc" , "abc" "abc" etc ) the rhs cannot be a field , only a value text the rhs cannot be a field, only a value symbol example starts with starts with ends with ends with temporal the rhs can be either a field or a value between between for temporal fields is equivalent to x x on or after on or after y y and and x x before or on before or on z z symbol example strictly before strictly before strictly after strictly after before or on before or on on or after on or after between between emptiness the empty empty operator does not have a rhs for example, the following query searches for all records that have an empty description description it can also be used on links, in which case it means "has no linked records of that type" for example, if used in the accounts module, the following query searches for accounts that have no opportunities