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
Imported Document Id
This is machine translated content
Login to Subscribe
Please login to set up your
For security reasons, your link to this document has expired. Please click on the attachment link to access this file.
The attachment that you are looking for no longer exists.
There has been an issue retrieving your attachment. Please try again.
Didn't find the article you were looking for? Try these resources.