7.6.3 Attribute Filters in LIST and ALTER Commands
You can use the attribute_filters clause to
specify the objects to display in LIST
commands. Some
ALTER
commands also support the attribute_filters clause.
This syntax of the attribute_filters clause is:
WHERE attribute_filter1 [ AND attribute_filter2 ... ]
Each attribute_filterN has the following syntax:
attribute [ NOT | ! ] operator comparison_value
The attribute placeholder represents the name of the attribute to use for filtering. The supported types of operator are listed in the following table. These operators can be combined with NOT
or !
.
Table 7-1 Supported Operators in Attribute Filters
Operator | Description |
---|---|
|
Tests for equality between string, status, or numeric attributes. For example: status NOT = normal |
|
Tests for values greater than the numeric attributes. For example: size > 139920M |
|
Tests for values less than the numeric attributes. For example: freeSpace !< 100M |
|
Tests for a regular expression match with a string attribute using case-sensitive matching. For example: LIKE 'GD_IO_RQ.*' |
When used with the supported operators, comparison_value is one of the following data types:
- Numeric
- Literal: Value such as
active
ornormal
- Datetime: Time value supported only for
ALERTHISTORY
- String: Value delimited by single quotation marks (
''
) or double quotation marks (" "
) NULL
: Unassigned strings or empty lists
Parent topic: About CellCLI Object Attributes