Prioritize documents for Active (Open) Matters

Prioritize documents for Active (Open) Matters


  2. --Prioritize documents for Active (Open) Matters
  3. UPDATE
  4. __M_Documents_Digital_Files
  5. SET
  6. Batch_Group = -100
  7. FROM
  8. __M_Documents_Digital_Files V1,
  9. __M_Matters V2
  10. WHERE 1=1
  11. AND V1.Final_Parent_Id = V2.Id
  12. AND V1.Final_Parent_Type = '__M_Matters'
  13. AND V2.Final_Status = 'Active'

    • Related Articles

    • 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 ...

    • 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 ...

    • Moving Documents into Matters that are Nested under Calendar Entries

      --The following script moves documents that are nested under Calendar Entries to be nested under Matters instead. UPDATE __M_Documents_Digital_Files SET Final_Folder_RelativePath = '\Calendar Attachments\', Final_Parent_Type = ...

    • Moving Documents into Matters that are Nested under Communications

      --The following script moves documents that are nested under Communications to be nested under Matters instead. UPDATE __M_Documents_Digital_Files SET Final_Folder_RelativePath = '\Emails\', Final_Parent_Type = Relationships.Final_RelatedTo_Type, ...

    • Moving Documents into Matters that are Nested under Tasks

      --The following script moves documents that are nested under Tasks to be nested under Matters instead. UPDATE __M_Documents_Digital_Files SET Final_Folder_RelativePath = '\Task Attachments\', Final_Parent_Type = Relationships.Final_RelatedTo_Type, ...