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.
Release: 12.9 or higher
Component: CA Service Desk Manager
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.