Moving Documents into Matters that are Nested under Tasks

Moving Documents into Matters that are Nested under Tasks



  2.  --The following script moves documents that are nested under Tasks to be nested under Matters instead.
  3. UPDATE
  4. __M_Documents_Digital_Files
  5. SET 
  6. Final_Folder_RelativePath = '\Task Attachments\',
  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_Tasks Parents,
  12. __M_Tasks_Related_Entities Relationships
  13. WHERE 1=1
  14. AND Documents.Final_Parent_Type = '__M_Tasks'
  15. AND Documents.Final_Parent_Id = Parents.Id
  16. AND Parents.Id = Relationships.Final_TaskEntry_Id
  17. AND Relationships.Final_RelatedTo_Type = '__M_Matters'