Highly Advanced Search

Multiple Terms Search

You can search using more than one search term in a single query, such as by Brand and Geox.

• If you want to search by two terms and have the results match BOTH terms, use an AND statement such as: brand:VISA AND geox:US.
• If you want to search by two terms and have the results match either one or the other, use an OR statement such as brand:VISA OR geox:US.

You can also search by more than two terms. For instance, if you want to search for all transactions paid by Visa and that have a Geox of US or CA, use the following example: brand:VISA AND (geox:US OR geox:CA).

The parenthesis are required to group and add precedence.

Tokenized Values Search

When String values are tokenized in the search indexes, it means the strings are broken into searchable pieces. The delimiter for those pieces is any whitespace such as tabs, spaces, carriage returns or some special characters, such as @ in an email address. When the data is tokenized it is lowercase, as are all search values, so searches for these values are case sensitive.

For instance, an email address string such as james @domainname.com without being surrounded by double-quotes is tokenized and searched as “james” and “domainname.com”.

A street address string such as 123 Main St is tokenized and searched as "123", "main", and "st".

Managing Column Types

Depending on the column type employed in a search query, it must be used in a specific manner in order to produce valid results. Generally speaking:

• Single quotes should be avoided.
• Use double quotes when trying to match on an exact phrase.
• Most numbers searched for are whole numbers, such as order numbers or transaction IDs. The exception is cart prices.
• When searching for prices, use only the decimal point but not other characters such as the dollar sign ($) or commas (,).

The following table provides a detailed description of each column type and how it is to be used and managed.

Inputting Search Data

Both Basic and Advanced Search require specific syntax in order to get the best search results. The following table lists the correct method of using each available search term.