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
Sharing this in case anyone else can use it. I created the following query:
(Select DISTINCT a.CHANGE_REQUEST_ID, a.CHANGE_DATA_DESCRIPTION, a.VALUE_APP_ID, a.AVAILABLE_DATE, b.AFFECTED_USER_ID, c.first_name, c.last_name, d.name
From CHANGE_REQUEST_ACTIVITY a
JOIN CHANGE_REQUEST_DETAIL b
ON a.CHANGE_REQUEST_ID = b.CHANGE_REQUEST_ID
JOIN USERS c
ON b.AFFECTED_USER_ID = c.ID
Join Application d
On a.value_app_id = d.id
ORDER BY a.CHANGE_REQUEST_ID DESC)