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 |
— |
— |
|
— |
— |
— |
— |
