Moving Documents into Matters that are Nested under Calendar Entries

Moving Documents into Matters that are Nested under Calendar Entries




  3. --The following script moves documents that are nested under Calendar Entries to be nested under Matters instead.
  4. UPDATE
  5. __M_Documents_Digital_Files
  6. SET 
  7. Final_Folder_RelativePath = '\Calendar Attachments\',
  8. Final_Parent_Type = Relationships.Final_RelatedTo_Type,
  9. Final_Parent_Id = Relationships.Final_RelatedTo_Id
  10. FROM
  11. __M_Documents_Digital_Files Documents,
  12. __M_CalendarEntries Parents,
  13. __M_CalendarEntries_Related_Entities Relationships
  14. WHERE 1=1
  15. AND Documents.Final_Parent_Type = '__M_CalendarEntries'
  16. AND Documents.Final_Parent_Id = Parents.Id
  17. AND Parents.Id = Relationships.Final_CalendarEntry_Id
  18. AND Relationships.Final_RelatedTo_Type = '__M_Matters'