Standard Siebel application behavior is to override the sort specification on views with certain visibility types to force the view to ORDER BY the standard user key. The All Mode Sort user property determines whether the Siebel application overrides the sort specification and, if so, determines the sort (if any) that is applied to the business component for the affected views. This user property affects views with visibility other than Personal or Sales Rep visibility, including Manager, All, Organization, Sub-Organization, Group, and Catalog views. NOTE: If you set up the default sort order so that it sorts on one of these views, be aware that this might reveal large quantities of data, which is typically sorted only by user keys.
When All Mode Sort is set to Normal, queries performed in workflows also use the business component sort specification, even when no visibility has been set. If you choose to override the default sort behavior using All Mode Sort, first consult your database administrator for guidance on how the sort-by fields are indexed. Also, conduct careful performance testing on the view itself and on reports run against the view. |
