Some users have expressed the desire for all jobs that were last actioned by Clients to revert to the unread state in Workgroup Explorer to make jobs requiring attention easier to find in their Open Jobs queue.

Currently HelpMaster will only set an existing read job to the unread state if the Action Template used to add a clients response from Email Manager or the Web module has the 'Assign To' field selected. This feature request has been logged for inclusion in a future feature release but as a work-around a Priority Manager profile can be created with custom SQL to set every recent job updated by a client back to the unread state as follows;

1. Create a new Priority Manager profile,
2. Give it a name,
3. Select the "Custom SQL" option,
4. Paste in the following SQL.  Note, the SQL will only "look" for open jobs that have been actioned by clients only in the last 5 minutes,
   
   
   SELECT DISTINCT tblHelpdeskJobs.pkID
   FROM tblHelpdeskJobs INNER JOIN
    tblLink_Jobs_Clients ON tblHelpdeskJobs.pkID = tblLink_Jobs_Clients.JobLink LEFT OUTER JOIN qryActionsLinkedToJobs_LastActionOnly ON qryActionsLinkedToJobs_LastActionOnly.ActionJobPKID=tblHelpdeskJobs.pkID
   WHERE (tblLink_Jobs_Clients.IsPrimaryClient = 1) AND
   (DateAdd(minute, 5, LastActionedDate) >= getUTCDate()) AND (dbo.tblHelpdeskJobs.StatusLink <> 2) AND (ActionedBy NOT LIKE '%Priority Manager Service%') AND qryActionsLinkedToJobs_LastActionOnly.ActionedByLink NOT IN (Select tblStaff.ClientLink FROM tblStaff) AND (Properties & 1) = 1
   
    
5. On the Actions To Perform screen, select the "Execute this SQL" and paste in the following not including the [Click "Insert Job# tag"] which is a button you need to press on this screen to insert the job variable;

Update tblHelpdeskJobs Set Properties = Properties-1 Where (Properties & 1) = 1 AND tblHelpdeskJobs.PKID = [Click "Insert Job# tag"]

6. In the "Frequency" section set the profile to run every '5 Minutes' and the recurrence to "Perform all actions EVERY TIME this profile is run for all jobs found by this profile,
7. Enable the Priority Manager profile and let it do it's thing,
8. All jobs actioned by clients will now be reverted to the 'unread' state.

Done!