Defining a Global Query

You can create a global query that uses a single artifact type or two or more artifact types.

To create a global query:

  1. Log into CollabNet as a Domain or a Project Administrator.
  2. Click the link "Global queries" to open the Global queries page.
  3. Select the "Create New Query" action. A list of the global artifact types is displayed.
  4. If you are going to include multiple artifact types in this query, you can identify artifact types for this query by checking the checkbox for all of the artifact types to be searched and click Add Selected.
    If you are going to include only one artifact type in this query, you can skip to step 6.
  5. To save this list of artifact types for future use, click the Save This Query button in the Artifact Types Selected section.
  6. Select one global artifact type, "Defect" to use in creating the global query. The query creation page is displayed.

You can specify additional query criteria, such as a date range, particular users associated with an artifact, and so on. Query criteria include:

Note: User associations in the artifact type are displayed with the possible selections of "has users associated" or "does not have users associated." You may also leave this criteria unselected and not used in defining the query. (Only with a "user" query)

  1. Click Define query.
    From this page, you can enter one or more of the following query criteria, as described in the following steps.
  2. In the Artifact Info section, you can enter both artifact IDs and date ranges.
    If the Artifact Info section is left blank, all artifacts of the designated type or types are returned in the query results.
  3. In the Artifact Changes section, you can enter a date or a date range in which the artifact was (or was not) modified.
  4. If your global query uses multiple artifact types, in the Common Attributes section, you can enter text strings or select artifact values from a list, for example, for a Status attribute, you might select the value of Open.
  5. In the query creation page, define the global query. This includes setting the display preferences (number of arifacts per page, display format, and so on) for the query results.
  6. You can add/remove columns through add/remove columns screen.
  1. To save this list of artifact types for future use, click the Save This Global Query button in the Artifact Types Selected section.
  2. Assign a name to this query, provide a description
  3. Click the "Done" action.
  4. You can now set a property on the newly created global query to indicate that it is to be included whenever the "Defect" global artifact type is added to a project.

Note: This is not possible if the global query is based on more than one global artifact type.

Defining the user query criteria

You can specify these criteria to look for artifacts assigned to a particular member of a team. To define a user query:

  1. Log in to CollabNet as a Domain or a Project Administrator.
  2. Click the Administration tab.
  3. Click Project Tracker > Global Queries from the left navigation menu.
  4. Select the saved query you have created and click the link of the saved query.
  5. Scroll down the page and under Personal Associations, click Edit List.
  6. Click the Special Values tab.
  7. Check the box next to <Current User> and select an association, for example Any.
  8. Click Add Selected.
  9. Click Done.