Set a Default Folder for Documents

Set a Default Folder for Documents



  3. --The following script will place all documents that are directly in a root folder inside of a subfolder.
  4. UPDATE
  5. __M_Documents_Digital_Files
  6. SET
  7. --Change this to be whatever subfolder we want it to be.
  8. Final_FolderName = '\Unfiled\'
  9. WHERE
  10. Final_FolderName = '\'


    • Related Articles

    • Synthesize Missing Matters for Documents

      Some systems only allow documents to be linked to matters. These scripts will allow you to restore data into these systems. When Matters No Longer Exist The following script with synthesize matters for document related to matters that no longer ...

    • Prioritizing documents based on different criteria

      The following scripts provide examples that can be modified to apply different priorities to documents. Prioritize Large/Small Documents If you are restoring into a system that has different action limits at different times, this can help you ...

    • Prioritize documents for Active (Open) Matters

      --Prioritize documents for Active (Open) Matters UPDATE __M_Documents_Digital_Files SET Batch_Group = -100 FROM __M_Documents_Digital_Files V1, __M_Matters V2 WHERE 1=1 AND V1.Final_Parent_Id = V2.Id AND V1.Final_Parent_Type = '__M_Matters' AND ...

    • Document Register: Moving digital documents into a Document Register Matter

      /* This script is a template that will help you move library documents (document register / safe custody records) into a general 'Document Register' matter. You should consider this a TEMPLATE that you may want to tweak and adjust for each client's ...

    • Synthesize: Missing Document Categories for Documents

      The following script will synthesize document categories for invalid Final_DocumentCategory_Id values on documents. -- Some documents are linked to categories that no longer exist. -- Create dummy document categories based on these values. INSERT ...