Views:

Fine-tuning the Search with Filter criteria

You can make a more exact search by using filter operators, expressions, and filter tokens. Unlike filtering, these are applied across all fields when used in the search box, making them less efficient than filtering.

  • To find only field values that match the entire text and case exactly, place the search text between single quotes '' (for example, 'man').

  • To find field values that start with a certain text and match the case, place * after the search text (for example man*).

  • To find field values that end with a certain text and match the case, place * before the search text (for example *man).

  • When using '' or *, the search is case-sensitive. If you want to make the search case insensitive, place @ before the search text (for example @man*).

The following table provides some examples to explain how you can use the search.

Search Criteria Finds...
man
or
Man		 All records with fields that contain the text man, regardless of the case. For example, Manchester, manual, or Sportsman.
'Man' All records with fields that contain only Man, matching the case.
Man* All records with fields that start with the text Man, matching the case. For example, Manchester but not manual or Sportsman.
@Man* All records with fields that start with man, regardless of the case. For example, Manchester and manual, but not Sportsman.
@*man All records that end with man, regardless of the case. For example Sportsman, but not Manchester or manual.
Keywords: BC filters, BC filtering