Dataset Filter dialog

This dialog appears when you click the Dataset Filter button on the toolbar of the Resource View panel. It helps you to set filter conditions for a dataset. See the dialog.

The following are details about options in this dialog:

Add Condition

Adds a new condition line.

Delete

Deletes the selected condition line.

Group

Makes the selected conditions in one group. Conditions can also be added to an existing group by selecting the conditions and the group while holding the Ctrl button, and then clicking the Group button.

Ungroup

Makes the selected condition ungrouped.

Up

Moves the selected condition up to a higher level.

Down

Moves the selected condition or group down to a lower level.

Logic

Lists the logic operator.

Field

Specifies the field to be filtered.

Operator

Specifies the operator to compose the filter expression.

Value

Specifies the value of how to filter the field. You can either type in the value manually or click next to the text box to specify the value.

When you type in the value, if multiple values are required, they should be separated with ",", and if "," or "\" is contained in the values, write it as "\," or "\\".

When you click to specify the value, the Expressions dialog is displayed. The following are options in the dialog:

SQL Statement

Displays the SQL statement of the filter condition.

OK

Applies the changes and closes the dialog.

Cancel

Cancels the changes and exits the dialog.

Help

Displays this help document.