Querying Rational ClearQuest user databases

If you use the UCM integration with Rational® ClearQuest®, you can use Rational ClearQuest queries to retrieve information about the state of your project. When you create a new Rational ClearQuest user database or upgrade an existing Rational ClearQuest user database to use a UCM-enabled schema, the integration installs some queries in subfolders of the Public Queries folder in the user database workspace. These queries make it easy for developers to see which activities are assigned to them and for project managers to see which activities are active in a particular project. The following table lists and describes the queries.

Table 1. Queries in a UCM-enabled schema

Query	Description
ActiveForProject	For one or more specified projects, selects all activities in an active state type.
ActiveForStream	For one or more specified streams, selects all activities in an active state type.
ActiveForUser	For one or more specified developers, selects all assigned activities in an active state type.
AllActivitiesInStream	For one or more specified streams, selects all activities.
MyCompletedWork	Selects all activities in a completed type state for the developer running the query.
MyToDoList	Selects all activities in an active or ready state type assigned to the developer running the query.
UCMProjects	Selects all projects linked to the Rational ClearQuest user database.
UCMCustomQuery1	This query is not intended to be used directly by users; the integration uses it. When a developer checks out or checks in a file, or adds a file to source control and is prompted to select an activity, the integration calls this query to display the list of activities available in the stream associated with the developer’s view. You can customize this query on a per-developer basis by copying the query from the Public Queries folder to the developer’s Personal Queries folder and using the Query editor.