Regarding Email Notification

[sai9845]

I need to create an email notification where the catalog item varaiables has to be populated in the email.

They are not getting populated as expexted.

Here is my script:

Dear ${approver},

${sysapproval} is requesting your approval for the following Service Request.

Request Item:${sysapproval.cat_item}
Priority:${sysapproval.priority}
Requested For:${sysapproval.request.requested_for}
Requested By:${sysapproval.opened_by}

Employee Information: 

Employee Name:${variables.requested_by}

Employee Phone number:${variables.phone}

Employee Email:${variables.emailid}

Employee Location:${variables.location}

Order Information:

Wärtsilä accdom account (Wärtsilä login)?:${variables.newaccount || variables.existing || variables.change_role || variables.additional_access || variables.close_account}

Wärtsilä role:${variables.selectrole}

Wärtsilä email acces needed?:${variables.email_access}

Additional Information:${variables.additional_information}

EDW PDM Data Access Request: 

User receiving EWD Access:${variables.user_receiving}

Wärtsilä cost center:${variables.cost_center}

Reason for access:${variables.reason}

Group Selection:${variables.email_access}

Teamcenter:

Are you an existing teamcenter user?:${variables.existing_user}

Teamcenter access needed?:${variables.access_needed}

Teamcenter Groups:${variables.email_access}

Citrix 3D VDI (NX/TC users in India):${variables.citrix}

Wärtsilä Cost Center (only needed when requesting Citrix 3D VDI):${variables.costcenter}

Wärtsilä user that you are workimg for:${variables.user}

Click below links to approve directly from this mail:
${mail_script:request_approverinfo_cyient}

${mailto:mailto.approval}
${mailto:mailto.rejection}
${mailto:mailto.approver.info}

Note: If failed to approve the request in 5 days, the request will be cancelled automatically.

Click below links to view requests from portal:
${mail_script:approval_take_me_to_myapprovals}

[Ankur Bawiskar]

@sai9845 

email notification is on which table?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[sai9845]

Hello Ankur,

It is on sysapproval_approver table.

And for account information we have multiple options (check box) and based on user selection it has to appear in email.

Same as we have multiple option (check box) for Group Selection and Team center groups.