Currently HelpMaster does not support bulk-updates of job classification codes such as Priority, Contact Type, Job Type, Issue etc, however there is a way to do it using direct SQL against the HelpMaster database.

CAUTION!  Using direct SQL against your live HelpMaster database should be used with care!  It is possible to update/delete records in an unintended manner.  There is no undo with SQL - the only "undo" is a restore from your last good backup.

The following SQL can be used to bulk-update classification codes for jobs.

In each example, replace the words "UPDATE WITH EXACT NAME OF CODE" with the exact name of the classification code you want.  Check your System Codes screen within HelpMaster to see the full list available to you.

Also, replace the comma delimited list of job numbers in the Where clause with the number(s) of the jobs you wish to update.  For advanced SQL users, this can also be a Select statement that identifies each target job - use with caution!

Job Type

Update tblHelpdeskJobs
Set JobTypeLink = (Select Top 1 PKID From qrySystemCodes_JobType Where JobType = 'UPDATE WITH EXACT NAME OF CODE')
Where PKID In(101,102,103,104,105) 

Job Priority

Update tblHelpdeskJobs
Set PriorityLink = (Select Top 1 PKID From qrySystemCodes_Priority Where Priority = 'UPDATE WITH EXACT NAME OF CODE')
Where PKID In(101,102,103,104,105)