Skip to main content
Planview Customer Success Center

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.