RunQuery Browser
The Query Browser is used to run AccuWork queries. When a query A set of search criteria that selects records from an AccuWork issue database, based on the records' field values. Each AccuWork issue database can have one of its queries designated as the 'default query', to be invoked automatically in certain situations calling for the user to specify one or more issue records. is run, it retrieves a set of AccuWork issue records according to user-defined selection criteria.
By default, the queries you create are private queries, which cannot be seen by other users. You can declare any of your queries to be a public query. Such queries are visible to all users, who can use them, but cannot modify your original.
Click the Issue Queries button on the Web GUI toolbar to open a Query Browser tab.
This tab has two panes, each with its own toolbar:
The Query List pane lists the names of all your private queries, along with public queries, which are available to all users. Using the toolbar in this pane, you can view and run existing queries.
When you run a query, the set of issue records selected by the query are displayed in a table in the Query Results pane. If you've set a default query for this issue database, it is executed automatically when you open the Query Browser.
If you have set a default query, the results of that query display when you open the Query Browser.
The Query List pane contains a list of the private queries (AccuWork) A query that appears in the Query List pane only for the user who created it. you've defined for the current issue database (AccuWork) A set of issue records, each of which implements a bug report, feature description, etc. Each depot can have its own issues database. Each issues database has its own schema., along with any public queries (AccuWork) A query that appears in the Query List pane for all users. defined by you or other users. The listing is not alphabetical -- more recent queries appear at the end of the list.
Your queries (both private and public) are always listed above other users' public queries.
When you select a query in the Query List pane, the Query Results pane shows the set of columns in the results table for that query. The results table’s design can also include a sort order for the rows. Use the Set up Columns command to change the columns shown in the query.
You can invoke the following commands from the Query List toolbar, or from the context menu in the Query List pane. Most of these commands, except as indicated below, operate on a selected query that you created.
Run
Executes (or re-executes) the selected query, displaying the most recent results in the Query Results pane. You can also double-click a query to run it. You can run all the queries shown in the Query List pane.
Saves changes to all your queries. This command is only available from the Query List toolbar.
New Query
Creates a new query named New Query N (where N is a unique number) and opens it in the Query Editor. This command is only available from the Query List toolbar. Use the Rename Query command to rename the new query.
Edit Query
Opens the Query Editor, which allows you to edit the selected query.
Opens a dialog that allows you to rename the selected query.
Creates a duplicate of the selected query. If you clone a public query, the new query will be set as private by default.
Set up Columns
Opens a dialog that allows you to change which columns (AccuWork fields) appear in the Query Results pane for the current query. This command is only available from the Query List toolbar.
Move Query Up
Moves the query up within the list of queries.
Move Query Down
Moves the query down within the list of queries.
Delete Query
Deletes the query.
Set as Default / Disable as Default
Toggles the auto-run state of the selected query. If a query is set as default, it runs automatically when you open the Query Browser. Only one query at a time may be set as default; this menu option overrides your previous choice.
Set as Private / Set as Public
Changes the query from public to private, or vice-versa.
Properties
For public queries only, displays a dialog with mailto and hypertext links to the selected query.
The mailto link () opens a new email message (using your system's default email application) when you click it. The body of the email contains the query URL. Recipients can click the link (after logging in to the Web GUI) and view that query.
The hypertext link contains the same information as the mailto link, in a form useful for bookmarking or distributing. For security reasons, navigating to a bookmark saved from AccuRev will cause the Login dialog to appear if you are not logged in. After you log in, the URL's contents appear immediately in your browser.
The Query Results pane contains a table that displays the results of a query. Each row of the table displays one issue record. Query results sometimes contain many items, which can become unwieldy to search through. You can click the table size icon () above the table header to configure how the data is displayed. This action displays a Table Filter dialog, which configures the number of items to show per page.
After you set the number of items per page, the data is shown in pages rather than one long list. The default number of items is 500. When there are more items than the limit, page navigation links appear above the table header as shown in the image.
You can invoke the following commands from the context menu in the Query Results pane.
Opens the selected issue in an Issue Edit Form. If a third-party issue tracking tool has been configured to display AccuRev issues, the issue opens in that tool instead.
Show Change Package
Opens a Changes tab, showing the entries in the change package for the selected issue. Each of the entries in a change package A set of entries, each in the form of a basis-version/head-version pair, recorded on the Changes tab of an issue record. The change package records the changes to one or more elements, made to implement the feature or bugfix described in that issue record. Each entry in the change package describes changes to one element: the changes between the basis version and the head version. See also patch. indicates one or more changes made to a version-controlled element to implement a feature or fix a bug.
Save
Clone Query
Open Issue