Quick Query Limit Properties enables you to manipulate query limits properties, and to enter custom SQL statements, and associate the statements with available options.
Maximum limit values to show—Enables a restriction to be set on the number of values that are displayed in a Quick Query Limits list box (List box controls that contain a large number of available values may affect the performance of Query Panel).
To set the maximum value:
Enter the number of values to be displayed.
Click Apply.
Click
to activate Query Panel.Lists in Query Panel are displayed using the specified number of values. The text box and Ref can be configured to scroll through the list of values. A plus sign (+) displayed in the text box enables the next set of values to be viewed.
Allow Custom Process—Enables users to process individual query sections (If enabled, a drop-down list is displayed when 
is clicked. Users select the query sections to process, or choose to process all. The drop-down list is displayed only if multiple query sections require processing. See Processing All, One, or More Queries).
Prompt Login—Prompts users to connect to the data source every time the dashboard is opened.
Section to Display after Process—Enables developers to select a section to be displayed after the user clicks Process (The dashboard home section is the default).
Sources for Limit Values—Enables users to specify the source of the query limits configured in the Query Panel.
To configure the sources for the limit values:
From the list, select a query limit.
Only query limits associated with lists and drop-down lists are displayed, because they must detect from where the available values are loaded.
Use the options to select a source.
If Values Cached in Results is selected, a drop-down list is displayed, that provides available results and tables for selection.
Click Change Value Type.
The selected source is appended to the query limit in Sources for Limit Values. See Value Types.
Click Apply.
Value types nominate how lists obtain the values that are displayed to users.
No Values—If a query limit exists in multiple queries, it is not necessary for the values to be read from all sections, so No Values is used for those queries in which no values need to be obtained (However, one section for each limit requires an option other than No Values. Values need only be obtained from multiple queries for a limit if a section does not provide the full set of values from which the user can choose)
Available Values—The full set of values for the limit are retrieved from the database, in a similar manner to Show Values in a query (Use this option cautiously as it takes time to refresh the list of values)
Custom Values—Functioning in a similar manner to Custom Values in a query, the values that are added to the custom values list of the limit are used, and not the values in the database
Values Cached in Results—Read values in a column with an identical name to the limit in a nominated table or results (A more powerful option than Custom Values, but functioning in a similar way, the values are not obtained from the database, hence the speed is comparable with Custom Values. The query associated with the nominated results can be scheduled regularly, so the list of cached values in the Interactive Reporting document is available to be refreshed as required)
Custom SQL for Option Buttons—Enables users to configure the custom SQL to associate with options in Query Panel (see the procedure to configure option button controls in Configuring Other Controls).