SuiteScript 2.x Search Operators
The following table lists each search type and the fields that support it.
Search Operator |
List/ |
Currency Decimal Number Time of Day |
Date |
Box |
Document, Image |
Email Address Free-Form Text, Long Text Password Percent Phone Number Rich Text, Text Area |
Multi Select |
---|---|---|---|---|---|---|---|
after |
— |
— |
|
— |
— |
— |
— |
allof |
— |
— |
— |
— |
— |
— |
|
any |
— |
|
— |
— |
— |
|
— |
anyof |
|
— |
— |
— |
|
— |
|
before |
— |
— |
|
— |
— |
— |
— |
between |
— |
|
— |
— |
— |
— |
— |
contains |
— |
— |
— |
— |
— |
|
— |
doesnotcontain |
— |
— |
— |
— |
— |
|
— |
d |
— |
— |
— |
— |
— |
|
— |
equalto |
— |
|
— |
|
— |
— |
— |
greaterthan |
— |
|
— |
— |
— |
— |
— |
g |
— |
|
— |
— |
— |
— |
— |
haskeywords |
— |
— |
— |
— |
— |
|
— |
is |
— |
— |
— |
|
— — — |
|
— |
isempty |
— |
|
|
— |
— |
|
— |
isnot |
— |
— |
— |
— |
— |
|
— |
isnotempty |
— |
|
|
— |
— |
|
— |
lessthan |
— |
|
— |
— |
— |
— |
— |
l |
— |
|
— |
— |
— |
— |
— |
noneof |
|
— |
— |
— |
|
— |
|
notafter |
— |
— |
|
— |
— |
— |
— |
notallof |
— |
— |
— |
— |
— |
— |
|
notbefore |
— |
— |
|
— |
— |
— |
— |
notbetween |
— |
|
— |
— |
— |
— |
— |
notequalto |
— |
|
— |
— |
— |
— |
— |
notgreaterthan |
— |
|
— |
— |
— |
— |
— |
n |
— |
|
— |
— |
— |
— |
— |
notlessthan |
— |
|
— |
— |
— |
— |
— |
n |
— |
|
— |
— |
— |
— |
— |
noton |
— |
— |
|
— |
— |
— |
— |
notonorafter |
— |
— |
|
— |
— |
— |
— |
notonorbefore |
— |
— |
|
— |
— |
— |
— |
notwithin |
— |
— |
|
— |
— |
— |
— |
on |
— |
— |
|
— |
— |
— |
— |
onorafter |
— |
— |
|
— |
— |
— |
— |
onorbefore |
— |
— |
|
— |
— |
— |
— |
startswith |
— |
— |
— |
— |
— |
|
— |
within |
— |
— |
|
— |
— |
— |
— |