/build/static/layout/Breadcrumb_cap_w.png
09/06/2017 518 views
I am on K1000 version 7.1.149.  I read on another post that the default character limit for this field is 255 characters.  I keep having issues with technicians entering every detail into the title of a ticket instead of in the comments section.  I would like to be able to limit the Title field to a much smaller character limit.  I have some automated tickets that run so around 115-120 characters (with spaces) would be the absolute longest we should ever need for a title.  Is this possible, and if so, how could this be done?
0 Comments   [ + ] Show comments

Comments



Community Chosen Answer

1
Short of contracting Quest professional services the easiest way would be to change behavior, as this is a people problem, not a technology problem. If you want to send your technicians a "friendly reminder" you can use a ticket rule that let's them know they entered a title that is too long:
SELECT * FROM ORG1.HD_TICKET
WHERE CHAR_LENGTH(TITLE) > 100;
That's a very basic rule that will find tickets with a title over 100 characters. You could use a more complicated version on ticket save and email the technician to let them know. Depending on how fancy you want to get you can exclude tickets generated by your automation systems.
Answered 09/07/2017 by: chucksteel
Red Belt

All Answers

0
If you are okay with making this a permanent change for all the queues, support should be able to get this done in your database.
Answered 01/31/2018 by: karuna_kumar
White Belt