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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.