Query Promotion Information: An Overview

The Query Promotion Information Function

The Query Promotion Information function is an interface for queries on change request activities.

How to Access the Query Promotion Information Function

This function is accessible from both the developer and administrator workbenches:


On This Workbench	Under This Menu Item
Developer	PM Promotion
Administrator	PM Promotion
Administrator	PS Source Promotion Administration
Administrator	PT Target Promotion Administration
Administrator	PR Remote Promotion Administration

Query Screen

The Query screen shows which change requests include given objects and which change requests were manipulated by given users. You can use the main Query screen to filter data to avoid searching all the change requests in the database. An example of this screen is illustrated below:

Date: 2000-02-17

Query Change Requests from NIAGARA____ at Location TORONTO____

Change Request:

Start Number ______

End Number ______

Category ____________________

Component ________________

Current Status _

Object: User: Activity:

Type ________________ Name ___________ Type ________________

Unit ________

Name ________________

PFKEYS: 3=END 4=END NUMBER 5=CLEAR 12=EXIT ENTER=PROCESS QUERY

Query Screen Fields

None of the fields on the Main Query screen are required. The node name fields default to the current node; the rest of the fields default to all. The fields are as follows:


Query Change Requests from	The node from where the change requests to be queried originated (source). The default is the local node.
at Location	The node from where the status information for the change requests is obtained. The default is the local node.
Start Number	The request number where the search starts. This filter can be used to narrow the range of change requests that is searched. The default is 0.
End Number	The request number where the search ends. This filter can be used to narrow down the range of change requests that is searched. If this field is left blank, the range begins with the start number and ends with the highest change request number for the source node and location. Press PF4 at any time to populate this field based on the source node and location displayed on the screen.
Category	The list of change requests to be used for the query can also be filtered by the category on the change request. If none is specified, all categories are considered. Press PF1 to list valid values.
Components	The list of change requests to be used for the query can also be filtered by the component on the change request. If none is specified, all components are considered.
Current Status	The current status of the change request. This filter makes it possible to check all change requests that have a given status. Press PF1 to list valid values.
Object Type	The type of object against which the query is being made. If a value is entered, Name or Unit must be also filled in. Press PF1 to list valid values.
Object Unit	The unit against which the query is being made. This field is used together with the Object Type field in queries.
Object Name	The name of an object. Use this field if searching for all change requests that contain the name of an object. The object can be any object that can be added to a change request. If it is entered, the Object Type field must also be filled in.
User Name	The name of a user. Use this field only when searching for change requests for which the given user has done some activity such as change request preparation or promotions administration. The query system recognizes only users active in any of the activities described below on its local node—not on any other node. The name of a library in a group rights environment could also appear when group rights are in effect.
Activity Type	The Activity Type field can be used to limit the output of the query to only those change requests for which a specified activity was done. It can be used together with the User Name field to limit the output to change requests for which the activity was done by that user. Refer to the field-level help for valid activities.