Orders / Smartstore administration

Example	Result
banana joe	Contains "banana" or contains "joe"
banana and !*.joe	Contains "banana" but does not match "*.joe"
banana and (!~"hello world" or !*jim)	Contains "banana", but does not contain "hello world" or does not end with "jim"
Leather and !(Sofa Jacket*)	Ends with "Leather", but does not starts with "Sofa" or "Jacket"
(>=10 and <=100) or 1 or >1000	Is between 10 and 100, or equals 1, or is greater than 1000

Terms

Quoted search term (double or single), or unquoted search term without whitespaces. For example, unquoted banana joe is the equivalent of ~banana or ~joe, whereas quoted "banana joe" performs an exact term match. Supports wildcards (* or ?). If wildcards are present, default operator is switched to "Equals" (=). Use "NotEquals" (!) to negate pattern.

Groups

Multiple search words or phrases may be grouped in a fielded query by enclosing them in parenthesis. Any group can be negated with a preceding ! (exclamation mark), e.g. !(banana and joe). Groups can be nested as often as required.

Operators

=[=]	Equals (default when omitted on numeric terms)
![=]	Not equals
>	Greater than
>=	Greater than or equal
<	Less than
<=	Less than or equal
~	Contains (default when omitted on string terms)
!~	Does not contain
and, or	Logical term combinators (case-insensitive). If omitted, "or" is default.