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

Document ID : KB000010793
Last Modified Date : 14/02/2018
Show Technical Document Details
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:
Service Desk Manager 12.9 / 14.1 / 17
Instructions:

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.