Operators

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 \[ first name first name ] equal equal "john" "john" comparison the rhs can be either a field or a value symbol example smaller than smaller than , < < likely likely < < "usd" 5000 "usd" 5000 larger than larger than , > > likely likely larger than larger than worst worst smaller than or equal smaller than or equal , <= <= likely likely <= <= "eur" 5000 "eur" 5000 larger than or equal larger than or equal , >= >= likely likely >= >= best best 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 likely likely between between "usd" 5000 "usd" 5000 ; "eur" 5000 "eur" 5000 likely likely between between worst worst , best best 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 likely likely in in "usd" 5000 "usd" 5000 ; "eur" 5000 "eur" 5000 ; worst worst ; best best 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 name name contains contains "inc" "inc" text the rhs cannot be a field, only a value symbol example starts with starts with name name starts with starts with "john" "john" ends with ends with name name ends with ends with "doe" "doe" 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 \[ date created date created ] strictly before strictly before today today strictly after strictly after \[ date created date created ] strictly before strictly before last month last month before or on before or on \[ date created date created ] strictly before strictly before @\[next monday] @\[next monday] on or after on or after \[ date created date created ] strictly before strictly before @\[3 weeks ago] @\[3 weeks ago] between between \[ date created date created ] between between @\[3 weeks ago] @\[3 weeks ago] , today today 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 description description empty empty 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 opportunity opportunity empty empty