Sort Specification

You can specify a sort specification on one or more integration component fields of an integration component. For each field you want sort on, you must define the attributes listed in the following table. If both attributes are not specified, then the field is not considered as a sort field.

Attribute	Description
sortorder	Determines whether the sort order is ascending or descending. Valid values are ASC or DEC.
sortsequence	Determines the order in which the sort specification is applied. Valid values are integer numbers.

Example of Sort Specification

This example demonstrates using the QueryPage method with an ascending sort order.

Request

<SiebelMessage MessageType="Integration Object" IntObjectName="Account" 
IntObjectFormat="Siebel Hierarchical">
   <ListOfAccount>
      <Account>
         <Row_Id>2-1111</Row_Id>
         <ListOfContact pagesize="40" startrownum="0" recordcountneeded="true">
            <Contact>
               <FirstName sortorder="ASC" sortsequence="1"></FirstName>
            </Contact>
         </ListOfContact>
      </Account>
   </ListOfAccount>
</SiebelMessage>

Response

<SiebelMessage MessageType="Integration Object" IntObjectName="Account" 
IntObjectFormat="Siebel Hierarchical">
   <ListOfAccount lastpage="true">
      <Account>
         <Row_ID>2-1111</Row_ID>
         <ListOfContact recordcount="3" lastpage="true">
            <Contact>
               <FirstName>Alice</FirstName>
            </Contact>
            <Contact>
               <FirstName>Bill</FirstName> 
            </Contact>
            <Contact>
               <FirstName>Casey</FirstName>
            </Contact>
         </ListOfContact>
      </Account>
   </ListOfAccount>
</SiebelMessage>