Moving Documents into Matters that are Nested under Invoices

Moving Documents into Matters that are Nested under Invoices



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