Sorting

You can sort a block of slots on the document on any column, in either ascending order or descending order. Text slots are sorted alphabetically, number slots in numerical order of their value and dates in date order.

1. Mark the block.

Note that you need to mark all the columns containing slots to be sorted. If you mark only a few fields (columns), only those will be sorted. Usually, the best way to ensure that enough columns are marked is to mark all columns by dragging Select down the row borders.

2. Give the Sort command

Menu Command Ctrl-sequence Key
Blocks Sort BSO

3. When the dialogue box appears, type in the column or columns you want to be sorted. PipeDream supplies the column containing the caret as a default.

By default, the sort will be in ascending order. To reverse this, click Select on the Ascending order option to turn it off. You can set this option for each column you type in.

If you do not type in a column reference, the sort will take place on the column containing the caret. Note that part of or all of the column must be within the marked block.

Sorting on Several Columns

You can sort records on up to five columns. The sort takes place in the order in which you enter the columns in the Sort dialogue box. The order of the sort can be set individually for each column.

Sorting Slot References

Slot references referring to slots which move during the sort are automatically updated during a sort.

Sorting Multi-Row Records

To sort multi-row records, you must have the Multi-row records option in the Sort dialogue box turned on. The blank slots between the multi-row records ensure that when you sort the records on column A, all the rows in the record will be kept together.

For information on See
Sorting multi-row records Database Use