(1) There are no out of box abilities to resort tables or multi-rowed data classes. The following instructions are intended as a workaround for being able to sort/re-order table values, such as if records are desired to be alphabetized or otherwise appear differently than they do. This can be applied to tables for primary record values, or to multi-rowed data classes such as Cost Items, etc. While this process may work, it is not recommended to use this workaround, as issues may occur due to how the data was originally present in the table, which has now been changed. Because of this, Symantec Technical Support is unable to assist the user in implementing or troubleshooting this workaround.
(2) Before trying this workaround, it is recommended to test this thoroughly on a development server before trying it then on a production server. Also, the entire database should be backed up before trying it on a production server. If issues later occur, these can be restored.
(3) It is expected that the user is proficient with SQL and understands the following instructions. If not, it is recommended to discuss this with their database administrator (DBA) to help implement and troubleshoot it.
There are records that are desired to be sorted, such as alphabetically. There doesn't appear to be any way to do this in the user interface. Is there some way that this can be achieved nevertheless?
Generally, yes. Tables can often be sorted in SQL to change their sort order. The following example demonstrates how to do this for a custom data class, which is a multi-rowed data class.
Note: The ability to have out of box sorting abilities for multi-rowed data classes has been submitted as a feature enhancement request to the developers. This may or may not be added to a future version of CMDB Solution.