Filter and Sort

Sort the data by clicking the Sort the data button, and then choosing the columns and sort order. The Generated SQL statement field shows the sort criteria.
Filter the data by clicking the Filter the data button, and setting the following options:
  • The Sample tab is used to limit the number of rows to return or to select distinct values.
  • The Row Filter table is used to subset data with a WHERE clause. You can filter on the values in multiple columns, set ranges for numeric values, and use IN and NOT IN criteria for character values. If the number of distinct values is less than 50, then you can select check boxes for the values. If there are more than 50 distinct values, then you must enter the values to use for filtering.
  • The Column Filter tab is used to select the columns to display.