BackPrevious Topic  Next TopicNext

Edit Dataset Filter Dialog Box Properties

You can use the Edit Dataset Filter dialog box to apply a filter to the dataset that the specified data component uses, to narrow down its data scope. This topic describes the properties in the dialog box.

Advanced/Basic

Select to switch between advanced mode or basic mode.

You see these elements in both modes:

Filter

Select the filter you want to apply to the dataset.

  • User Defined
    Select to create a user defined filter to apply to the dataset.
  • Predefined filters
    Server lists the names of the predefined filters which you created using the business view of the data component in Designer. You can choose one of them to apply.
    • Edit
      Select to edit the selected predefined filter. Once you edit a predefined filter, Server saves it as a user defined filter in the dataset.
    • Description
      Server displays the description of the selected predefined filter.

Apply to

The current data component.

OK

Select to apply any changes you made here and close the dialog box.

Cancel

Select to close the dialog box without saving any changes.

Help

Select to view information about the dialog box.

Basic Mode

You can create simple filter conditions using the AND/OR logic.

Edit Dataset Filter dialog box - Basic mode

Delete Condition Line Remove button

Select to delete the current condition line.

Field

Select the field you want to filter.

Operator

Select the operator to compose the filter expression.

Value

Specify the value of the field. You can either type the value manually in the text box or select a value from the list. Select the Toggle to Field button Filter By Field or Toggle to Value button Filter By Value to filter the field by either field or value.

Logic

Select a logic operator.

  • AND
    Select to connect this line with the next line using the AND logic.
  • OR
    Select to connect this line with the next line using the OR logic.
  • END
    Select to end the whole condition expression.

Back to top

Advanced Mode

You can build more complex filter conditions by grouping conditions.

Edit Dataset Filter dialog box - Advanced mode

Add Condition

Select to add a new condition line. Each condition line contains an expression which is composed of a field, an operator, and a value.

Delete

Select to delete the selected condition lines or groups.

Group

Select to make the selected condition lines become a group. A group can only have one logic operator to connect all its condition lines. For example, a group contains three conditions lines, which are expression A, B, and C, and the group's logic operator is OR, then the group's expression is: A OR B OR C.

You can also add condition lines to an existing group. Select the condition lines and the group while selecting Ctrl, and then select Group.

Ungroup

Select to move the selected condition lines and groups out of a group or disband a group.

Up

Select to move the selected condition line or group higher.

Down

Select to move the selected condition line or group lower.

Logic

Specify the logic operator of a condition group. Each time you select the logic button, Server displays the next item following the order below.

  • AND
    Select to connect all the condition lines and groups in the group using the AND logic.
  • OR
    Select to connect all the condition lines and groups in the group using the OR logic.
  • AND NOT
    Select to connect all the condition lines and groups in the group using the AND NOT logic.
  • OR NOT
    Select to connect all the condition lines and groups in the group using the OR NOT logic.

Field

Select the field you want to filter.

Operator

Select the operator to compose the filter expression.

Value

Specify the value of the field. You can either type the value manually in the text box or select a value from the list. Select the Toggle to Field button Filter By Field or Toggle to Value button Filter By Value to filter the field by either field or value.

Condition Expression

Server displays the SQL statement of the filter condition.

Back to top

BackPrevious Topic  Next TopicNext