Guest User

Untitled

a guest
Apr 20th, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.08 KB | None | 0 0
  1. List<Case> caseList = new List<Case>();
  2. List<CaseHistory> CaseHistoryList = new List<CaseHistory>();
  3. Map<Id, Date> caseIdMap = new Map<Id, Date>();
  4. //Querying Case Records here
  5. for(Case cs: [SELECT Id, Status FROM Case]){
  6. caseList.add(cs);
  7. }
  8. if(caseList.size() > 0){
  9. //Querying history for Case
  10. CaseHistoryList = [SELECT newValue, createdDate, OldValue, CaseId FROM CaseHistory WHERE CaseID IN :caseList AND Field = 'Status'];
  11. System.debug('CaseHistoryList: '+CaseHistoryList);
  12. if(CaseHistoryList.size() > 0){
  13. for(CaseHistory csHis : CaseHistoryList){
  14. if(csHis.newValue == 'New'){
  15. caseIdMap.put(csHis.caseId, csHis.CreatedDate.date());
  16. System.debug('CaseHistory Map: '+caseIdMap);
  17. }
  18. }
  19. }
  20. if(caseIdMap.size() > 0){
  21. for(Case updateCase : [SELECT Id, ClosedDate__c, NewStatusDate__c, EscalateDate__c, InProgressDate, OnHoldDate__c Status FROM Case WHERE ID in :caseIdMap.keyset()]){
  22. //Need to populate date field for each status.
  23. }
  24. }
  25. }
  26.  
  27. Map<ID, Case> caseMap = new Map<ID, Case>();
  28. Map<Id, Date> caseIdMap = new Map<Id, Date>();
  29.  
  30. for(Case cs: [SELECT Id, Status FROM Case])
  31. {
  32. caseMap.put(cs.ID, cs);
  33. }
  34.  
  35. if(caseMap.size() > 0)
  36. {
  37. for(CaseHistory caseHistory : [SELECT newValue, createdDate, OldValue, CaseId FROM CaseHistory WHERE CaseID IN : caseMap.keySet() AND Field = 'Status'])
  38. {
  39. if(caseHistory.newValue == 'New' && caseMap.containsKey(caseHistory.CaseID))
  40. {
  41. /*caseMap.get(caseHistoryMap.get(caseHistory.CaseID).ClosedDate__c = caseHistory.???
  42. caseMap.get(caseHistoryMap.get(caseHistory.CaseID).NewStatusDate__c = .
  43. caseMap.get(caseHistoryMap.get(caseHistory.CaseID).EscalateDate__c
  44. caseMap.get(caseHistoryMap.get(caseHistory.CaseID).InProgressDate
  45. caseMap.get(caseHistoryMap.get(caseHistory.CaseID).OnHoldDate__c
  46. caseMap.get(caseHistoryMap.get(caseHistory.CaseID).Status*/
  47. }
  48. }
  49. }
Add Comment
Please, Sign In to add comment