Filter dialog box

The Filter dialog box is used for setting the filter criteria. Filtering enables you to reduce the amount of data being loaded. Only the rows that satisfy the filter are loaded. The selections made in this dialog box are shown with the appropriate syntax in the Filter area on the Table tab. Filtering is limited to distinct members.

Option Description
Filter on Column for which you are defining a filter.
Operators

Operators test whether the data matches a specified condition. The operator works in conjunction with the To/From boxes that is displayed next to the list. These are the choices:

  • Is between
  • Is less than
  • Is one of
  • Is less than or equal to
  • Is not one of
  • Is like
  • Is equal to
  • Is not like
  • Is not equal to
  • Is null
  • Is greater than
  • Is not null
  • Is greater than or equal to
Case Insensitive Specifies whether case should be ignored. Clearing the check box means that case is considered when returning results. This option is only valid for alphanumeric fields.
Substring Retrieves a portion of the data.

Substring is valid only for alphanumeric fields. Start specifies where to start the string. Previous characters are ignored.

Length specifies the number of characters in the string.