How to capture closed by name in the notification that created on sc_req_item table?

Annie10
Tera Contributor

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:

Annie10_0-1702674637193.png

 

 

 

 

22 REPLIES 22

Annie10
Tera Contributor

@AshishKM 

Could you please provide steps on how I can access the screenshot you suggested below, so I can verify the "Closed by" column

Annie10_0-1703005807511.png

 

 

I wouldn't worry too much about not having the "closed by" column. Unless you did something very strange and deleted it, it is present. The bigger question is what Matthew asked above which is "in the record you are testing with, is that value populated?".

In the record you are testing with, click on the context menu (or right click on the gray header bar) and show the XML. Does it have a value in the "closed_by" field?

Screenshot 2023-12-19 at 10.33.38 AM.png

Screenshot 2023-12-19 at 10.34.25 AM.png

@Michael George 

Here is an example of a closed complete ritm:

Annie10_0-1703008856309.png

 

and here is the closed completed on request record.

Annie10_1-1703009086129.png

 

Thank you for continuing to help everyone!

Well that's the problem then. If nothing is going into that field, the email will never contain a value. Now it's a question of configuring the flow or whatever is driving these requests so that something does get populated. Perhaps your flow could update the request item record with the person that closed an associated catalog task or something?

@Annie10 : That's exactly what I guessed, as per my answer below. Business rule 'Set Closure Fields' updates the fields on RITM. Check in your instance to see if someone customized it or created something on the 'sc_req_item' table that's causing the issue.

sainathnekkanti_0-1703009815296.png

 
Please mark this as correct answer and helpful if it resolved, or mark this helpful if this help you to reach towards solution.
 
Regards,
Sainath N