Configuring sort in the PolicyCenter database

PolicyCenter handles the ordering of data as consistently as possible between database sorting and in-memory sorting. PolicyCenter derives the collation to use for sorting from the following:

  • The default localization code set in the configuration parameter DefaultApplicationLocale in config.xml.
  • The collation strength setting. This value is set in the language_languageCode.xml file for the language.

PolicyCenter uses these values along with the database type to look up the collation in collations.xml.

Note: PolicyCenter uses in-memory sorting in the application interface for various elements, such as drop-down lists and list views that do not result from queries. To perform in-memory sorting, PolicyCenter uses a language-specific Collator object that is modified with the collation strength setting for that language.