Operator
|
Value Types
|
Description
|
Example Load Conditions
|
---|---|---|---|
>, >=, <, <=
|
Long, String, Date, Timestamp, FloatingPoint, FloatingPointWithUnits
|
Validates that the object attribute value is greater than, greater than or equal to, less than, or less than or equal to the value specified.
The operator characters are reserved characters in the import load; the less than operator (<) needs to be specified as ‘<’ and greater than operator (>) as ‘>’.
|
>2012-01-12 00:00:00=<=20.002>=10
|
[0..10]
|
Long, String, Date, Timestamp, FloatingPoint, FloatingPointWithUnits
|
Validates that the object attribute value is within the specified range. If no minimum value in the range is specified, the condition is equivalent to less than or equal to. If the maximum value in the range is not specified, the condition is treated a greater than or equal to.
|
[-10.09..10.09][2012-01-12 00:00:00..2012-02-12 00:00:00][..100][0..]
|
=, !=
|
Boolean, Long, String, Date, Timestamp, FloatingPoint, FloatingPointWithUnits
|
Validates that the object attribute value is or is not the value specified.
The operator character ! is a reserved character in the import load; it must be specified as ‘#33;’
|
=true#33;=2012-02-12 00:00:00=10.09
|
[A,B]
|
Boolean, Long, String, Date, Timestamp, FloatingPoint, FloatingPointWithUnits
|
Validates that the object attribute value is within the discrete set.
|
[true][2012-02-01 00:00:00,2012-02-15 00:00:00,2012-02-30 00:00:00][MAJOR,CRITICAL][10.01,10.02][10,100,1000]
|
SET
|
Boolean, Long, String, Date, Timestamp, FloatingPoint, FloatingPointWithUnits
|
Validates that the object attribute value is not null. Only the keyword SET is needed to specify the operation.
|
SET
|
NOT_SET
|
Boolean, Long, String, Date, Timestamp, FloatingPoint, FloatingPointWithUnits
|
Validates that the object attribute value is null. Only the keyword NOT_SET is needed to specify the operation.
|
NOT_SET
|
EQUALS
|
String
|
Validates that the object attribute value is the specified string.
|
EQUALS(MAJOR)
|
NOT_EQUALS
|
String
|
Validates that the object attribute value is not the specified string
|
NOT_EQUALS(MAJOR)
|
BEGINSWITH
|
String
|
Validates that the object attribute value starts with a specified string.
|
BEGINSWITH(PN)
|
NOT_BEGINSWITH
|
String
|
Validates that the object attribute value does not start with a specified string.
|
NOT_BEGINSWITH(PN)
|
ENDSWITH
|
String
|
Validates that the object attribute value ends with a specified string.
|
ENDSWITH(0)
|
NOT_ENDSWITH
|
String
|
Validates that the object attribute value does not end with a specified string.
|
NOT_ENDSWITH(0)
|
CONTAINS
|
String
|
Validates that the object attribute value contains the specified string.
|
CONTAINS(PN0)
|
NOT_CONTAINS
|
String
|
Validates that the object attribute value does not contain the specified string.
|
NOT_CONTAINS(PN0)
|
LENGTH
|
String
|
Validates that the object attribute string length is within the specified range.
|
LENGTH(0..40)LENGTH(0..)LENGTH(..40)
|
|
The system locale is used for the format of the dates and timestamps in the attribute condition.
|