AnsweredAssumed Answered

Custom Report Query - Add Name

Question asked by Jason Shepard on Jan 25, 2018
Latest reply on Feb 2, 2018 by Jason Shepard

I was asked to come up with a way to add a unique identifier to manual fulfillment emails and found to ${jobUserData_ChangeRequestItem.ItemId} in another thread. This looks like it will work great. Now I'm working on a report to be able to show this information as well to be able to turn over to audit who can then search the ticketing system.

 

Here is where I am with the report :

 

(Select ACTIVITY_INSTANCE_ID, VALUE_NAME,  CHANGE_DATA_DESCRIPTION, VALUE_APP_ID, AVAILABLE_DATE From CHANGE_REQUEST_ACTIVITY )

 

I'd like to add the users name similar to the way it is displayed when you look at the request in the system but unsure on how to do this.

 

Thanks

Outcomes