Creating a New Query



  1. From the Query menu, select New Query or from Toolbar, select New Query button.
  2. The Make Query Dialog box will appear. Your cursor will appear at the Query Name field.

    The name of your query will be displayed in the Title bar. Save it by:

    Choose Yes in Save Query? dialog box. It will appear at the end of the Query Menu. You can access your query by highlighting it from the menu.

    Check [ ] Make this the start up query. If you would like to view your selected options each time PR-Tracker is started.

How to use Make Query Dialog

Make Query Dialog box consists of the following items:

  1. Query Name text box
  2. Status checkboxes
  3. Rules (B,C,D,E,F,G,H) combo boxes
  4. Condition text box
  5. Adjust button
  6. A list of views available in drop-down combo box
    1. Selecting problems according to status

      To select problem reports according to status click the status checkboxes that correspond to problems that you want to select. For example, to list all "new" problem reports,

      1. Check [ ] New
      2. Type letter A in the Condition text box.
      3. Choose OK. The Problem List will be displayed containing only new problem reports.

      To list all problem reports except those that are closed, in the Make Query Dialog do these steps:

      1. Check [ ] Closed.
      2. Choose Invert Status Selections. 
      3. Type letter A in the Condition text box.
      4. Choose OK.
    2. Selecting problem reports according to assignment

    3. To select problem reports that are assigned to a specific user Tom Tester as an example, perform the following steps:

      1. Select a combo box, which has letter B, C, D, E, F, G, or H on the left-hand side.
      2. Select Assigned To as the field using on the button on the keyboard.
      3. Hit Tab and select equals as the relation
      4. Hit Tab and type Tom Tester as the value into the combo box.
      5. In the Condition text box, type letter B, C, D, E, F, G, H depending on which combo box you have chosen above.
      6. Choose OK.
    4. Select problems that have been modified in the last 3 days

      1. Select a combo box, which has letter B, C, D, E, F, G, or H on the left-hand side.
      2. Select Modification Date as the field using on the button on the keyboard.
      3. Hit Tab and select less than as the relation.
      4. Hit Tab and type -3 as the value into the combo box.
      5. In the Condition text box, type letter B, C, D, E, F, G, H depending on which combo box you have chosen above.
      6. Choose OK.
    5. Selecting problem reports that contain a string

      To select problem reports that contain a certain string in a title or the problem report description:

      1. Select Title or Description from a combo box at the bottom of the query form.
      2. Tab to next field and select contains.
      3. Tab to next field and type the string.
      4. Choose OK
      5. The Problem List will be displayed containing problems with your specified string.

        Searching for a string in problem report text can take a long time if there are lots of problem reports. You can speed up the search by specifying additional selection criteria.

    6. Selecting problem reports satisfying multiple criteria

      You may reduce the subset of problem reports more by specifying more than one search criterion. If you specify multiple selection criteria then a problem report must match all of the selection criteria to be selected.

      For example, to select all problem reports that are not closed and with priority of 1 or 2, do these steps.

      1. Check [ ] Closed
      2. Press command button Invert Status Selections
      3. Select Priority from a combo box at the bottom of the Query form.
      4. Tab to next field and select less or equal.
      5. Tab to the next field and enter 2.
      6. Type A and B in the Condition text box; if you don't, PR-Tracker will give a warning and automatically enter A and B into the Condition text box for you.
      7. Choose OK.


    Bug tracking doesn't have to be complicated | Help | Site Map