4D Doc Center : PV SORT MANY

Home

4D View v14

PV SORT MANY


PV SORT MANY ( area ; left ; top ; right ; bottom ; direction ; keys ; order )

Parameter	Type	Description
area	Longint	4D View area
left	Longint	Left column number
top	Longint	Top row number
right	Longint	Right column number
bottom	Longint	Bottom row number
direction	Integer	0 = Row; 1 = Column
keys	Array	Column(s) or row(s) containing the values to sort
order	Array	Sort directions: 0 = Ascending; 1 = Descending

Description

The PV SORT MANY command is similar to PV SORT ONE but with multi-sort. You must pass columns or rows serving as sort criteria in key and the order (ascending or descending) in which the sorts will be executed in order.

The sort is executed in the cell selection delimited by left, top, right, and bottom.

direction indicates if the sort should arrange rows or columns:

If you pass 0, you arrange rows depending on the values of the row keys.
If you pass 1, you arrange columns depending on the values of the column keys.

Example

Sort a cell selection (5 columns x 9 rows) in relation to the second column as the first ascending criteria and in the third column as the second descending criteria.

 ARRAY LONGINT($Keys;2) `Column(s) or row(s) containing values to sort

 ARRAY INTEGER($Orders;2) `0=Ascending / 1=Descending

 

  `Initialization

 $Keys{1}:=3 `The 2nd column of the selection serves as 1st sort criteria

 $Keys{2}:=4 `The 3rd column of the selection serves as the 2nd sort criteria

 $Orders{1}:=0 `Ascending sort for the rows of the 2nd column of the selection

 $Orders{2}:=1 `Descending sort for the rows of the 3rd column of the selection

 

 PV SORT MANY(Area;2;2;6;10;1;$Keys;$Orders)