NLS Terms for Basic Filters

Arcadia Instant provides Natural Language Search support for basic filter operations.

To enable search using the terms such as including, like, excluding, matching, and so on, refer to the following functions:

All

Function
all
Example
Count all employees with sales < 10000

Between

Function
between; and
Examples
Revenue between 0 and 1000

cereal_name by manufacturer where calories between 50 and 100

Versus

Function
vs; versus
Example
Revenue east versus west

Greater Than

Function
greater than; >
Examples
Sum sale amount, by visitor and product, for last year sale amount > 2000

cereal_names where calories greater than 100

Less Than

Function
less than; <
Examples
Unique visitor count, by product and store, for sale amount < 20
cereal_name by manufacturer where calories less than100

Greater Than and Equal

Function
>=
Examples
Count calls by last name of the employee >= m
cereal_name with calories >= 100

Less Than and Equal

Function
<=
Example
Count shipments by latitude of the city <= 0

Equal

Function
=
Example
Unique visitor count by store purchased products = 3 for last 5 days

Not Equal

Function
!=
Example
Sum of sale amount by region != Canada and region != Mexico

Begins With

Function
begins with
Example
Product name begins with "pro"

Contains

Function
contains
Example
Product name contains "alpine" and description contains "snow shoe"

Ends With

Function
ends with
Example
Product name ends with "deluxe"

Not Begins With

Function
not begins with
Example
Product name not begins with "tom's"

Not Contains

Function
not contains
Example
Product color not contains "tan" and product color not contains "red"

Not Ends With

Function
not ends with
Example
Product name not ends with "trial"

Similar To

Function
similar to
Example
Course name similar to "hand"

Not Similar To

Function
not similar to
Example
Course name not similar to "hand"