Working with queries

Queries are the building blocks for reports. A report consists of a saved query and a corresponding format. You can create a change request or task report by selecting or defining a query. Then, select a format for the output. Use the Queries dialog box to create queries.
Queries can be saved and are organized for you in different folders. These query types and folders are: As with queries, formats can also be saved and organized in folders. Formats are categorized in a similar way as queries, using Personal, Shared, and System folders (and subfolders). When you save a query and its corresponding format together, it becomes a report.
To work with a query:
  1. Generate a query by providing the following information in the Queries dialog box, in the order requested:
    • Select a Query - the query string you specify defines the contents of the query.
    • Select a Format - the format you specify defines the layout of the information.
    • Perform Action - the action you specify (run a report, save a report, and so on) is executed.

      After generating a query, you can easily modify it by changing the fields that are queried for. Additionally, you can change the look of the output by using a different format. You can also share a query with others.

  2. Query for a set of CRs, and then modify the CRs as a group.

    If you are logged on to the central CR database, you can query or report on CRs only. The central CR database does not contain tasks. Tasks that are found using a top-level task query exist in the current development database only.

  3. Define queries so that they prompt you for information. Then, you can use a query again so that it provides like sets of information for a given field or fields.
  4. For example, you can query for the same sets of information for different products, releases, months, and so on. You can set up a prompting query so that you are prompted for one or more responses before the query is run.

Feedback