Enter Value dialog box

When you are defining a filter to import data from a database, you can supply arguments for the filter using the Enter Value dialog box.

Prerequisite

You are importing data from a database and have added at least one database table to the editor pane.

To define a filter to determine which data to import

1 In the editor pane, hover the cursor over a data column to use to create the filter, then click the arrow icon that appears. A pop-up menu is displayed. Point to Filter, then select one of the following:
To create a simple filter, select the filtering comparison operator that you want to use, such as In List or Between. The Enter Value dialog box opens, prompting you to enter the values to compare the data column to. Type the appropriate values, and click OK. Your filter is automatically created and a filter icon is displayed next to the name of the data column.
To filter based on a complex expression, select Expression. The Expression dialog box opens. Select the appropriate options to define the expression and click Save to apply your changes. Your filter is automatically created and a filter icon is displayed next to the name of the data column.

Related topic

Importing data from a database