Matters: Prepending Client Names to Matters

Matters: Prepending Client Names to Matters

The following script will prepend Client Names to Matter Names.  For Example:

  1. Divorce 2016

would become

  1. John Smith --- Divorce 2016

 

Here is the relevant script:

  1. --Prepend all matter descriptions with the client name.
  2. UPDATE
  3.     __M_Matters
  4. SET
  5.     Final_Description = CONCAT(V2.Final_FullName, ' --- ', V1.Final_Description)
  6. FROM
  7.     __M_Matters V1,
  8.     __M_Contacts V2
  9. WHERE 1=1
  10.     AND V1.Final_ClientContact_Id = V2.Id

    • Related Articles

    • Matters: Trimming Client Numbers from Matter Numbers

      The following script will peel off client numbers from matter numbers. For example, if a matter has a ReferenceCode like: ABC-0001 After the script runs, it will have a reference code of: 0001 Scenario 1: There are Client Reference Codes In some ...

    • Synthesize Missing Client Contacts for Matters

      This script below will create dummy contacts where the Matter is assigned to a contact that no longer exists. --Some of the Matters are linked to contacts that no longer exist. --This will create dummy contacts from the missing links. INSERT INTO ...

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

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

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