How to bring Requested Item Number in Subject on Notification Created on sc_request table?

[baqar rizvi]

Hello Guys,

I have a requirement where I need to add RITM number in the Email Notification Subject which is sent when a Service Request is placed in ServiceNow.

In the email body, I already have RITM number with the help of an email notification script where I have glided sc_req_item table and fetched the number of current record but this mail script doesn't work in SUBJECT.

Any help will be highly appreciated.

Thanks in Advance.

[Jotiram Yadav · Accepted solution]

Why don't you write this email notification on "sc_req_item" table. By doing that you can get both Request Number and Requested Item Number in subject.

It will not affect the email notification body content. Only thing is you may need to do some dot walking if you want to pull request fields.

Hope it helps.

Kind Regards,

Jotiram

Hit like /helpful / answered as applicable.

Kind Regards,

Jotiram

[baqar rizvi]

This seems to work.Thanks jotiram

[Rajesh Mushke]

then your subject will be like this:

Your ${request.number} / ${number} has been registered

Try again and let me know.

[Goutham sai]

Hi Rajesh,

If we write the notification on " sc_req " table then we're unable to select ${request.number}   but, as Jotiram Yadav said if we write the same notificaton on " Sc_req_item " table then we can able to select the ${request.number}.

Thanks,

Satish

Please mark your question as answered if it resolves your issue.

Please Hit ✅Correct, ��Helpful, or ��Like depending on the impact of the response

[Rajesh Mushke]

Hey Satish,

Thanks for correcting me, totally i was thinking about sc_req_item table.