Creating the default queries for version control

When you add collections as tabs on the bottom of Web Access windows, the columns that appear on the tabs are specified by the default query for the corresponding object. If you do not specify a default query for this object, then only the Name object appears in these lists.

Similarly, the columns that appear on the CI dialogs in the Change process (for example, Add Configuration Item and Commit Configuration Item) are defined by the default query for the Configuration Item object.

By creating default queries for these objects, you can specify which columns appear on these lists and dialogs.

The procedure below lists recommended attributes to include in your default queries. However, you can add any attributes that you require.

Do not add unprompted criteria to the default query. The default query is used widely and unprompted criteria are always applied, which could lead to unexpected results.
You may, however, add prompted criteria to the default query, because these may be useful on the Attach... dialogs in Web Access. However, these prompted criteria are ignored on collection tabs.

To set up the default queries required for version control:
  1. Using Query and Report Designer, create the following queries, selecting the Everyone option button on the New Query dialog:

Change – CIs

Purpose – specifies the columns displayed in the CIs collection on the Change window

Module – Change Management

Business Object – Change Configuration Item

Attributes – Configuration Item.Title

<CI> Version

Purpose – whenever you enable version control for a CI, a <CI> Version object is created (for example, if you enable version control for Workstation, a Workstation Version object is created). You need to create a default query for each of these objects to specify which columns appear in the Versions tab on the corresponding CI window

Module – Configuration Management

Business Object – <CI> Version

Attributes – Number, Status.Title, Create Date, and whichever attributes have version control enabled for them

CIs

Purpose – displays the columns that appear on the CI dialogs in the Change process; grouping this query by Class.Title helps users to find the required CI by displaying each type of CI in a separate group

Module – Configuration Management

Business Object – Configuration Item

Attributes – Title

Grouping – Class.Title

  1. In Object Designer, open the Change Management\Change Configuration Item.
  2. In the Properties grid, alongside Default Query, select the Change – CIs query that you created above, then click .
  3. Similarly, select the appropriate Default Query for each of the CI Version objects and the Configuration Item object and save the changes.