A <Comparison Value> is not required when using IS NULL and NOT NULL comparison operators. String values must be in double quotation marks, for example "Project A".
Include a list of values as a comma-separated list with strings that are enclosed in double quotation marks. Enclosing strings in double quotation marks is important for values that contain spaces. For example enter "Project A", "Project B", "Project C" for a list of strings or 1, 2, 3 for a list of numbers. The <Comparison Value> can also be specified as a Perl expression that returns a value of the same type as the value specified in the <Field Name Selection> list. The expression can call a routine defined in your schema or an IBM® Rational® ClearQuest® API call. For example, to send an email if the current user is the submitter, you could use the ClearQuest GetUserLoginName() API call to return the current user. You can add your own dynamic comparison values to the value criteria. For example, you could add your own function to the schema that returns date comparison values such as YESTERDAY or LAST_WEEK.
The following table lists the operators that you can use in the value criteria. The following table lists the operators that you can use in the value criteria.Operator | Description |
---|---|
= | Equal |
<> | Not equal |
< | Less than |
<= | Less than or equal |
> | Greater than |
=> | Greater than or equal |
IN | The value criteria return TRUE if the value of <Field Name Selection> is one of the values that are specified in the <Comparison Value> element. Otherwise, the value criteria return FALSE. |
NOT IN | The value criteria return TRUE if the value of <Field Name Selection> value is not one of the values that is specified in <Comparison Value>. Otherwise, the value criteria return FALSE. |
LIKE | The value criteria return TRUE if the value of <Field Name Selection> value contains the text that is specified in <Comparison Value>. Otherwise, the value criteria return FALSE. String comparisons are case sensitive. |
NOT LIKE | The value criteria return TRUE if the value of <Field Name Selection> value does not contain the text that is specified in <Comparison Value>. Otherwise, the value criteria return FALSE. |
IS NULL | The value criteria return TRUE if the value of <Field Name Selection> value is empty or has no value. Otherwise, the value criteria return FALSE. This comparison operator does not that require the <Comparison Value> contain a value. |
NOT NULL | The value criteria return TRUE if the value of <Field Name Selection> contains a value. Otherwise, the value criteria return FALSE. |