Default Values

Query Designer is divided into several sections - Common, Fields, Conditions, Default Values and Preview. This article provides detailed information about the Default Values section.

Overview

Working with data often leaves you with undefined or incomplete information in your records, especially when dealing with optional data entry fields. The Default Values section lets you specify how to handle those undefined values in your result.

Definition of Default Values in a query

You can define a default value for each field of your Source.

Default Values are limited to fields of the Source class only.

A default value is applied to undefined values of a field only. An empty value is not replaced by the default value.

Add a Default Value

You start with an empty list of default values. Click on Add Field at the top of the list.

Specify default values for various fields of a query

In the newly created record you open the drop-down selection in the column Field to choose a field from your classes. You can use the Search feature to narrow down the selection.

In the column Value you enter the information shown in the result for any undefined value of the chosen field.

Repeat this step until all optional fields have been assigned default values to.

Delete a Default Value

To remove a row from the list of default values click on the Delete icon in the column Actions. Repeat to remove more than one row from the list.