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