Overview

A ProblemTracker report is composed of a search criteria (query) and an output layout (report format). You can define and save both queries and report formats. This enables you to quickly select from a list of frequently used queries, rather than re-entering all the query parameters for each query. You can use either group or personal saved queries. You can always save a personal saved query, and if you have been given permission by your Administrator, you may also be able to save a query or report for use by all users in your assigned user group.

Saved queries are managed by the Saved Query bar which appears on the Query Page below the status bar, as shown below:

Using the Saved Query bar, you can define new queries, edit or remove existing saved queries, and run or preview a saved query. Group level saved queries are listed followed by the User Group name in square brackets.

Saved report formats are managed by the Saved Report bar which also appears on the Query Page below the status bar, as shown below:

Using the Saved Reports bar, you can define new report formats, and edit or remove existing saved report formats. Group level saved report formats are listed followed by the User Group name in square brackets.

Define a Saved Query

To define a saved query, follow these steps:

1. Press the Add button on the Saved Query bar. Note: to create a Saved Query that is similar to an existing Saved Query, select the existing Saved Query in the pulldown menu to the left before clicking the Add button.
2. In the form that appears, enter a query name (this is the name that you will use to retrieve the query) in the "Query Name" field.
3. Optionally select whether this is a Personal or Group saved query. If it's a Group saved query, also select the User Group that it should be visible to.
4. Enter the parameter for the query as you would for a normal query.
5. Press the "Save Query" button.

Run a Saved Query

To run a saved query, follow these steps:

1. Click on arrow in the combo box control in the Saved Query bar and select the desired query from the drop-down list.
2. Press the Run button in the Saved Query bar.

Preview a Saved Query

Many times you may wish to verify the parameters of a saved query before running it or perhaps modify it slightly before running it. The ProblemTracker saved query Preview feature allows you to do this.

To preview, optionally modify, and run a saved query, follow these steps:

1. Press the Preview button in the Saved Query bar. The parameters for the saved query appear in the query dialog below.
2. Modify the query parameters if desired.
3. Press the "Run Query" button in the query dialog to submit the query.

Set Default Saved Query Drop-Down Menu Selection

To set the query which you would like to appear in the Saved Query drop-down list when you first browse to the Query page, follow these steps:

1. Click on arrow in the combo box control in the Saved Query bar and select the query you would like to be the default from the drop-down list.
2. Press the Default button in the Saved Query bar. The page will be refreshed and the Status will say "Default Query has been updated.".

Edit a Saved Query

To edit a saved query, follow these steps:

1. Click on arrow in the combo box control in the Saved Query bar and select the query you would like to edit from the drop-down list.
2. Press the Edit button in the Saved Query bar. A page containing the current query parameters is displayed.
3. Edit the query parameters as desired.
4. Press the "Modify Query" button to save your updates.

Delete a Saved Query

To delete a saved query, follow these steps:

1. Click on arrow in the combo box control in the Saved Query bar and select the query you would like to remove from the drop-down list.
2. Press the Delete button in the Saved Query bar.

Define a Saved Report Format

To define a report format, follow these steps:

1. Press the Add button on the Saved Report bar.
2. In the form that appear, enter a report name (this is the name that you will use to select the report format) in the "Report Layout Name" field.
3. Optionally select whether this is a Personal or Group saved report format. If it's a Group saved report format, also select the User Group that it should be visible to.
4. Select how to align text fields (left, center, right).
5. Select the maximum size for text fields.
6. Select the fields you would like displayed.
7. Press the OK button.

Edit a Saved Report Format

To edit a saved report format, follow these steps:

1. Click on arrow in the combo box control in the Saved Report bar and select the report format you would like to edit from the drop-down list.
2. Press the Edit button in the Saved Report bar. A page containing the current format is displayed.
3. Edit the format as desired.
4. Press the "OK" button to save your updates.

Delete a Saved Report Format

To delete a saved report format, follow these steps:

1. Click on arrow in the combo box control in the Saved Reports bar and select the query you would like to remove from the drop-down list.
2. Press the Delete button in the Saved Reports bar.

Use a Saved Report Format in a Query

To use a saved report format in a query, follow these steps:

1. Click on the Query icon in the navigation bar.
2. Enter the query directly or start with an existing Saved Query by selecting the Saved Query and clicking Preview.
3. Scroll down to the bottom of the page and select the Saved Report Format in the Report Layout pulldown.
4. Press the Run Query button.

Use a Saved Report Format in a Saved Query

To use a saved report format in a saved query, follow these steps:

1. Click on the Query icon in the navigation bar.
2. Select the Saved Query in the Saved Query bar and click the Edit button.
3. Scroll down to the bottom of the page and select the Saved Report Format in the Report Layout pulldown.
4. Press the OK button to save the edited Saved Query.