Content Comparison

In the Ad Hoc Editor, you can sort the rows of a table by any field, using a number of different methods.

...

• Span
  style color: #000000;
  Click the Sorting icon .The Sort window appears. If the table is already sorted, the window shows the fields that are used.

  
  
  

• Span
  style color: #000000;
  To add a field to sort on, double-click the field in the Available Fields panel. The Available Fields panel now lists only fields that are not already in the Sort On panel.

  
  
  

• Span
  style color: #000000;
  Select one or more fields to sort by. You can also use Ctrl-Click to select multiple fields.

  
  
  

• Span
  style color: #000000;
  Click the Move to Right button to add the selected field to the Sort On panel.

  
  
  

• Span
  style color: #000000;
  To arrange the sorting precedence of the fields, select each field in the Sort window and click one of the following buttons:

  
  
  

  Move to Top	Move to Bottom	Move Up	Move Down
  Image Modified	Image Modified	Image Modified	Image Modified

  
  
  

• Span
  style color: #000000;
  To remove a field from the Sort On panel, select it and click the Move to Left button .

  
  
  

• Span
  style color: #000000;
  Click the OK button. The table updates to display the rows sorted by the selected fields. You can also sort a table using the following methods:

  
  
  

  • Span
    style color: #000000;
    In the Fields section of the Domain Selection panel, right-click a field and select Use for Sorting from the context menu. In this case, the table is sorted by a field that isn't in the table; you may want to note the sorting fields in the title.

    
    
    

  • Span
    style color: #000000;
    On the canvas of the Ad Hoc View panel, right-click a column header and select Use for Sorting from the context menu.