The names of the priorities can be changed 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:

The script must be edited and run for each priority being changed.

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