Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Modify contents of Approval Notification

Highlighted
Westcope
Acclaimed Contributor

Modify contents of Approval Notification

Hello,

Does anyone know how you can modify the content of the email notification
messages(outbound mail) in SP14.
1) the control of assignment notification message
2) the control of approval notification message
In that servicepack it is not yet possible to edit the template through the email settings.

Thanks!!! Anoek Thoolen
6 REPLIES
Tim Schmitt_4
Frequent Visitor

Re: Modify contents of Approval Notification

I think the ability to control email messages for approvals and assignments was added in SP17.

http://openview.hp.com/ecare/getsupportdoc?docid=ITSM006111

In SP19 or 20, the checkbox that says "Send me email when items are assigned to me or my workgroup" is split into two separate options so that the customer can choose between no emails, only when assigned to workgroup, only when assigned to person, or both. It's something our customers have asked for since we rolled out Service Desk.
Tim Schmitt_4
Frequent Visitor

Re: Modify contents of Approval Notification

As to the how of these messages are control, you would go into the system panel, under the general options, and finally choose email.

In the email system, there is tab that shows all of the email templates used by the system.
Westcope
Acclaimed Contributor

Re: Modify contents of Approval Notification

Thanks for your reply Tim.
But the whole point is that using the system panel is not possible for servicepacks before SP17.

That's why we want to know where we can find it directly in the database.It's not rep_email_templates, because that's also just since SP17.

regards, Anoek
Tim Schmitt_4
Frequent Visitor

Re: Modify contents of Approval Notification

Ah, yes, I do see that I misread your question. Sorry about that.
Martijn Stam
Acclaimed Contributor

Re: Modify contents of Approval Notification

In the administrators' console you must go to:
Presentation(dutch: presentatie)/Localized text(dutch: Tekst)/Label text(dutch: taal veldnamen)

Here you will find the Localizable item Keys:
EmailApprovalSubject (the subject)
EmailApprovalToVote (explaining text)
EmailApprovalURL (this is the URL you want)

The value of the last key should be:
http://%1/sd-sp45/Approval.jsp?v%2=%3

Extra information (use the %1, not the values!):
%1 = application server
%2 = itemtype
%3 = objectnr
Martijn Stam
Acclaimed Contributor

Re: Modify contents of Approval Notification

And if you want to change the values directly in the database you should query the following:

SELECT *
FROM REP_LABELS
WHERE UPPER(LBL_JAVA_CONSTANTS) LIKE 'EMAILAPPROVAL%'

With these LBL_OID's you can find the right records in REP_LABELS_LOCALE (FK is LAL_LBL_OID).
//Add this to "OnDomLoad" event