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" 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 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. You
can then 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 must 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 must find and show all executable-type object
versions that are 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. You
can then run the query without building it again.
- If you are creating a saved query, see Saving a query.