DCImanager 6

Using filters

You can customize the display of information in the tables according to a given filter. This article describes the order in which filters are enabled and their syntax.

Enabling the filter

To enter the filter conditions, click the icon in the header of the column with the required parameter.

If a parameter can only assume certain values, select one or more values from the list. For example, to display tasks with certain statuses.

An example of a filter for a task list

If the parameter can assume different values, specify the filter conditions using special syntax.

Example of a filter to search by name

Filter syntax

You can use special characters in filters:

SymbolMeaningComment
""exact query

for text only

*

any number of characters

-
%

any number of characters

-

?

any single character

-
_

any single character

-
&

logical “AND”

-
,

logical “OR”

-
|

logical “OR”

-
!

logical “NOT”

-
<smaller than

for numbers only

<=

smaller or equal to

for numbers only

>

greater than

for numbers only

>=

greater or equal to

for numbers only

-range

for numbers only

One filter can include several special characters. For example, filter >100&*6 will display all values that are greater than 100 and end in 6.

If you enter a value without special characters in the filter:

  • for text parameters — the list will be filtered by the occurrence of this value. For example, filter Server1 will display the values of Server1, Server12, My Server1, etc.;
  • for numeric parameters — the list will be filtered by the exact value. For example, for filter 29, only the value 29 will be displayed.

If symbols for the logical "AND", "OR", "NOT" are inside quotation marks, the filter treats them as normal characters. For example, the filter "drag&drop" will display the drag&drop value.

Examples of filters

Text values

The platform has six servers named Server1, Server2, Server12, Server13, Server22, Server34. Examples of filters and filtering results:

Filter

Filtering results

"Server1"Server1
Server1

Server1

Server12

Server13

*3Server13
Server?2

Server12

Server22

Server1|Server2

Server1

Server2

Server12

Server13

Server22

Server&2

Server12

Server22

!Server1

Server2

Server22

Server34

!"Server1"

Server2

Server12

Server13

Server22

Server34

Numerical values

Five racks with the ids of 1, 12, 23, 44, and 45 have been created in the platform. Examples of filters and filtering results:

Filter

Filtering results

1212
>12

23

44

45

1-20

1

12

4?

44

45

*2*

12

23

!23

1

12

44

45

Useful tips