Question Some reports that show the closed date show the date incorrectly. Since the incident can continue to be modified even after the incident is closed, the date shown on the report is the date last modified. How can the report be modified to show the date the incident was actually closed?
Answer To get the exact date that incident was last closed, use the action field of the incident:
select number, max(version), modified_on from dbo.workitem where status_lookup_id = 600 and action = 'Closed' order by number
Rate this Article
This is machine translated content
Login to Subscribe
Please login to set up your subscription.
Didn't find the article you were looking for? Try these resources.