Difference between revisions of "Target and Priority Days in a Message"

From Keyfax Wiki
Jump to: navigation, search
(Created page with "**Example The following message is displaying the priority and the target days of a repair. File:242.png **Setup")
 
 
Line 1: Line 1:
**Example
 
 
 
The following message is displaying the priority and the target days of a repair.  
 
The following message is displaying the priority and the target days of a repair.  
  
 
[[File:242.png]]
 
[[File:242.png]]
  
**Setup
+
This can be set up using the results system script. Create an export databox to pick up the priority with the following details.
 +
 
 +
[[File:243.png]]
 +
 
 +
Create an SQL databox to pick up the target days with the following details.
 +
 
 +
[[File:244.png]]
 +
 
 +
The SQL Query should read
 +
 
 +
SELECT p.targetresponsedays FROM ssuniqueaction u
 +
JOIN sgscripttype s ON u.scripttypeid=s.scripttypeid
 +
JOIN sspriority p ON u.actionid=p.priorityid
 +
WHERE u.actiontype = 202
 +
AND s.scripttypecode = 'RD'
 +
AND u.actioncode = ‘{Export.Priority}’
 +
 
 +
Create another SQL databox to pick up the short description of the priority with the following details.
 +
 
 +
[[File:245.png]]
 +
 
 +
SELECT ShortDescription
 +
FROM ssUniqueAction
 +
WHERE ActionCode =’{Priority amend.Priority}’
 +
 
 +
You can then create a message with the two SQL databoxes you just created in. It should look something like this when you've finished.
 +
 
 +
[[File:246.png]]
 +
 
 +
Place this message into your results system script and this message will display once you've diagnosed the repair, before the submission screen.

Latest revision as of 10:00, 8 April 2019

The following message is displaying the priority and the target days of a repair.

242.png

This can be set up using the results system script. Create an export databox to pick up the priority with the following details.

243.png

Create an SQL databox to pick up the target days with the following details.

244.png

The SQL Query should read

SELECT p.targetresponsedays FROM ssuniqueaction u
JOIN sgscripttype s ON u.scripttypeid=s.scripttypeid
JOIN sspriority p ON u.actionid=p.priorityid
WHERE u.actiontype = 202 
AND s.scripttypecode = 'RD'
AND u.actioncode = ‘{Export.Priority}’

Create another SQL databox to pick up the short description of the priority with the following details.

245.png

SELECT ShortDescription
FROM ssUniqueAction
WHERE ActionCode =’{Priority amend.Priority}’

You can then create a message with the two SQL databoxes you just created in. It should look something like this when you've finished.

246.png

Place this message into your results system script and this message will display once you've diagnosed the repair, before the submission screen.