How to track modification date when a request status is moved to "On hold" ?
QUESTION:
How can I track the modification of Request status changed to "On hold" ?
I need to retrieve the date when requests were suspended, to show this information in portlets/reports.
ANSWER:
You need to create a custom data source and you can use this SQL request
select * from RequestHistory
where Status = 'HOL'
order by RequestId
The field Createdon provides the time creation of the entry in the history.