9.5.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 9-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
LIKE	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 or normal
• Datetime: Time value supported only for ALERTHISTORY
• String: Value delimited by single quotation marks ('') or double quotation marks (" ")
• NULL: Unassigned strings or empty lists