PeopleTools Sorts

Many different components of PeopleTools sort character data, most of which rely on the database system to perform sorting by using a SQL ORDER BY clause. However, PeopleTools does perform some sorting in memory.

See PeopleTools In-Memory Sorts.

Other parts of PeopleTools support only a binary sort for logistical or performance reasons. The following table indicates each of the common areas of PeopleTools that presents sorted lists of data to the user and the mechanism that each uses to perform the sort:

Functional Area	Sorting Engine
Component search dialog boxes.	Database-level SQL ORDER BY sort.
Scroll buffers.	Database-level SQL ORDER BY sort.
SQL operations in PeopleSoft Query, PS/n Vision, and SQR.	Database-level SQL ORDER BY sort.
SQL functions that are called from PeopleCode (SQL Objects, ExecSQL) containing BETWEEN, <, >, MIN, MAX, and so on.	Database-level SQL ORDER BY sort.
PeopleCode ScrollSelect( ) / ScrollSelectNew( ), RowScrollSelect( ), and RollScrollSelectNew( ) functions.	Database-level SQL ORDER BY sort.
Column-specific re-sorts in PeopleSoft Pure Internet Architecture (by clicking on a column heading).	PeopleTools in-memory sort.
PeopleCode SortScroll( ).	PeopleTools in-memory sort.
Drop-down list boxes of translate values.	PeopleTools in-memory sort.
PeopleCode binary comparison functions ( <, >, =).	Binary sort.
%BINARYSORT meta-SQL functions.	Binary sort.
Greater than and less than COBOL operations.	Binary sort.
Greater than and less than comparisons in SQR.	Binary sort.