Share this page

# Query Tab

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

To access | On the ALM sidebar, under Dashboard, select Analysis View. Expand the analysis tree and select an Excel report. Under the Configuration tab, click the Query tab.
Important information | To ensure the integrity of the database, you should run only queries that extract data from the project database. For details, see Protecting the Database. The query builder provides enhanced functionality for creating SQL queries. For details, see Excel Report Query Builder Dialog Box.
Relevant tasks | How to Generate an Excel Report How to Analyze Data in ALM
See also | Excel Reports Overview Analysis View Window

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\@'`.

https://admhelp.microfocus.com ALM 8942
Tips to improve your search results... ALM Help Center ALM Help Center ALM Help 15.5-15.5.1 All View Local Help Center View Online Help Center back Go back in browser history forward Go forward in browser history Remove search highlights next topic Go to next topic previous topic Go to previous topic Print the current topic Version: