Difference between revisions of "Target and Priority Days in a Message"
From Keyfax Wiki
(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: | ||
− | |||
− | |||
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]] | ||
− | + | 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.
This can be set up using the results system script. Create an export databox to pick up the priority with the following details.
Create an SQL databox to pick up the target days with the following details.
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.
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.
Place this message into your results system script and this message will display once you've diagnosed the repair, before the submission screen.