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 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 ...
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 ...
Create a "Legacy Originating Attorney" field (from __M_Matters_Participating_Entities)
Most destination systems will only let you set the Originating Attorney and Responsible Attorney to an active user. This is why user mapping is used to map inactive users from the legacy system to an active user in the new system. But the firm may ...
Matters: Prepending Client Names to Matters
The following script will prepend Client Names to Matter Names. For Example: Divorce 2016 would become John Smith --- Divorce 2016 Here is the relevant script: --Prepend all matter descriptions with the client name. UPDATE __M_Matters SET ...