Based on the information you know, use the following
procedure to locate one or more tasks, projects, objects, change requests,
baselines, or project groupings in your database. You can use the
results of your query to view object properties, add objects, delete
objects from a project or database, and more.
Additionally,
you can add a saved query to an explorer or add a saved query to a
Find menu from within the appropriate explorer.
Procedure
- In the main menu, click Find,
and select the type of object you are looking for: Tasks, Objects, Change
Requests, Projects, Project
Groupings, Baselines, Releases, Folders, Process, Process
Rules, Folder Templates, or Transfer
Sets.
The Query dialog
box displays the object type you selected.
- Select criteria from the list box beneath Find,
and then set the value correctly in the box to the right.
Add more fields by clicking the plus
sign icon. See Customizing a query for
detailed information about criteria. See "Query Examples" below to
read about useful queries, along with scenarios for their use.
Additionally, you can build a new query from an existing
saved query, then click Save As to create the
new query.
Query
examples
- You have completed tasks, but have forgotten to
resolve the change requests. The following builds a query that gathers
all of your assigned change requests that are marked for release XX/10 and
that have completed tasks.
In the main menu, click Find,
and select Change Requests. In Custom,
enter:
release='XX/10' and crstatus='assigned' and
resolver='%user' and has_associated_task(status='completed')
- You have several assigned tasks, each with associated
objects, and need to work on more than one task at a time. The following
query gathers your assigned tasks that have associated objects, and
enables you to quickly choose a task that has changes and make it
your current task.
a. In the main menu, click .
b. Set Assigned to: %user
c. In Custom,
enter: not has_no_associated_cv()
- You need to find working state objects
that are members of the ico-1 project.
In the main menu, click Find,
and select Objects. In Custom,
enter:
status='working' and is_member_of('ico-1')
- You need to find and show all executable-type
object versions associated with task 374.
In the main menu, click Find,
and select Objects. In Custom,
enter:
type='executable' and is_associated_cv_of('task374-1:task:dbid')
- Click
. All results display in the results field.
Additionally, you can use built queries that you
have not saved, but want to run again. Use the left and right arrows
at the top, left of the dialog box to search the query stack for queries
you have performed during the session. This
enables you to run the query without building it again.
- If you are creating a saved query, Saving a query.