1. SuiteCloud Platform
  2. SuiteScript
  3. SuiteScript 2.x API Reference
  4. SuiteScript 2.x Modules
  5. N/search Module
  6. search.Operator
  7. SuiteScript 2.x Search Operators

SuiteScript 2.x Search Operators

The following table lists each search type and the fields that support it.

Search Operator

List/Record

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

-

-

check mark

-

-

-

-

allof

-

-

-

-

-

-

check mark

any

-

check mark

-

-

-

check mark

-

anyof

check mark

-

-

-

check mark

-

check mark

before

-

-

check mark

-

-

-

-

between

-

check mark

-

-

-

-

-

contains

-

-

-

-

-

check mark

-

doesnotcontain

-

-

-

-

-

check mark

-

doesnotstartwith

-

-

-

-

-

check mark

-

equalto

-

check mark

-

check mark

-

-

-

greaterthan

-

check mark

-

-

-

-

-

greaterthanorequalto

-

check mark

-

-

-

-

-

haskeywords

-

-

-

-

-

check mark

-

is

-

-

-

check mark

-

-

-

check mark

-

isempty

-

check mark

check mark

-

-

check mark

-

isnot

-

-

-

-

-

check mark

-

isnotempty

-

check mark

check mark

-

-

check mark

-

lessthan

-

check mark

-

-

-

-

-

lessthanorequalto

-

check mark

-

-

-

-

-

noneof

check mark

-

-

-

check mark

-

check mark

notafter

-

-

check mark

-

-

-

-

notallof

-

-

-

-

-

-

check mark

notbefore

-

-

check mark

-

-

-

-

notbetween

-

check mark

-

-

-

-

-

notequalto

-

check mark

-

-

-

-

-

notgreaterthan

-

check mark

-

-

-

-

-

notgreaterthanorequalto

-

check mark

-

-

-

-

-

notlessthan

-

check mark

-

-

-

-

-

notlessthanorequalto

-

check mark

-

-

-

-

-

noton

-

-

check mark

-

-

-

-

notonorafter

-

-

check mark

-

-

-

-

notonorbefore

-

-

check mark

-

-

-

-

notwithin

-

-

check mark

-

-

-

-

on

-

-

check mark

-

-

-

-

onorafter

-

-

check mark

-

-

-

-

onorbefore

-

-

check mark

-

-

-

-

startswith

-

-

-

-

-

check mark

-

within

-

-

check mark

-

-

-

-

General Notices