Query Menu Command Reference

The table below provides a quick reference to the commands available on the Query menu and lists any related shortcuts.

Table 21. Query Menu Commands 

Command

Description

Keyboard Shortcut

Shortcut Menu

Process Results To Table

Allows you to create a table in the database to store your results set.

  

Estimate Query Size

Queries the database to see how many records your query will retrieve.

  

Show Remarks

Displays any remarks recorded about a topic or topic item.

Ctrl+I

*

Add Request Item(s)

Adds the selected topic item to the Request line.

 

*

Add Filter(s)

Allows you to create a filter for the selected topic item.

Ctrl+L

*

Add Sort(s)

Adds the selected topic item to the Sort line.

  

Add Computed Item

Allows you to add a new data item derived from server-side calculations performed on an topic item.

 

*

Data Functions

Applies a prebuilt data function to the selected Request item.

 

*

Variable Filter

Designates the selected filter item as variable, which causes Interactive Reporting to prompt the user for the filter values when the query is processed.

 

*

Customize Filter

Allows you to control access to the features on the Filter dialog box.

 

*

Append Query

Allows you to combine two or more queries in one Results set.

  

Stored Procedures

Loads a stored procedure and displays it as a query object in the Content pane.

  

Query Options

Opens the Query Properties dialog box where you can specify options for rows returned, time filters, and so on.