_o_ORDER SUBRECORDS BY

This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com

4D v20 R7


_o_ORDER SUBRECORDS BY ( subtable ; subfield {; > or <}{; subfield2 ; > or <2 ; ... ; subfieldN ; > or <N} )

Parameter	Type	Description
subtable	Subtable	Subtable by which to order the selected subrecords
subfield	Subfield	Subfield on which to order by for each level
> or <	Operator	Ordering direction for each level: > to order in ascending order or < to order in descending order

Compatibility note

Subtables are no longer supported starting with version 11 of 4D. A compatibility mechanism ensures the functioning of this command in converted databases; however, it is strongly recommended to replace any subtables with standard related tables.