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


    • Related Articles

    • Promoting Document Versions into Documents

      --The following playbook is a TEMPLATE that you can use to promote all document versions into actual documents. --When a document has a category, append the folder with the document category ID. UPDATE __M_Documents_Digital_Files SET --Prepend the ...

    • Linearize Notes

      Some systems support note comments(notes-on-notes). On systems like this, you might see notes organized as follows: |-Matter ABC.001 +-Note 1 (2021-01-01) +-Note 2 (2021-01-02) +-Note 2A (2021-01-04) +-Note 2B (2021-01-05) +-Note 2C (2021-01-06) ...

    • Split Big Notes

      Some destinations have a max character count for notes. The script below will split notes that exceed that length into multiple notes. The subject of the note will be {original subject} (Part X of Y) and the description will be the first X number of ...

    • Create Notes from Matter Descriptions

      Some platforms do not support matter descriptions. The following will transform a matter description into a matter note. --Transform Matter Descriptions to Matter Notes INSERT INTO __M_Common_Notes (Id, Final_Parent_Id, Final_Parent_Type, ...

    • Notes: Add Creator Information to the Body

      The script below will append the text 'Created By: {firstName lastName}', 'Created on behalf of: {firstName lastName}', and 'Updated by: {firstName lastName}' to the end of the note description in cases where the user's Email address was changed on ...