How to capture closed by name in the notification that created on sc_req_item table?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2023 01:11 PM
Hello,
I have been struggling to capture the 'Closed By' name in the notification when an RITM is closed complete. Can you please provide suggestions?
I'm using "${sys_closed_by", but it is returning empty.
Here is the example:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2023 09:56 AM
You can open RITM table defination, there you can see details about this closed_by field but that not matter here , we should check where we are setting this closed_by value when RITM is closed somewhere in workflow or flow designer. For some RITM this field has data/value , so need to check which process/logic is setting it.
Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2023 10:05 AM
@Annie10 : I just tried creating a sample notification as per below, and it worked for me.
Even after this similar configuration, if it did not work out, please check if the "Closed By" column of the RITM has value in it or if your notification is getting triggered first and then the "Closed By" is getting updated on RITM by comparing the timestamps from the email logs and audit history of the RITM.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2023 10:23 AM
Try using "updated_by".
Hopes that help.