/build/static/layout/Breadcrumb_cap_w.png

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.
qruEbP.png

I need to change the Category to Underwriting Application with a sub-category of Policy Star.
pUkz6f.png
Any help would be much appreciated.

2 Comments   [ + ] Show comments
  • You can open the queue up under Service Desk > Configuration > Queue and change the default value of the Category field. - nshah 5 years ago
  • I have 12,000 tickets total and I only need to change the 400 that the Category is set to Policy Star with no sub-Category. - nadecats 5 years ago

Answers (1)

Posted by: chucksteel 5 years ago
Red Belt
0
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
Click Next
For Choose the values to change enter Category - Change Value To -  Underwriting Application::Policy Star
Click Done
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.



Comments:
  • This worked beautifully, thank you. - nadecats 5 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