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.
- If the Advanced filter section is hidden, click the
button, then click Show Advanced Filter.The Advanced filter area appears. This example shows the Advanced filter on the Jobs table.
- 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.
- Optional: To add more conditions, click + to the right of any condition and set values for the Property, Comparison, and Value fields.
- 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.
- Click Apply filter.The filter is set. The table content reflects the filter that you set.
- Optional: To minimize the Advanced filter area, click the arrow to the left of the Advanced filter title.
- Optional: To close the Advanced filter area, click the button, then click Show Advanced Filter.If a filter has been set, the Advanced filter area closes and the filter remains set.
- To remove a condition from the filter, click
in the gray box that contains the condition. - To turn off all of the filters, change the Advanced filter switch to the 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.