How to know the Status of the Case? How to know Case Resolved date and Re-Activated date in CRM 2011?
First I have a open case and I did resolve it. After some days, due to some reasons I have Re-Opened the same Case. Now the re-opened case status will be Active.
Here comes the question, how can we know that the case is resolved first and later it is re-opened
Here is the solution for it.
When the case is Resolved, CRM 2011 creates a activity(Case Resolution) under Closed Activities entity.
If the Activity status is Completed then the Case is Resolved.
If the Activity status is Cancelled then the Case is Resolved and Re-Opened.
By getting the Closed activity of the case, we can know the case status and even know the when was the case resolved i.e Createdon date of the CaseResolution activity and for Re-Opened date, ModifiedOn date of the CaseResolution activity.