Prompt Options

You use these options to configure prompt behavior in analyses and dashboards. For example, you can enable search results to automatically display as highlighted when users enter search parameters, without the need to click Search.

System Setting More Information
Auto Apply Dashboard Prompt Values

Enables the option to hide the Apply button so that prompt values can be applied without clicking any button.

If this is property is On:

  • Displays the Show Apply Button and Show Reset Button fields in the Edit Page Settings dialog.

  • Displays the Prompts Apply Buttons and Prompts Reset Buttons fields in the Dashboard Properties dialog.

  • Displays the Prompt Buttons on Current Page option on the dashboard builder's Tools menu.

Default: On

Edition: Enterprise only

Support Auto Complete

Enables or disables the auto-complete functionality available in prompts.

  • On — Enables auto-complete, which means that the Prompts Auto-Complete field is displayed and set to On in the My Account dialog and in the Dashboard Properties dialog.

  • Off — Disables auto-complete, which means that the auto-complete fields in the My Account and Dashboard Properties dialogs aren't available.

Default: On

Edition: Enterprise only

Case Insensitive Auto Complete

Specifies whether, when a user enters a prompt value in analyses and dashboards, the auto-complete functionality is case-insensitive.

  • On — Case isn't considered when a user enters a prompt value such as "Oracle" or "oracle."

  • Off — Case is considered when a user enters a prompt value, so the user must enter "Oracle" and not "oracle" to find the Oracle record.

Default: On

Edition: Enterprise only

Show Null Value when Column is Nullable

Specifies 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.

  • always — Always shows the term "NULL" above the column separator in the drop-down list.

  • 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.

Valid Values: always, never, asDataValue

Default: always

Edition: Enterprise only

Auto Search on Prompt Value Search Dialog

Enables search results to automatically display and highlight when users enter search parameters, without the need to click Search.

Default: On

Edition: Enterprise only