New Query Tab

You use the New Query tab to create and edit AccuWork queries, and to view and manage query results.

Overview

Consider using the New Query tab for initial query development—the query and its results are both displayed within the tab, which makes it easy to quickly check query results, modify the query as needed, and then rerun the query. When you are satisfied that the query is performing as expected, you can move it to the Query Browser and save it for use in future AccuRev sessions.

The New Query tab has two panes, each with its own toolbar:

The Query pane contains tools used to create, edit, and manage AccuWork queries.
The Results pane displays the list of issues returned by the query, as well as a set of tools you can use to view and manage query results.

Display the New Query Tab

To display the New Query tab, click the New Query button () on the AccuRev main toolbar.

Query Pane

You use the Query pane to can create, modify, and run AccuWork queries. When you run a query, AccuRev retrieves the set of AccuWork issue records that satisfy the query from the AccuRev depot and displays them in the Results pane.

The Query pane displays a template you use to build a query by clicking on clauses. The clauses that define the query are displayed as an expandable tree. The tree nodes may contain:

The query name, which is always the top node in the tree. The default name for new queries is New Query N (where N is a unique number).
Simple clauses, such as Assigned To is mary (can appear at any level). Every query has at least one simple clause.
Compound clauses, which start with AND or OR. These clauses can contain any number of other simple or compound clauses.
See Create a Query for more information on using the tools in the Query pane to create an AccuWork query.

Commands

You can invoke the following commands from the Query pane toolbar.

Run

Runs the query; results are displayed in the Results pane.

Set up Columns

Allows you to specify which columns (AccuWork fields) are displayed in the Results pane for the selected query. You can optionally save selected columns as a default set to be used to display results for any new queries you create. This command is disabled for public queries created by other AccuRev users. See Set up Columns for more information.

Move to Queries

Opens the Query Browser and moves the new query to your list of queries. You must save the query once it has been moved if you want to use it in a new AccuRev session.

(AND) Group

Creates an AND compound clause placeholder as a child of the selection. You must select the query title or another compound clause before this button will be enabled. This command is also available from the context menu.

(OR) Group

Creates an OR compound clause placeholder as a child of the selection. You must select the query title or another compound clause before this button will be enabled. This command is also available from the context menu.

Delete

Deletes the selected clause. This command is also available from the context menu.

Tip: The Delete key on your keyboard also performs the delete action.

Copy

Copies the currently selected query node (the current clause and any subordinate clauses) to the clipboard. See Copying and Pasting Conditions and Clauses for more information.

Paste

Pastes the contents of the clipboard into the currently selected query node. See Copying and Pasting Conditions and Clauses for more information.

Results Pane

The Results pane displays the issues returned by the query. You can perform the following actions from the Results pane. Commands are available from both the toolbar and context menu unless noted otherwise.

Set Table Size

Allows you to specify the number of issues you want to display on a single page in the Results pane. If the number of issues returned by the query exceeds the number you specify, AccuRev creates additional pages in the Results pane. Available on the toolbar only.

Bulk Update

Allows you to change field values for multiple issues in a single operation. For example, if you assign an Owner to issues, you can use Bulk Update to change the Owner from unassigned to Henry. See Bulk Update for more information.

Sum Columns

Returns the number of issues selected, as well as the sums of all Text fields with numeric-only data and the sums of all Timespan fields. See Sum Columns for more information.

Calculate Columns

Allows you to perform basic mathematical operations (add and subtract, for example) on any two columns with numeric values. Available from the toolbar only. See Calculate Columns for more information.

Show Percentage

Toggles the display of percentage information for the grouped issues. Available from the toolbar only. See Show Percentages for more information.

Group By

Groups the issues shown in the Results pane by the issue field chosen from this drop-down list. Available from the toolbar only. See Group Issues by Field for more information.

Tip: When you group issues, AccuRev enables graphical reporting tools such as pie charts and bar charts. See Charts for more information.

Hide Search Query/Show Search Query

Toggles the visibility of the Query pane. Available from the toolbar only.

Create a Query

You can use the procedure described in this section to create a query from either the:

New Query tab
Query Editor

The query building tools are the same in both of these interfaces.

To create a query:

In AccuRev, click the New Query button () on the main toolbar.

The New Query tab appears.

Alternative: In the Query Browser, click the New Query button ().

The Query Editor appears.

Use the query builder to create new clauses for the query:
Click the Click here to add link.

AccuWork displays a template for the clause; use the drop-down list to choose the issue field you want to use to construct your first clause:

