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. In the right corner of the table, click the Table settings (image of the Table settings icon) icon, then click Filter.
    The Filter area opens but the filter is Not set.
    Jobs table with Filter area open; filter not set
  2. Set the filter using the Property field, the Comparison field, and the Value field.

    • The Comparison value Not Equal to (≠) does not return objects that have a null value (no value or Not set) for the specified property. To find these objects, select the Comparison value Not set.
  3. Optional: To set more filters, select another set of Property, Comparison, and the Value fields; then set values for these fields.
    The additional filters are appended to the first filter with AND operators.
  4. Optional: Select Save settings to keep your filter settings for the Jobs table:
    • When you view jobs in a different phase.
    • When you view candidate jobs.
    • When you Show Jobs from the Documents portlet (only available if a feature that includes it is installed).
    • The next time that you log in.
  5. Click Apply filter.
    The filter is set. The table content reflects the set filter.
  6. To close the Filter area, click the Table settings (image of the Table settings icon) icon, then click Filter.
    If a filter has been set, the Filter area is partly closed and the filter remains set. If no filter has been set, the Filter area is completely closed.
    Jobs table with Filter area partly closed; filter set
  7. To remove a filter that has been set, click Remove filter.
  8. 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
  9. Set the conditions for the filter using the Property field, the Comparison field, and the Value field.

    • 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.
  10. Optional: To add more conditions, click + to the right of any condition and set values for the Property, Comparison, and Value fields.
  11. Select how the conditions for the filter are combined from the list.

    • If you choose Custom, enter your condition combination formula in the text field. Refer to the field help for more information.
  12. 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

  13. 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
  14. 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

  15. To remove a condition from the filter, click Remove filter button in the gray box that contains the condition.
  16. 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.

 
Copyright © 2006, 2018