Example - Defining advanced qualifications for the Change Calendar queries

Using forms and defining advanced qualification criteria, you can create advanced search criteria for the calendar queries. This enables you to search for data according to your requirements.

Viewing data for change request with Site of Impact Areas as Americas

Allen wants to view Change records that impact sites in the Americas. For this he creates a custom query for Change Management that searches not only Change Request data but also data for Impacted Areas.

To create the query Allen performs the following procedure:

1. On the Change Calendar, from the Settings menu, Allen clicks Manage Queries.
2. On the Manage Queries dialog box, he clicks Create to create a new query.
3. In the Query Name, he enters Change Impact for Tier 1 and Site for Tier 2.
4. From Data source name, he selects Global > Change Request because he is creating the query for Change Management.
5. From Data source form, he selects Change And Impacted Areas because he wants to search for change record information and impacted area information.
6. For Qualification Builder, he clicks the (+) sign to build the qualification for his query.
7. On the Advanced Qualification Builder dialog box, from the Fields list he selects Impacted Site. The form field name is added to the Qualification box.
8. He clicks the = operator.
9. In the Qualification box, he adds "Americas". The constructed query is as follows:
   'Related Site' = "Americas"
10. He clicks Select to add the query to the qualification.
    
    
11. On the Manage Queries dialog box Allen clicks Save Query. The query is displayed under My Queries.
    
    
12. Allen clicks Close.
13. He then logs out of the system and logs back on.

14. He opens the Change Calendar. The saved query is displayed under Queries > My Queries > Change Impact > Site of the Filters & Queries pane.
    
    

    When Allen runs the query by selecting it from the list, the calendar data displays only change requests for which the Site under Impacted Area is Americas.

Viewing data for a business critical CI called Email Services

1. From Predefined Queries, select By Service.
2. On the Search Change Requests by Related Configuration Item dialog box:
   1. Under Change Requests, select Critical from the Priority field.
   2. Under Service, select Email Services from the Name field. A service with this name must exist in the system.
      
      
3. To save this query, enter a name for this query in the Saved queries field and click Save Query.
4. Click OK to run this query.