Operator Descriptions

Table 9-1 Operator Descriptions

Operator Description Data Type Restrictions

Above

The specified value of the property is used by an ancestor node.

 

Below

The specified value of the property is used by a descendant node.

 

Contains

The comma-delimited list value of the property contains the specified item in the list.

Strings only

Equal

The value of the property is equal to the specified value.

 

Greater Than

The value of the property is greater than (but not equal to) the specified value.

 

Greater Than, Equal

The value of the property is greater than or equal to the specified value.

 

Has Characters

The value of the property has one or more of the specified characters.

 

Has Not Characters

The value of the property does not have any of the specified characters.

 

In

The value of the property is in the specified comma-delimited list of values.

Strings only

Is Alpha

The value of the property consists of alphabetic characters only.

 

Is Alpha Numeric

The value of the property consists of alphabetic or numeric characters only.

 

Is Blank

The value of the property is blank (the specified value field is unavailable).

 

Is Defined

The value of the property is a defined (overridden) value.

 

Is Not Alpha

The value of the property does not consist of alphabetic characters only.

 

Is Not Alpha Numeric

The value of the property does not consist of alphabetic or numeric characters only.

 

In Not Blank

The value of the property is not blank.

 

Is Not Numeric

The value of the property is not numeric.

 

Is Numeric

The value of the property is numeric.

 

Length Equal

The length of the property value is equal to the specified value.

Strings only

Length Greater Than

The length of the property value is greater than (but not equal to) the specified value.

Strings only

Length Greater Than, Equal

The length of the property value is greater than or equal to the specified value.

Strings only

Length Less Than

The length of the property value is less than (but not equal to) the specified value.

Strings only

Length Less Than, Equal

The length of the property value is less than or equal to the specified value.

Strings only

Length Not Equal

The length of the property value is not equal to the specified value.

Strings only

Less Than

The value of the property is less than (but not equal to) the specified value.

 

Less Than, Equal

The value of the property is less than or equal to the specified value.

 

Like

The value of the property is like the specified value (including wildcards). The asterisk (*) and percent sign (%) can be used as wildcards.

Strings only

Not Above

The specified value of the property is not used by an ancestor node.

 

Not Below

The specified value of the property is not used by a descendant node.

 

Not Contains

The comma-delimited list value of the property does not contain the specified item in the list.

Strings only

Not Equal

The value of the property is not equal to the specified value.

 

Not In

The value of the property is not in the specified comma-delimited list of values.

Strings only

Not Like

The asterisk (*) and percent sign (%) can be used as wildcards.

Strings only