| 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. |