View source for Target and Priority Days in a Message

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

[[File: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.

[[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.