Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Div
idRelatedTopics

 

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

...

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


  • Span
    stylecolor: #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
    stylecolor: #000000;
    Select one or more fields to sort by. You can also use Ctrl-Click to select multiple fields.


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


  • Span
    stylecolor: #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
    stylecolor: #000000;
    To remove a field from the Sort On panel, select it and click the Move to Left button .


  • Span
    stylecolor: #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
      stylecolor: #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
      stylecolor: #000000;
      On the canvas of the Ad Hoc View panel, right-click a column header and select Use for Sorting from the context menu.

 

 

...

idRelatedTopics

...