Configuring Query Key Order

You can configure TopLink to maintain collections in order by query key.

Table 37-8 summarizes which relational mappings support this option.

Table 37-8 Relational Mapping Support for Query Key Order

Mapping	Using TopLink Workbench	Using Java
Variable One-to-One Mapping
One-to-Many Mapping
Aggregate Collection Mapping

Using TopLink Workbench

To specify the order of a mapping's query keys, use this procedure:

1. Select the mapped attribute in the Navigator. Its properties appear in the Editor.

2. Click the Ordering tab. The Ordering tab appears.

   Figure 37-4 Ordering Tab

   
   

3. Complete the Ordering options on the tab.

Field	Description
Query Key	Specify the query key to order by. Click Add to add query keys to, or Remove to remove query keys from the ordering operation. Click Up or Down to change the sort order of selected query keys.
Order	Specify if TopLink orders the selected query key in Ascending or Descending (alphabetical) order.