) on the AccuRev main toolbar.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 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 Creating a Query for more information on using the tools in the Query pane to create an AccuWork query.
Run
Set up ColumnsAllows 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
(AND) Group
(OR) Group
DeleteTip: The Delete key on your keyboard also performs the delete action.
CopyCopies the currently selected query node (the current clause and any subordinate clauses) to the clipboard. See Copying and Pasting Conditions and Clauses on page 66 for more information.
PastePastes the contents of the clipboard into the currently selected query node. See Copying and Pasting Conditions and Clauses on page 66 for more information.
Set Table Size
Bulk UpdateAllows 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 ColumnsReturns 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 ColumnsAllows 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 PercentageToggles 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.
|
1.
|
).
|
3.
|
Click the Click here to add link.
|
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.
|
4.
|
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.
|
•
|
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.
|
|
7.
|
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 (
 ). |
|
8.
|
).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.
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."
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.
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.
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.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.
). 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.
|
2.
|
Alternative: Right-click the condition or clause and choose Copy from the context menu.
|
4.
|
Alternative: Right-click the target for the paste operation and choose Paste from the context menu.
|
2.
|
).
See Working with the Query Builder for more information.
Note: You cannot rename a query using the Edit operation. See Renaming a Query for more information.
|
2.
|
).
|
3.
|
|
4.
|
The following table shows all the AccuWork data types, along with the corresponding choices for the <comparison-operator> and <value> parts of a simple clause.
|
The comparison is always a case-insensitive string comparison, never a numeric comparison. For example, the value 3 is greater than the value 25.
The contains and does not contain operators perform a simple case-insensitive substring search, with no pattern matching.
The matches and does not match operators perform case-insensitive pattern matching, using these wild cards:
* matches 0 or more characters
? matches any 1 character [aekz] matches a, e, k, or z [a-e] matches a, b, c, d, or e (do not mix uppercase and lowercase here) {one,two,seven} matches one, two, or seven \ or / Matches any directory-separator character, even if it is the "wrong one" for the client machine. For example, src/do_*.java matches src\do_something.java on a Windows client. |
||
|
An integer, identifying a particular AccuWork issue record (Issue field) or a particular AccuRev transaction (Transaction field).
|