Example: Mapping the not-equal-to operator
The mapping for the not-equal-to operator returns a Boolean and does not contain NOT, AND, or OR, so no parentheses are required:
<FunctionMapping FunctionName="NE">
  $P0 != $P1
</FunctionMapping>
The mapping for the not-equal-to operator uses the function NEQ, which contains parentheses. No additional parentheses are required:
<FunctionMapping FunctionName="NE">
  NEQ (CASE WHEN $P0 IS NULL THEN ' ' ELSE $P0 END,
    CASE WHEN $P1 IS NULL THEN ' ' ELSE $P1 END)
</FunctionMapping>
The mapping for the not-equal-to operator uses the AND operator. You must enclose it in parentheses:
<FunctionMapping FunctionName="NE">
  ($P0 IS NOT NULL AND $P1 IS NOT NULL AND $P0 <> $P1)
</FunctionMapping>

Additional Links:

Copyright Actuate Corporation 2012