Moving Documents into Matters that are Nested under Communications

Moving Documents into Matters that are Nested under Communications



  2. --The following script moves documents that are nested under Communications to be nested under Matters instead.
  3. UPDATE
  4. __M_Documents_Digital_Files
  5. SET 
  6. Final_Folder_RelativePath = '\Emails\',
  7. Final_Parent_Type = Relationships.Final_RelatedTo_Type,
  8. Final_Parent_Id = Relationships.Final_RelatedTo_Id
  9. FROM
  10. __M_Documents_Digital_Files Documents,
  11. __M_Communications Parents,
  12. __M_Communications_Related_Entities Relationships
  13. WHERE 1=1
  14. AND Documents.Final_Parent_Type = '__M_Communications'
  15. AND Documents.Final_Parent_Id = Parents.Id
  16. AND Parents.Id = Relationships.Final_Communication_Id
  17. AND Relationships.Final_RelatedTo_Type = '__M_Matters'