Advanced Searches in Mashups
Mar 11 2014
Mashup Search tips from Jay Chen, one of our technical team…
If you are using Mashups with SearchPanels, here are some advanced search options for technical users – including how to do Wildcard Searches, Range Searches, Multiple Searches and Searches with Boolean Operators.
The following search examples use the LES query syntax (which is based on Apache Lucene Query Parser Syntax).
1. Wildcard Searches
Use “?” as a single character wildcard search.
Use “*” as a multiple character wildcard search.
Example: To search a customer order for a Responsible beginning with ‘CH’:
RESP: CH*
2. Range Searches
A range search will find the values between the lower and upper bounds that are specified by the Range Query.
Example: To search for an “LOS” (lowest order status) between 75 and 80, use this query :
ORSL : [75 TO 80]
3. Boolean Operators (&&, ||, +, -)
Example: To search for a Responsible beginning with ‘B’ and ends with ’90’:
RESP : (B* && *90)
Example: To search for a Responsible beginning with COM or ending with 90
RESP : (COM* || *90)
Example: Search for a Responsible beginning with B and ending with 90
RESP : (B* + *90)
Example: Search for a Responsible beginning with B but not ending with 90.
RESP : (B* – *90)
4. Multiple Search
Example: Search for a Responsible beginning with COM or ending with 90, and lowest status is between 30 and 60.
RESP : (COM* || *90) && ORSL : [30 TO 60]
Find out more about Apache Lucene Query Parser Syntax.