Ticket priority (deprecated)

Ticket priorities are defined in the tColumnValue table.

You can change the priority names using the following SQL script, where you set the new priority name (@newValue) and the weight of the priority you are changing (@priority 1-5):

DECLARE @newValue varchar(30) = N'lowest';
DECLARE @priority int = 1;

UPDATE 
	tColumnValue
SET 
	mColumnValue = @newValue,
	ColumnValueShort = @newValue
WHERE
	liColumnId = (SELECT iColumnId FROM tColumn WHERE sTable = 'tHdTicket' AND sColumn = 'Priority') AND 
	nOrder = @priority

Note:

Edit and run the script for each priority that is changed.

Did not find what you were looking for? Ask our technical support team.