Filtering your selection list

You can restrict the data displayed in a selection list by specifying filters for any of the column data.

Points to consider when you specify a filter:
  • Filtering is performed using a generic trailing match. That is, if the start of the data in the column being filtered matches the filter string, it is considered a match.

    For example, a filter of PEA matches PEA and PEAR, but not APPEAR.

  • Matching of data to filters is not case-sensitive.

    For example, a filter of PEA matches PEA, PEAR, Pea and pear.

  • You can specify any of these operators as the first character of the filter:
    >
    Greater than.
    <
    Less than.
    =
    Equal to.
    !
    Not equal to.

You can specify a filter in any of these ways:

Related topics