Installing a service pack changes the sort method for code table entries

The sort order of several codes tables including Title, Constituency and Address type changed from user defined to alpha sort after we installed Service Pack 5.

Download and install the latest service pack, which contains all fixes from previous service packs. If you are running an older version, download and install the latest version and then the service pack. 

There are some code tables that will be reset to alpha order as a side-effect of the fix for this problem.  The sort orders will need to be reset as a post-upgrade task when going to version 4.0 SP7 or higher.  

The following steps are suggested.  Please note, the files referenced in these steps are attached to this Knowledgebase article in file "97353.zip": 

1. Run 97353CustomSortedTables.SQL and retrieve results
2. Review ImpactedCodeTablesSetToAlpha.txt 
3. Any code tables that appear in both files will require manual update after upgrade

  97353.zip

Steps to Duplicate

1.  Select code tables from the Administration functional area
2.  Select Address type
3.  Click edit sort method
4.  Note the sort method
5.  Install service pack 5 for CRM 4.0
6.  Repeat steps 1-4
7.  Note the new value

Environment

 Blackbaud CRM
 4.0

Was this article helpful?