Change Requests Page, Front Desk

Menus and toolbar

The Change Requests page contains the following menus:

Queries

• Save
• Save As
• Save All
• Export Grid
• Print Setup...
• Print Record Setup...
• Properties
• Close Query

Change requests

• Find Duplicates
• Find...
• Original of Duplicates
• Generate Report...
• Generate SoDA Report

These commands are also available on the menus of the standard ClearQuest client.

The Change Requests toolbar provides quick access to the following operations:

Current query

Lists the name of the current query and other recently run queries. You can select a different query to run it.

Run query

Runs the last-saved version of the query in the query editor and displays the result set in the window.

Generate report

Opens the Generate Report window, in which you can specify a report format to use and generate a report for the current result set. A report format for that query must already be defined.

Find duplicates

Finds ClearCase records that have been marked as duplicates of a selected record.

For information about these commands, see ClearQuest Help.

Change Requests window

The Change Requests window enables you to create and edit queries. It is displayed when you open either a change request or a chart item from the Change Requests page.

The Change Requests window can have up to four pages:

Result set

Displays your query results according to parameters set in the Display editor. You can scroll through a list of query records, search, perform state transitions, and choose records to modify. For example, double-click an item in the result set to open the record form, where you can modify the record.

Query editor

You define queries on the Query editor page. The Query editor has two parts: the Query editor page and the Filter dialog box.

Record fields are listed in the Fields pane of the Query editor. Fields that are selected as filters are listed in the Filters pane on the right.

There are two ways to select query filters:

• Double-click the record to move it to the Filters pane.
• Drag a field from the Fields pane to the Filters pane.

When you select a filter, it becomes active and the Filter dialog box opens.

To define a filter, use the Query editor to select a field; then use the Filter dialog box to define the criteria for your search.

Display editor

After creating a query, use the Display editor to determine how the records are displayed. You can add or delete fields from the display, and sort query results by using the Sort and Sort Order options. You need to set up your grid only once, but you can always return to the Display editor to change it.

SQL editor

If enabled in your installation, the SQL editor allows you to view and edit the SQL code that creates your query. If you choose to edit the SQL code manually, you cannot use the other tabs to customize the display or edit the query. You must have SQL editing privileges to edit SQL.

Important: When editing the SQL statement of a query that was not mastered at your site, you must make sure that your database type is the same as the original database type. For example, Sybase and Oracle databases may have different SQL syntax rules. In such cases you can easily corrupt a query by applying incorrect syntax.

Chart window

The Chart window shows charts that you open from the Change Request Queries window, along with the Query Builder. Use the Query Builder to create and edit queries for charts just as you do with change requests. The Result set page displays data points for the chart.

Report window

Because the Report window uses Crystal Report functionality, it may look and behave somewhat differently from other ClearQuest windows. The toolbar provides some viewing and browsing options. You can export or print a report from this window.