Query Tab

This tab enables you to create an SQL script that defines the data that is exported to Excel.

To access

  1. On the ALM sidebar, under Dashboard, select Analysis View.

  2. Expand the analysis tree and select an Excel report.

  3. Under the Configuration tab, click the Query tab.
Important information
Relevant tasks
See also

User interface elements are described below (unlabeled elements are shown in angle brackets):

UI Element

Description

Generate. Generates the Excel report.

Query Builder. Opens the Excel Report Query Builder dialog box, offering extended functionality for creating SQL queries, including testing the query and adding parameters to the query. For details, see Excel Report Query Builder Dialog Box.

Add Query. Enables you to create a new query. A new tab is added to the query builder with the default name Query<number>.

When you generate the report, the results of each query are displayed in separate Excel worksheets.

Delete. Deletes the selected query.

Rename Query. Enables you to rename the current query.

Note: The Excel worksheet containing the data extracted by the query will have the same name as the query.

Database Type. Displays the type of database used for your project database.

You must write the SQL query using the syntax used by the project database type.

Find. Searches the query for text that you entered in the find box.

Tip: Click the Find button again to find the next occurrence of the text.
<Query Parameters grid>

Contains a list of parameters available for use in the queries.

Note: To add and edit query parameters, work in the Excel Report Query Builder. For details, see Excel Report Query Builder Dialog Box.
<SQL pane>

Contains the SQL query that defines the data set that is extracted to the Excel report.

Syntax exception: The @ and \ characters have a special meaning and are not read literally when running SQL queries on the project database. If you want these characters to be read literally, you should replace @ with \@ and \ with \\. For example, if you want the statement
SELECT * FROM BUG WHERE BUG.BG_SUMMARY = `@parameter@' to be run literally on the ALM database, type SELECT * FROM BUG WHERE BUG.BG_SUMMARY = `\@parameter\@'.