Tip: Each time you click Click here to add, AccuWork displays a new Click here to add link, so that one is always available at each level of the query.
Use the template to create the simple and compound clauses you want for your query. See Work with the Query Builder for more information.

Note: Simple clauses at the top level of the query are logically ANDed together by default—that is, an issue in the AccuRev depot must satisfy all of the clauses you specify in order to be returned by the query.

When the query is complete:
- If you created the query in the New Query tab, click the Run button (). Results are displayed in the Results pane.
- If you created the query in the Query Editor, click the Ok button to save your work. AccuRev runs the query automatically and displays it and its results in the Query Browser.

Review the query results. If necessary, modify the query and run it again.

See Query Results Pane to learn about sorting, filtering, and graphing query results.

If you created the query in the New Query tab and want to use it in another AccuRev session, click the Move to Queries button ().

The query is moved to the Query Browser. It is selected by default.

Click the Save button ().

Work with the Query Builder

The query builder is the tool you use to add and modify clauses in new and existing queries. This section describes editing operations supported by the query builder.

Creating a Simple Clause

Every query consists at least one simple clause. A simple clause has three parts:

<field-name><comparison-operator><value>

The point-and-click interface makes creating a simple clause easy. Start by clicking one of the Click here to add links in the query to add placeholders for each part of the clause.

First, select a field name from the list box containing all the field names. When you select the field name, the Query Editor automatically adjusts the available values for the other parts of the clause, based on the values allowed (see Allowed Comparisons and Values) for the selected field.

In the example below, the user has selected the Submitted By field, and is contemplating which comparison operator to choose.

Note that the comparison operators <is in> and <is not in> allow multiple values to be selected. After you select the operator, the options appear in a list box, from which you can make multiple selections. The completed clause contains all the selected values, separated by commas, and the individual values are considered to be combined with an OR.

Therefore, the query displayed below would be read as "Show all issues for which the date submitted is after or equal to April 1, 2009 at 14:52:14, AND the issue state is Complete or Verified."

After creating all three parts of the clause, you can create other simple and compound clauses to finish specifying the search criteria for the query.

Note: Date fields contain an icon that inserts the cur_date variable into the value field. This variable ensures that the clause will refer to the current date when the query is being accessed.

Creating a Compound Clause

A compound clause combines any number of simple clauses, using the same logical operator: AND or OR. (The NOT operator is not supported.) You can combine both simple and compound clauses.

The query builder automatically creates placeholders for simple clauses, but you must explicitly insert a compound-clause placeholder yourself. To do so, select the query title or an existing AND or OR statement, and click one of the or buttons. Then, specify the field name, comparison operator, and value for the clause using the Click here to add link under the compound-clause placeholder.

Deleting a Clause

To delete a clause, select it using the selection handle and click the Delete button (). The selection handle is the blue dot that precedes each clause, as shown in the following illustration.

Tip: The Delete key on your keyboard also performs the delete action.

Moving a Clause

To move a clause within a query, click and drag the selection handle, dropping the selected clause on the query title or a compound-clause placeholder. You can move both simple and compound clauses in this way.

Copying and Pasting Conditions and Clauses

When you are building queries, it can be convenient to copy and paste existing AND/OR conditions and individual clauses instead of redefining them manually. The Query Editor copy/paste feature lets you do this.

When you select an AND/OR condition, AccuRev copies the condition and any clauses that have been defined for it to the clipboard. If you select a single clause, only that clause is copied to the clipboard. Items copied in one query definition can be pasted in another.

To copy and paste a query condition or clause:

Select the AND/OR condition or individual clause you want to copy.
Click the Copy button () on the toolbar.

Alternative: Right-click the condition or clause and choose Copy from the context menu.

Select the target for the paste operation. This can be the query name or an AND/OR folder.
Click the Paste button () on the toolbar.

Alternative: Right-click the target for the paste operation and choose Paste from the context menu.
Modify the fields in the pasted clauses as needed.

Edit a Query

To edit an existing query:

Select the query in the Query Browser.
Click the Edit Query button ().

The query appears in the Query Editor, as shown in the following illustration.

Generally speaking, you can perform as editing operations any operation you perform to build the query. For example, you can:

Create simple and compound clauses.
Edit existing clauses
Move existing clauses
Delete existing clauses

See Work with the Query Builder for more information.

Note: You cannot rename a query using the Edit operation. See Rename a Query for more information.

Rename a Query