Skip to main content
Planview Customer Success Center

What table contains the time stamps for request creation/closure?

QUESTION:

How to create a report that shows not only dates but time stamps of when requests are created and closed? There seems to be only dates in the report designer data collections. Which database table contains the time stamp information? If it's not an existing Data Collection, then can you tell the table that contains this information?


*ANSWER:

Created on date and time is available in the Request.CreatedOn field.

Closed on date and time can be calculated from RequestHistory.CreatedOn field using the following logic:

Max(rh.CreatedOn) FROM RequestHistory rh (nolock) inner join RequestStatus rs (nolock) on rh.Status = rs.Code WHERE rh.Status = 'clo' AND rh.Trace like '% I' + rs.Description + 'I1I%' GROUP BY rh.RequestId)