Show Null Value When Column Is Nullable

Administrators use this system setting to specify whether to show the term "NULL" at runtime in the column prompt above the column separator in the drop-down list when the database allows null values.

Valid Values

• always — Always shows the term "NULL" above the column separator in the drop-down list. Default
• never — Never shows the term "NULL" in the drop-down list.
• asDataValue — Displays the data value in the drop-down list, not the term "NULL" above the separator in the drop-down list.

Apply Required

No.

Change Effective

After a few minutes.

Edition

Enterprise only.

API Key and Values

API Key — AnalysisPromptsShowNullValueWhenColumnIsNullable

API Values —

• always
• never
• asDataValue

Documentation Links

• When Do System Settings Take Effect?
• Typical Workflow for Using System Setting REST APIs
• Examples for System Setting REST APIs