Advanced Filter

Some reports support the Advanced Filter. The advanced filter lets you design complex searches to isolate data to just those values you want. Enter the filter string into the same line you normally enter the simple text filter into. Advanced filter supports the following operations:

White Space

To search for white space in a string, enclose the string in double quotes.

For example: "Microsoft Office*" OR "*Adobe *" Note that the * is included inside the double quotes.

Nested operators

All equations are processed from left to right. Use parenthesis to override these defaults.

For example: (("* adobe " OR *a*) AND *c*) OR NOT *d* AND < m

NOT

Search for the a string not containing the match data.

For example:    NOT *Microsoft*   returns all non-Microsoft applications.

AND

Use the logical AND operator to search for data that must contain multiple values but can appear in different places in the string.

For example:    *Microsoft* AND *Office*   returns all items that contain both Microsoft and Office in any order.

OR

Use the logical OR operator to search for data that may contain multiple values but must contain at least one.

For example:    *Microsoft* OR *MS*   returns all items that contain either Microsoft and MS in any order.

<, <= (Less than or less than or equal to)

Returns all data whose value is numerically less than, if a number. If this is alphabetic data then it returns all strings appearing earlier in the alphabet.

For example:   < G*   returns all applications starting with a letter less than "G" (any string starting with an "F" or lower).

Note: Dates may also be tested for but must be in the following format: YYYYMMDD HH:MM:SS where YYYY is a four digit year, MM is a two digit month (01 to 12), DD is a two digit day (01 - 31), HH is a two digit hour (00 - 23), MM is a two digit minute (00 - 59), and SS is a two digit second (00 - 59). HH:MM:SS is optional. Date and time are separated with a space. Remember that all white space must be enclosed in double quotes.

For example:    < "20040607 07:00:00"    will return all dates earlier than 7:00 on 7 June 2004.

>, >= (Greater than or greater than or equal to)

Returns all data whose value is numerically greater than, if a number. If this is alphabetic data then it returns all strings appearing after it in the alphabet.

For example:   > G*   returns all applications starting with a greater than "G" (any string starting with an "G" or higher).