Search Operators

Note

 

The content in this help topic pertains to all versions of SuiteScript. Be aware that currently it may only include links or examples for SuiteScript 1.0.

The following table lists each field type and its supported search operator.

Search Operator	List/Record	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			X
allof							X
any		X				X
anyof	X				X		X
before			X
between		X
contains						X
doesnotcontain						X
doesnotstartwith						X
equalto		X		X		X
greaterthan		X
greaterthanorequalto		X
haskeywords						X
is				X		X
isempty		X	X			X
isnot						X
isnotempty		X	X			X
lessthan		X
lessthanorequalto		X
noneof	X				X		X
notafter			X
notallof							X
notbefore			X
notbetween		X
notequalto		X
notgreaterthan		X
notgreaterthanorequalto		X
notlessthan		X
notlessthanorequalto		X
noton			X
notonorafter			X
notonorbefore			X
notwithin			X
on			X
onorafter			X
onorbefore			X
startswith						X
within			X

Important

 

The onOrAfter, onOrBefore, notOnOrAfter and notOnOrBefore operators only consider the date you specify in your request, and ignore the time you specify. If you need to specify not only the date but also the time in your search, use the after or before operators. Note, however, when you use these operators, the exact time specified in your request is not part of the result set.