Stored query for Category in change Orders and Incident/Request/Problem

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

How to configure a where clause in a stored query for Category of Change Orders and Incident / Request / Problem?

There is a difference in where clause syntax for both types.

Environment

Release: 12.9 or higher
Component:  CA Service Desk Manager

Resolution

The stored query for Category in Change Orders:

. set type as: Change Order

. set where clause as: category = \'SW1\' AND active = 1 

In this case, the value 'SW1', in example is taken from the 'code' field from Change_Category table related to the Category you need to get information from the query

 

The stored query for Category in Request/Incident/Problem:

. set type as: Request

. set where clause as: category = \'pcat:5100\' AND active = 1

In this case, the value 'pcat:51001', in example is taken from the 'persid' field from Prob_Category table related to the Category you need to get information from the query

 

In summary, for Change Orders you may use the 'code' field from Change_Category table, while for Request/Incident/Problem you may use 'persid' field from Prob_Category table.