Delete unused Practice Areas

--Delete any practice areas that are not used
UPDATE
    __M_Matters_PracticeAreas
SET
    Final_Status = 'Deleted'
WHERE 1=1
    AND Id NOT IN(
        SELECT
            Final_PracticeArea_Id
        FROM
            __M_Matters
        WHERE
            Final_Status != 'Deleted'
    )

• Related Articles

• Synthesize Missing Practice Areas

  The following SQL script will create practice areas where they do not exist in the Matters table. --Synthesize missing practice areas from Matters INSERT INTO __M_Matters_PracticeAreas( Id, Final_Subject ) SELECT DISTINCT Final_PracticeArea_Id, ...

• Convert a Custom Field into a Practice Area

  --The system we are coming from does not have practice areas --however, the client has created a picklist custom field that mimics this. --We are going to convert this custom field into a practice area. --First, populate the practice areas table with ...

• Audit Scripts: General Audit

  After completing a backup there are a number of things that are good to review prior to restoring into the destination system. The script below reviews several of the data points that should be looked at prior to restoring. This script is not ...

• Moving Documents into Matters that are Nested under Other Entries

  Some systems allow documents to be nested under virtually any other kind of record. This can be challenging when moving documents into systems that have a limited number of parent types. --The following script creates a "MISC DOCUMENTS" matter --And ...

• Other: Creating Unique Display Numbers

  The following script will create unique Final_ReferenceCode for all Contacts. It can be easily modified to apply to other record types. Please note that the Final_ReferenceCode that are generated are based on the data in the database. If you are ...