Please enable JavaScript to view this site.

AudienceView Unlimited Product Guides

Search filters enable you to restrict which records a user can search for and open through New Business Intelligence using the TSsearchBO. A filter applied to an entity determines which records will be returned by a search (and therefore visible in the search results).

Once a record is opened, the ways in which the user can interact with it are determined by permissions and attributes. For example, a particular group of users may only be allowed to search for and open customer records whose 'Country' is Canada. In this case, a filter would be applied to the customer entity restricting the 'Country' field to Canada.

When more than one filter is applied to the same entity, you can use operators to specify the type of results you are expecting. For example, filters for First Name = Bob and Last Name = Smith are created for customer searches. You can control whether you want to see any customers with either of these names (First Name = Bob OR Last Name = Smith) or for only those customers with both names (First Name = Bob AND Last Name = Smith).

info_outline

Information

Modifications to search filters will take effect the next time the user logs on to the application.

Select one of the titles below for more information about:

Filter Operators

The following table describes the available filter operators:

Filter Operator

Definition

>

greater than

>=

greater than or equal to

<

less than

<=

less than or equal to

!=

not equal to

=

equals

Equals is case sensitive, so ensure that the 'Value' that you enter exactly matches what you are filtering for.

Begins with

begins with the entered value

Ends with

ends with the entered value

contains

contains the entered value

The Contains function performs like Equals, but with some additional wildcard options. This operator can only be used for fields that are strings.

% represents any string of 0 or more characters (%son returns any term that ends in son - Flarson, Carson, Montarson, Son).

The Contains function transparently adds % to the beginning and end of terms, returning results that contain the term within them as well (%son would also return Jacksonville, Samsonite).

_ represents any single character (_andy returns any term that has a single character before the ending andy - Mandy, Randy, Sandy).

[ ] represents any single character within a specified range or set ([A-C]son returns terms that end in son and begin with A, B or C - Ason, Bson, Cson; [BCL]son returns terms that end in son and begin with B, C or L - Barson, Carson or Larson).

[^] represents any single character not within the specified range or set ([^A-C]son returns terms that end in son and do not begin with A, B or C - Larson, Tarson; [^CLT]son returns terms that end in son and do not begin with C, L or T - Barson, Narson).

Select one of the titles below for some filtering examples: