How to know the status of the Case? How to know Case Resolved date and Re-Activated date in CRM 2011?

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
We can able to get Open, Cancel and Resolved status of the case easily but to know the case is first 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.
Resolved Case

Re-Opened Case

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s