Sort Order for Variable Catalogs

Learn about variable catalog sorting.

By default, the values of variable catalogs are displayed in alphabetical order (when selecting them in catalog fields). Depending on the query type and the defined criteria, the alphabetic sort order may impact the performance. In such cases Aurea recommends to sort by catalog value code.

Enter the following parameter in the settings.xml file to sort the catalog values by code:

...
<update.crm.core>
...
<CatalogSortType>ByCode</CatalogSortType>

In addition, variable catalogs can be sorted "manually" using the Aurea CRM win Maintenance module (see Editing Variable Catalogs in the CRM.core Administrator Guide). This sort order overrules the default sort order.