Forum Discussion
EV_Ajay
12 years agoLevel 6
How to remove Legal Hold Errors from DA Cases
-- Get the CaseID for the Colum “Errors” from Cases Tab.
Select * from tblCase where StatusID = 20
-- Check counts in tblLegalHoldSummaries
select * from tblLegalHoldSummaries where CaseID = 31
-- Update tblIntDiscoveredItems
update tblIntDiscoveredItems set LegalStatus = 420 where CaseId = 31 and LegalStatus = 425
-- Update the counts in tblLegalHoldSummaries via this SP
EXEC [usp_LegalItem_UpdateSummary] @CaseID = 31
-- Check counts in tblLegalHoldSummaries. CONFIRM NumHoldError = 0
select * from tblLegalHoldSummaries where CaseID = 31
--DONE