Regarding Email Notification

sai9845 — Mon, 19 Aug 2024 10:46:06 GMT

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}

Re: Regarding Email Notification

Ankur Bawiskar — Mon, 19 Aug 2024 14:30:12 GMT

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

Re: Regarding Email Notification

sai9845 — Tue, 20 Aug 2024 06:29:06 GMT

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.

question Regarding Email Notification in Community Central forum

Regarding Email Notification

Re: Regarding Email Notification

Re: Regarding Email Notification