K1000, MySQL code to modify a field in service desk.
I have a need to modify a field in service desk tickets and do not know where to start. Currently the Category is set to Policy Star with no sub-Category.
I need to change the Category to Underwriting Application with a sub-category of Policy Star.
Any help would be much appreciated.
Please log in to answer
Posted by: chucksteel 5 years ago
In the Admin Console browse to Service Desk, Configuration, Queues.
Select the queue containing the tickets that need to be updated
Find the Ticket Defaults section and click Customize these values link
Add the new category, sub categories are created by entering the value as Underwriting Application::Policy Star
Save the configuration
Find the Custom Ticket Rules section on the queue configuration page and click the Customize link
Click Choose Action, New (Wizard)
Select Category = Policy Star
For Choose the values to change enter Category - Change Value To - Underwriting Application::Policy Star
On the Ticket Rule Detail page click Run Now
By default this rule will be set to run daily. I would recommend disabling the rule once the tickets are updated.