When applying a filter, you supply (or select) data values associated with a data item and use mathematical logic to apply the values as constraints.
Name—Descriptive name for the filter.
Include Nulls—Toggles the inclusion/exclusion of null values.
Not—Reverses the effect of an operator (for example, ‘Not >=’ is equivalent to <).
Operators—Comparison operators for the filter expression. Values that pass the comparison test will be included.
Edit field—Enter a value (or multiple values separated by commas), and click the check mark to add them to the custom values list to complete the filter definition. Click the "x" to erase the contents of the Edit field.
Note: | The Edit field is displayed only if you are entering a custom value. |
Show Values—Shows all potential values from the database that are associated with the item.
Note: | Show values cannot be used in the Query section for filters on computed or aggregate values. |
For more information, see:
Custom Values—Lists potential values saved with the filter or read from a file. This feature enables you to select values from a predefined pool. You can create and save a custom list with each filter.
Custom SQL—Displays custom SQL for coding Filters directly in SQL.
Note: | The Custom SQL button is displayed only if you apply a filter in the Query section. |
Select All—Selects all values displayed in the list of values.
Transfer—Adds selected values to the custom list.
Ignore—Temporarily suspends a filter without deleting it.
Fractional Digits—Specify the number of digits that you want to place to the right of the decimal point in an SQL numeric literal statement. The SQL statement uses this setting to determine which values to recognize. For example, if you type the filter value, 0.12345678, the SQL statement writes “where column = 0.12346” (the rounded value), but if you change the spinner to 8, then the SQL writes “where column = 0.12345678”.
Advanced—Displays Loaded Values settings and subquery options.
Loaded Values Settings—Toggles a custom values list to be read from a file or from the database. Change File allows you to specify the file name. If you read values from a text file, vertical tabs or paragraph markers must defilter each value. Use Show Values to display the file contents.
Create Subquery—Creates a subquery.
Note: If you access Filter from the Results section, the Advanced button is displayed as Options and the Create Subquery option is not displayed.