Add Another Workaround - Check For Previous Jobs with Higher Priorities

Setup

The Startup script using an SQL Databox (Multiplejobs.MultiOrderCheck), checks for previous jobs raised within the past 4 minutes (Date/Time.DateChecks.DateTime) by the same user, on the same property and writes the details into a script Databox (Multiplejobs.Details).

Results

The Results Script checks the details of those previous jobs if any are detected.

• If there is a job found and it has an Urgent priority then the priority of the current job is checked. If the current job is an Urgent or an Emergency then nothing is done. If the current job is a Routine, the priority needs to increase to an Urgent to match the previous job.
• If there is a job found and it has an Emergency priority then the priority of the current job is checked. If the current job is an Emergency then nothing is done. If the current job is anything else, the priority needs to increase to an Emergency to match the previous job.
• To add another level of checking, an for notifcation to the advisor, a question is displayed informing the advisor that a priority change is required. If they continue, the priority will be upgraded accordingly.

This script will only check the priority of the first SOR in either the previous or current job. If multiple SORs are picked up in the same fault; for this to work, the scripting should have been amended to ensure all priorities in each Fault are the same.