Bookshelf Home | Contents | Index | PDF |
Configuring Siebel Business Applications > About Business Components, Fields, Joins, and Links > About Business Components > How a Business Component Sorts RecordsA sort specification is a property of a business component that imposes a sort order on the records that Siebel CRM returns to an applet that references this business component. For example, the Sort Specification property of the predefined Account business component includes the following value: This value configures Siebel CRM to do the following:
A sort specification includes the following qualities:
For more information, see the following topics:
How Siebel CRM Sorts a Multi-Value FieldIf Siebel CRM references a multi-value field in a sort specification, then it does the following sort:
For more information, see About the Multi-Value Field. How Siebel CRM Sorts a Check Box FieldIf a sort specification references a check box field, then Siebel CRM sorts the following values: If a sort specification references a check box field, and if you define the sort in descending order, then Siebel CRM returns the records in the following order: How the Visibility Mode Affects a Sort SpecificationSiebel 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. |
Configuring Siebel Business Applications | Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |