Create Contact Categories from Matter Participants

Create Contact Categories from Matter Participants



  2. --The following script will create Contact Categories from the roles
  3. --that Contacts are linked to on Matters and then assign the contacts to those categories.
  4. GO

  6. INSERT INTO __M_Contacts_Categories (
  7. Id, 
  8. Final_Subject
  9. )
  10. SELECT DISTINCT
  11. CONCAT('SYNTHESIZED --- ', Final_Participant_Role),
  12. Final_Participant_Role
  13. FROM
  14. __M_Matters_Participating_Entities
  15. WHERE 1=1
  16. AND Final_Participant_Type = '__M_Contacts'

  18. INSERT INTO __M_Contacts_Categories_Participating_Entities(
  19. Id,
  20. Final_ContactCategory_Id, 
  21. Final_Participant_Id, 
  22. Final_Participant_Type
  23. )
  24. SELECT DISTINCT
  25. CONCAT('SYNTHESIZED --- ', Final_Participant_Role, ' --- ', Final_Participant_Id),
  26. CONCAT('SYNTHESIZED --- ', Final_Participant_Role),
  27. Final_Participant_Id,
  28. Final_Participant_Type
  29. FROM
  30. __M_Matters_Participating_Entities
  31. WHERE 1=1
  32. AND Final_Participant_Type = '__M_Contacts'

  34. GO


    • Related Articles

    • Matter Participants: Data Cleanup

      Table Overview Matter Participants are contacts that are related to Matters. They exist in the table: __M_Matters_Participating_Entities They have three primary fields: Field Description Final_Matter_Id The Id of the Matter. Final_Participant_Type ...

    • Convert User-Select/Contact-Select Custom Fields => Participants

      Some systems do not support User-Select or Contact Select custom fields. The following query will transform User-Select fields into Matter Participants. This script can easily be adapted for Contact-Select fields. -- Transform Custom Fields on ...

    • Create a "Legacy Matter Number" Custom Field

      Some firms rely heavily on Matter Numbers to search for a specific matter. Sometimes when they migrate to a new system it can't replicate the automatic numbering system from their old system so they want to renumber all their matters to a new scheme ...

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

    • Create an "Employer" Contact from a Custom Field.

      In some systems, contacts do not have an Employer relation and only have a text field that represents the employer. This script will help when moving firms into platforms that allow an actual contact to be specified for the employer. --Create Company ...