Operators

12 min

each operator can also be prefixed by \not\ , which denotes its negation, e g \not =\ , \not smaller than\ , etc equality the rhs can be either a field or a value symbol example \=\ , \equal\ \[ \first name\ ] \equal\ \"john"\ comparison the rhs can be either a field or a value symbol example \smaller than\ , \\<\ \likely\ \\<\ \"usd" 5000\ \larger than\ , \\>\ \likely\ \larger than\ \worst\ \smaller than or equal\ , \\<=\ \likely\ \\<=\ \"eur" 5000\ \larger than or equal\ , \\>=\ \likely\ \\>=\ \best\ between the \between\ operator expects two arguments on the rhs 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\ \between\ \y\ , \z\ is equivalent to \x\ \\>=\ \y\ \and\ \x\ \\<=\ \z\ \likely\ \between\ \"usd" 5000\ ; \"eur" 5000 \ \likely\ \between\ \worst\ , \best\ membership in the \in\ operator expects one or more arguments on the rhs it tests whether the lhs docid\ zbj6atbbc9 s7nlsnwchh argument is equal to any of the rhs arguments any of the rhs arguments can be fields \likely\ \in\ \"usd" 5000\ ; \"eur" 5000\ ; \worst\ ; \best\ contains the \contains\ operator tests whether the lhs argument contains the value on the rhs it is not case sensitive ( \"abc"\ is the same as \"abc"\ , \"abc"\ , \"abc"\ etc ) the rhs cannot be a field , only a value \name\ \contains\ \"inc"\ text the rhs cannot be a field, only a value symbol example \starts with\ \name\ \starts with\ \"john"\ \ends with\ \name\ \ends with\ \"doe"\ temporal the rhs can be either a field or a value \between\ for temporal fields is equivalent to \x\ \on or after\ \y\ \and\ \x\ \before or on\ \z\ symbol example \strictly before\ \[ \date created\ ] \strictly before\ \today\ \strictly after\ \[ \date created\ ] \strictly before\ \last month\ \before or on\ \[ \date created\ ] \strictly before\ \@\[next monday]\ \on or after\ \[ \date created\ ] \strictly before\ \@\[3 weeks ago]\ \between\ \[ \date created\ ] \between\ \@\[3 weeks ago]\ , \today\ emptiness the \empty\ operator does not have a rhs for example, the following query searches for all records that have an empty \description\ \description\ \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\ \empty\