Higher priority jobs
Last updated
Was this helpful?
Last updated
Was this helpful?
This example demonstrates how a Startup script uses an SQL Databox to check for previous jobs raised within the past 5 minutes by the same user, on the same property and writes the details into a script Databox.
Later, a Custom Script checks the details of any previous job found.
This is the Startup Script which executes Databox Read i.e. Keyfax.MultiOrderCheck where the results are written to the Databox MultipleJobs.Details:
This query will looks for any orders submitted in the last 5 minutes, for the same operator and Asset ID. The query runs against the Keyfax table syOrder:
In the WHERE clause, you'll see references to other Databoxes in {curly} braces, including Keyfax.DateChecks below (subtracting 5 minutes from the current time could easily have been done using SQL in the above query but it is split out into a Databox just for demonstration purposes):
The Databox MultipleJobs.Details contains a number of Expressions, two of which are Conditional and are checking for values representing the Priority (you will see their use in the Result script below).
If a job is found and it has an Urgent priority then the priority of the current job is checked. If the current job is an Urgent or Emergency priority 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, as 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.
