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.

 

We write about Infor technology, ERP & Cloud news plus host the occasional Webinar.

Get it delivered to your inbox

subscribe
X

Subscribe

Subscribe to ComActivity Newsletter – Infor technology, ERP & Cloud news plus host the occasional Webinar.


Add us to your LinkedIn feed

© Copyright 2018. All rights reserved.