The Edit DB Filter command allows you to create and edit a filter for a database table (a DB Filter). A DB Filter determines what data from the selected database table is imported and displayed. A DB Filter consists of one or more criteria. When you specify criteria, you use an expression, which is a combination of operators (= or >) and values (text or numbers). Additionally, criteria can be joined by the logical operators AND or OR.
To create or edit a DB Filter, do the following:
|1.||Select the top-level data table element for which you wish to create or edit a DB Filter. Do this by clicking either the element tag in Design View or the element name in the schema tree.|
|2.||Select Database | Edit DB Filter or click the toolbar icon for the command. This pops up the Edit Database Filters dialog.|
|3.||To add criteria use the Append AND and Append OR buttons. To move a criterion up or down, use the arrow buttons. To delete a criterion, use the Delete button.|
|4.||Specify the criteria for the DB Filter. Each criterion consists of three parts: Field Name + Operator + Value. The options for Field Names and Operators are available in combo boxes. The value of the expression must be keyed in, and may be a parameter (indicated by a preceding $ character).|
Clear DB Filter command
The Clear DB Filter command deletes the filter after asking for and receiving a confirmation from you.