NLS Terms for Basic Filters
Arcadia Enterprise 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"