I suspect this is because the resolved date is actually on a collection object, as you can have multiple resolutions to an incident, if it has been reopened. One thing you could do (if the resolution is the final action that happens on an incident and it isn't touched after that) would be use the "Last Update Date" attribute, as this is not a collection attribute and will appear in your export.
The other option would be to create a new date attribute on the incident object which you also update with the current date when the Resolve action is selected.
1 of 1 people found this helpful
The reason this displays at the bottom is, as stated by Paul, because Resolutions is a collection on Incident. In addition to Paul's ideas, there are two ways you could display this information:
- Base the query on the resolution object instead of the Incident object. Of course, this with throw multiple records for a single incident if there are multiple resolutions OR
- Create a calculated attribute on Incident to return the latest Resolution creation date
I can't remember if calculations were available in 7.3 or not, but if they are then this is the best solution.
Excellent, thanks for the info (both of you)!