4.2.3.3.2.2 Ranges Filter

You can match a selected database column to a specified range/ranges of values or to ranges of values.

You may either include or exclude Specific Values, to view the data.

To create a Ranges filter, proceed with the following steps, after selecting the Database table name, column name and the Data element.

1. Select Ranges in the Filter Methods.
2. Refer to the following steps, and create a range or multiple ranges, view require data.
   You can use Ranges for data types - Term, Frequency, Leaf, Code, Identity, Date, Numeric and Varchar.

   1. Select the From Operator (> or >=), to include the lower limit of the range.
   2. Enter the Value From which the Range begins.
   3. Select the To Operator (< or <=), to indicate whether to include the specified value in the higher limit of the range.
   4. Enter the Value To , to include the higher limit of that range.
3. To include or exclude the specific range, in the results:
   • To view the results containing the entered specific range, select the range and select Include. Click Add to add the range to the filter condition.
   • To view the results without the entered specific range, select the range and select Exclude. Click Add to add the range to the filter condition.
4. To delete a range, select the range by clicking the check-box adjacent to the value. Click Delete.
5. To view the SQL statement for the specific range, select the range and click View SQL.