Table filtering provides a helpful way to sort, search and filter large tables of data to improve how you view and manage data from your network environment.
Table filtering is available on Address Manager pages where data is organized in table format.
Each Address Manager table has a default table filter bar at the top of the table:
In addition to the default filter, the filter button at the top right of the table allows users to create, customize, and combine table filters:
Select the filter button, then select the Add filter button in the expanded section at the top left of the table to see available filter fields. The available filter fields will depend on the type of data presented in the table:
Select a filter field, then configure the filter in the next interface. The available options will depend on the selected field's type.
- Equals
- The equals operator accepts values that exactly match the field value. For example, when filtering by name with the equals operator, a device named "device-office1" will be included in the table results only by entering the full value "device-office1".
- When using the equals operator with range fields, the following formats are accepted: IP address and CIDR length (i.e. 10.0.0.0/24), IP address range (i.e. 10.0.0.0-10.0.0.255), or CIDR length only (i.e. /24).
- Contains
- When used with text fields (such as filter by name), the contains operator accepts values that match the field value partially or in full. For example, when filtering by name, a device named "device-office1" will be included in the table results by entering "device-office1", "de", or "office1" as a value.
- When used with IP range fields (filter by range), the contains operator accepts the network address, any IP address within the range, or the full address range in CIDR format. For example, an IPv4 block with range 192.0.2.0/24 will be included in the table results by entering 192.0.2.0, 192.0.2.2, 192.0.2.0/24 as a value.
- The contains operator is not supported for IP address fields (filter by address) - use equals instead.
- Starts with
- When used with text fields (such as filter by name), the Starts with operator accepts values that match the first part of the field value, or the full value. For example, when filtering by name, a device named "device-office1" will be included in the table results by entering "device", "de", or "device-office1" as a value.
- When used with IP range fields, the Starts with operator accepts the first IP address in the range (the network address).
- The Starts with operator is not supported for IP address fields (filter by address) - use equals instead.
- Ends with
- When used with text fields (such as filter by name), the Ends with operator accepts values that match the end part of the field value, or the full value. For example, when filtering by name, a device named "device-office1" will be included in the table results by entering "office1", "e1", or "device-office1" as a value.
- The Ends with operator is not supported for IP address or range fields - use equals instead (or contains for filter by range).
When working with some numerical field values, values can be compared using the following operators:
- Equals
- Not equals
- Greater than
- Greater than or equal to
- Less than
- Less than or equal to
For fields that contain a date/time value, a calendar interface will appear when configuring the filter. Use the calendar interface to create a time range by setting From and To values.
You can add multiple filters at the same time to create complex filter combinations. To configure multiple filters on the same table, use the Add filter button to create additional filters as needed.