Querying HCL Compass user databases
If you use the UCM integration with HCL Compass, you can use HCL Compass queries to retrieve information about the
state of your project. When you create a new HCL Compass user database or upgrade an existing
HCL Compass 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.
| 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 HCL Compass 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. |
You can also create your own queries by clicking within the HCL Compass client. In the Choose a record type window that opens, select All_UCM_Activities if you want the query to search all UCM-enabled record types.