We are setting up/refining our Service Desk queue we use for Purchase Orders. One of the big hurdles is the approvers want it to be 100% hands off. So getting them to set "who" the approver is won't happen.

So I am tasked with automating this based on an email reply.

So here is what happens. We have a group of five approvers in the company. I setup a mailto email footer that allows them to click and populate an email @status = Approved or Rejected. Once that happens it closes the ticket with the correct status. Now, I would like when the ticket is closed, whomever said "Approved" or "Rejected" would be set at the approver field.

How can I accomplish this via a SQL script?

0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity


You should be able to create a rule that detects for approval change. When the approval is changed update the ticket so that the user ID making the change is set to the approver ID. Do you have experience with MySQL?

Answered 04/10/2015 by: chucksteel
Red Belt

  • My knowledge of MySQL is very limited, but I have been doing some reading on it.
Please log in to comment