[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 633
  • Last Modified:

MS CRM 4.0: Deleting multuple case resolutions

We use the service case function in CRM.  As you're probably aware, whena case is 'Resolved, CRM creates a 'Case Resolution' activity which contains the text resolution and the date the case was resolved.

In some instances, we have cases that get reactivated because they were either closed in error, or they were closed because we thought the issue was resolved but turns out it wasn't.  When a case is re-resolved later, CRM creates a second Case Resolution activity against the same case.  This makes reporting very difficult because now there are two resolution dates in the system.

Do anyone know of a way to have a workflow that automatically deletes all case resolutions but the most recent one?  This would help with cleaning up our reporting.
0
I_play_with_DNA
Asked:
I_play_with_DNA
  • 2
  • 2
1 Solution
 
Chinmay PatelEnterprise ArchitectCommented:
Hi I_play_with_DNA,
From functionality perspective, you should not delete the activities.
And as long as the solution is considered, for reporting you can modify your SQL to sort result set by date and select the top record only.
Regards,
Chinmay

0
 
I_play_with_DNAAuthor Commented:
We are not using SQL for reporting, therefore I need to delete the activities.
0
 
I_play_with_DNAAuthor Commented:
I should clarify....
We are using a third party tool for reporting (because CRM's built-in reporting capability is pathetic).  Functionally, there is no reason for us to keep the old resolutions; they contain no useful data and we would rather they be cleaned up.
0
 
Chinmay PatelEnterprise ArchitectCommented:
How about writing a cleanup application which deletes all resolutions except the latest one?
0
 
rakeshAgarwalCommented:
You have to  write sdk code  as suggested by chinmay to do this

0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now