SuiteScript 2.x Search Operators
The content in this help topic pertains to all versions of SuiteScript.
The following table lists each search type and the fields that support it.
Search Operator |
List/ |
Currency Decimal Number Time of Day |
Date |
Check 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 |
— |
— |
|
— |
— |
— |
— |