Custom filters in Ecoverse views

You can create more complex filters for your Ecoverse view with the custom filter builder. As an example, you can use the filters to produce specific device lists and then export that data to Microsoft Excel or view the devices pre-filtered in the All Devices view.

Filter conditions and groups

Custom filters are a set of conditions or rules that you apply to narrow down data, making it easier to focus on specific information. Groups are a collection of conditions that are grouped together.

Conditions and groups of conditions include the following:

  • a Field: The column on which the filter operates, such Asset Name.

  • one or more Operators: Comparison or logical operators, for example, =, >, <, and OR.

  • a Value: The target value or condition you want to match.

Component Description Example Example outcome
Condition Filters are made up of conditions. Each condition consists of a field, an operator, and a value.

Displays all devices where the customer name is an exact match for “Customer 1”.
Groups Combined filter expressions into nest-able groups made up of the following logical operators.
  • And
  • Or
  • Not And
  • Not Or

We recommend that groups contain at least two filter conditions.

 Displays all the results that are true for either of the And groups. Which means the device type is Server and the OS is macOS, Or the device type is Desktop and the OS is Windows.

Operators

There are two types of operators, comparison operators and logical operators.

Comparison operators

Comparison operators are used to compare values in a field against a specified value.

Operator Description Example
= Equal to age = 35
!= Not equal to age != 35
> Greater than age > 21
< Less than < 21
>= Greater than or equal to salary >= 60000
<= Less than or equal to salary <= 150000
CONTAINS Finds data where a field contains a substring

Name contains `AWP`
ENDS WITH Finds data where a field ends with a specific value  
STARTS WITH Checks if a string begins with a specific value.  
IS NONE OF Checks if a string does not match any of the values from a specified set  
IS ANY OF Checks if a value matches any of the values from a specified set  

Logical operators

These logical operators combine multiple conditions using Boolean logic.

Operator Description Example Example outcome
And Both conditions must be true. Condition1 And Condition2 Includes devices that meet both Condition1 and Condition2 in the displayed devices list.
Or Either condition must be true. Condition1 Or Condition2 Includes devices that meet either Condition1 or Condition2 in the displayed devices list.
Not And Both conditions must be true. Not (Condition1 And Condition2) Excludes devices that meet both Condition1 and Condition2 in the displayed devices list.
Not Or Either condition must be true. Not (Condition1 Or Condition2) Excludes devices that meet either Condition1 or Condition2 in the displayed devices list.

Related articles