Create Notes from Matter Descriptions

Create Notes from Matter Descriptions

Some platforms do not support matter descriptions.

The following will transform a matter description into a matter note.

  1. --Transform Matter Descriptions to Matter Notes
  2. INSERT INTO
  3.     __M_Common_Notes
  4.     (Id, Final_Parent_Id, Final_Parent_Type, Final_Subject, Final_Description)
  5. SELECT
  6.     CONCAT('TRANSFORM --- ', V1.Id),
  7.     V1.Id,
  8.     '__M_Matters',
  9.     V1.Final_Subject,
  10.     V1.Final_Description
  11. FROM
    __M_Matters V1
  12. WHERE 1=1
  13.     AND V1.Final_Description != ''