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

baqar rizvi · ‎02-08-2018

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 · ‎02-09-2018

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

View solution in original post

Rajesh Mushke · ‎02-09-2018

Here what i have i have done in my PDI, but i was didn't recognize the wrong table.

Subject after preview:

Any ways you got the solution, so i'm happy

Thanks,
Rajashekhar Mushke
Rising star : 2022 - 2024
Community Leader -2018
Connect me on LinkedIn : Rajashekhar Mushke

Rajesh Mushke · ‎02-09-2018

Note: Remember one thing, next time if you are creating any RITM related notifications.

Please create notifications on RITM (sc_req_item) table

Thanks,
Rajashekhar Mushke
Rising star : 2022 - 2024
Community Leader -2018
Connect me on LinkedIn : Rajashekhar Mushke

Roberth Requena · ‎02-04-2021

Hi baqar,

Did you solve this problem from the sc_request table?