Guidelines for Overriding Sort Specifications on Business Components

Siebel CRM overrides the sort specification on the business component for some visibility types to force the view to use an ORDER BY sort with the predefined user key. The All Mode Sort user property determines whether Siebel CRM overrides this sort specification. If it does do this override, then this user property determines the sort that Siebel CRM applies, if any, to the business component for the affected views.

If you set the Visibility Applet Type property of the view to one of the following values, then the All Mode Sort user property affects this view:

• All

• Catalog

• Group

• Manager

• Organization

• Sub-Organization

Note the following:

• If you set this user property to Personal or Sales Rep, then the All Mode Sort user property does not affect the view.

• If you configure the default sort order so that it sorts one of these views, then this configuration might display a large amount of data that Siebel CRM typically sorts only according to a user key.

• If you use All Mode Sort to override the default sort behavior, then it is recommended that you contact your database administrator to get guidance on how the database indexes the sort-by fields.

• It is recommended that you performance test the view and any reports that use the view.