About Null Values

Service Studio, by design, does not support null values, except for the Entity Identifier data type. Therefore, there is always a value associated, even when the end-user does not provide a value in an input widget.

Using Foreign Entities with null value behavior, you may work with effective null values in the database. Check for further information in Integration Studio's documentation.

The next table presents the values used by Service Studio as "null values".

Type	Null Value
Text	"" (empty string)
Integer	0
Decimal	0
Boolean	False
Date Time	#1900-01-01 00:00:00#
Date	#1900-01-01# or NullDate function
Time	#00:00:00#
Phone Number	"" (empty string)
Binary Data	Byte array with no elements
Object	NullObject function
Currency	0
Record	Record which attributes follows these rules.
Record List	Empty list.

Entity Identifier

In Service Studio the only type that really supports null values is the type Identifier. However you cannot manage the null values directly, you have to use one of the following built-in functions:

NullIdentifier(): returns a null identifier of 0.
NullTextIdentifier(): returns a null Text Identifier of "".

Input widgets and null values

If you are using a Input widget to gather end-user information, you can change the values used when the end-user leaves the widget empty.

How to change the default value of an input widget:

Set the property Null Value of the Input widget to a value that suits your business logic.