Promote Document Version Notes to Document Notes

Promote Document Version Notes to Document Notes




  3. --The following script will promote document version notes
  4. --into document notes.  This is useful when a destination system
  5. --supports notes on documents but does not support notes on
  6. --specific document versions.
  7. --
  8. --If you are using this script, you should inform the client that 
  9. --Their version notes will no longer be attached to the version
  10. --as that is a limitation of the destination system.
  11. UPDATE
  12. __M_Common_Notes
  13. SET
  14. Final_Parent_Type = '__M_Documents_Digital_Files',
  15. Final_Parent_Id = Versions.Final_DocumentFile_Id
  16. FROM
  17. __M_Common_Notes Notes,
  18. __M_Documents_Digital_Files_Versions Versions
  19. WHERE 1=1
  20. AND Notes.Final_Parent_Type = '__M_Documents_Digital_Files_Versions'
  21. AND Notes.Final_Parent_Id = Versions.Id