I would use the Status History for that. You can pull the date that it was set to the different statuses and do a comparison between the dates of the two statuses.
Thanks, Shawn Pierson Remedy Developer | Southern Union From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Vianna Vianna Sent: Wednesday, July 28, 2010 3:36 PM To: [email protected] Subject: PreviousStatus field in HPD:Help Desk form ** Hello Just wondering if anybody else had used the "Previous Status" field in Incident to pull data? I have been asked to pull a report showing all Incidents that were set to status "Closed" without being set to status "Resolved" first. I thought that querying for All tickets in current status: Closed and PreviousStatus not equal to: 4 (resolved), would do the trick. It hasn't worked. Any suggestions? (Using ITSM 7.5) Thank you Vianna _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
