Filtering tables

You can control the items that are displayed in various tables by defining a filter. When you apply a filter, only objects that meet the specified criteria are displayed.
To filter a table:
  1. If the Advanced filter section is hidden, click the Gear menu button, then click Show Advanced Filter.
    The Advanced filter area appears. This example shows the Advanced filter on the Jobs table.Jobs table with Advanced filter area open; filter not set
  2. Set the conditions for the filter using the Property field, the Comparison field, and the Value field.
      Note:
    • To find objects that have a null value (no value or Not set) for the specified property, select the Comparison value has no value (notset). Objects that have a null value are not found when you use another Comparison value, such as is not (!=) or is not like (unlike). The example at the end of this procedure finds objects that have values and objects that have a null value.
  3. Optional: To add more conditions, click + to the right of any condition and set values for the Property, Comparison, and Value fields.
  4. Select how the conditions for the filter are combined from the list.
      Note:
    • If you choose Custom, enter your condition combination formula in the text field. Refer to the field help for more information.
  5. Click Apply filter.
    The filter is set. The table content reflects the filter that you set.

    Jobs table with Advanced filter area open; filter set

  6. Optional: To minimize the Advanced filter area, click the arrow to the left of the Advanced filter title.
    Jobs table with Advanced filter area open; filter set
  7. Optional: To close the Advanced filter area, click the Gear menu button, then click Show Advanced Filter.
    If a filter has been set, the Advanced filter area closes and the filter remains set.

    Jobs table with Advanced filter area open; filter set

  8. To remove a condition from the filter, click Remove filter button in the gray box that contains the condition.
  9. To turn off all of the filters, change the Advanced filter switch to the Off position.
    Advanced filter switch in Off position.

Example

To display all jobs that do not have a Job priority of 1, specify these conditions:

  • Job priority is not (!=) 1
  • Job priority has no value (notset)

Apply the conditions when any of them are true.