How the Visibility Mode Affects a Sort Specification

Siebel CRM forces the sort that the All visibility mode uses to be on the primary key. The sort in Manager mode occurs on a column in the denormalized reporting relationship table. Siebel CRM can still sort records after the initial query. For better performance, you must configure Siebel CRM to sort records after it filters for a small record set.

You can use the All Mode Sort business component user property to force Siebel CRM to use a custom sort specification or to ignore all sort specifications. For more information, see Siebel Developer's Reference.