Configuring Siebel Business Applications > Configuring Business Components, Links, and Business Objects > Customizing a Business Component >
Determining How a Business Component Sequences Records
Sequential numbering is not predefined in any system column in a predefined table in Siebel CRM. However, you can configure a sequence field in a child business component to determine how a business component sequences records. For more information, see How a Business Component Field Sequences Records. To determine how a business component sequences records
- Verify that the class of the child business component is CSSBCBase or a subclass of CSSBCBase.
If it is not, then contact Oracle Technical Services for assistance with this procedure. For more information, see Getting Help from Oracle.
- Verify that the business component to which you must add a sequence field is the child business component in a parent-child relationship.
This child is the numbered business component. Siebel CRM numbers child records beginning with 1 in each parent record.
- Add a child field to the numbered business component using values from the following table.
|
|
Name |
Enter text that indicates on which data Siebel CRM performs the sort, such as Line Number or Order. |
Column |
Enter a numeric extension column, such as ATTRIB_14. |
Type |
DTYPE_NUMBER |
- Add a child business component user prop to the numbered business component using values from the following table.
|
|
Name |
Sequence Field |
Value |
Enter the field name you defined in Step 3. |
- Create a business component using values from the following table.
|
|
Class |
CSSSequence |
table |
Enter the name of the base table of the numbered business component. |
Name |
Enter a name using the following format: name of the numbered business component.name of the sequence value field (Sequence)
|
- Set the Sort Spec of the business component you created in Step 5 to Sequence (DESCENDING).
- Add a child field to the sequence business component using values from the following table.
|
|
Name |
Sequence |
Column |
Enter the same value you entered for the column in Step 3. |
- Add a child field to the sequence business component.
This field is the foreign key field that establishes the parent-child relationship to the parent business component. Set the Column property to the same column as the corresponding field in the numbered business component.
- Create a link that establishes a parent-child relationship between the parent and sequence business components.
For more information, see About Links.
- Create a child business object component of the business object that uses the predefined link between the parent business component and the numbered business component. Use values from the following table.
|
|
Link |
Choose the link you defined in Step 9. |
BusinessComp |
Choose the sequence business component. |
- Display the sequence value field in applets that display records from the numbered business component.
- Compile and test your changes.
For more information, see Using Siebel Tools.
|