1. Administering and Working with Oracle Enterprise Data Management Cloud
  2. Administration
  3. Using Expressions to Define Custom Business Logic
  4. Building Expressions
  5. Working with Objects and Operators
  6. Using Null and Blank Values in Expressions

Using Null and Blank Values in Expressions

You can use null and blank values in expressions, either to check for null and blank values in an If statement, to compare null and non-null values, or to return a null or blank value in a return statement.

Considerations

  • When you transform a property, returning a null value results in the property for the target node not getting updated, while returning a blank value overrides the target node property with a blank value.
  • When you derive a property, returning a null value results in a calculated value that is null, and returning a blank value results in a calculated value that is blank.

  • When comparing two null values, the equals method returns True. When comparing a null and a non-null value, the equals method returns False.

You can insert null or blank values in string and integer fields in expressions. By default, when you insert a string or integer object into an expression, the value is null. If you want to insert a blank value, enter any text in the field and then clear the entered text. The string or integer field will display blank instead of null.

You can also insert a null object to enable null values to be returned for non-String data types (such as Integer or Float) as well as to allow for easy evaluation of null values in an expression.

To reset a blank value back to null, click choose term next to the field and select string or integer again.