<condition>
XML tagThe <condition>
tag defines
the conditions under which a formatting exception is applied to a field. The
<condition>
tag must be
nested within an <exception>
tag.
<condition
source="source_column_name"
operator="eq | lt | lteq | neq | gt | gteq
| btw | notBtw | like | notLike | null | notNull"
[operand1="comparison_value"]
[operand2="comparison_value"]
[relation="and | or"]
/>
Parameters /Options |
Description |
|
Is the name of the source column to be used in the condition. |
|
Is the operator to use in comparing other values to the source column. The valid operators are:
|
|
Is the value to which the source column is
being compared. If the operator is |
|
Is the second value to which the source column
is being compared. You only need to use |
|
Defines whether there are multiple conditions and, if there are, how they should be related. |
and
or or
.
and
means that the formatting exception is applied only if both are met.
or
means that the formatting exception is applied if either condition is
met.
The following example shows two formatting exceptions for field f_ename
.
The first exception changes the text color to red if both of its conditions
are met. The second exception changes the text color to blue if its condition
is met.
<field name="f_ename" source="ename"
label="Employee" textColor="green">
<exception textColor="red">
<condition source="deptno" operator="btw"
operand1="20"
operand2="30" relation="and"/>
<condition source="sal" operator="gt"
operand1="1000"/>
</exception>
<exception textColor="blue">
<condition source="deptno" operator="eq"
operand1="30"/>
</exception>
</field>
Copyright © 1984, 2005, Oracle. All rights reserved.