Show TOC

Object documentationConfigure Filters Locate this document in the navigation structure

 

Use this screen to create or delete (relational) filters.

Note Note

This is an optional step.

End of the note.

Structure

The main controls of this screen are described in the following table:

Control

Description

And/Or

Specifies and/or conditions for multiple filters. The And/Or control is enabled after the first filter has been added. Select from the following values for second and subsequent filters:

  • And: This filter's condition must apply.

  • Or: This filter's condition is handled after any And filters.

Field

Lists all fields from all the tables selected on the Select Fields screen. Select the field for which to configure the filter.

Operator

Lists operators that specify how the Field entry and the corresponding Value entry should be compared. Available operators are:

  • = (Equal to)

  • > (Greater than)

  • < (Less than)

  • >= (Greater than or equal to)

  • <= (Less than or equal to)

  • <> (Not equal to)

  • is between (Is between)

  • is like (Is like)

  • is null (Is null)

Value

Enter the value to which to compare the field. The value can be either numeric or text.

And (Is between operator only)

If you have selected Is between as your operator, enter the end value for your range.

Add

Transfers the filter to the Filters list.

Filters list

Lists the currently configured filters.

Delete

Deletes a selected filter from the Filters list.