Defining a query

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

  1. 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.

  2. 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 Find > Tasks.
      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')

  3. Click query icon.

    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.

  4. If you are creating a saved query, see Saving a query.

Feedback