4D v17.4

_o_ORDER SUBRECORDS BY

Home

4D Language Reference
- Subrecords
- - Get subrecord key
  - _o_ALL SUBRECORDS
  - _o_APPLY TO SUBSELECTION
  - _o_Before subselection
  - _o_CREATE SUBRECORD
  - _o_DELETE SUBRECORD
  - _o_End subselection
  - _o_FIRST SUBRECORD
  - _o_LAST SUBRECORD
  - _o_NEXT SUBRECORD
  - _o_ORDER SUBRECORDS BY
  - _o_PREVIOUS SUBRECORD
  - _o_QUERY SUBRECORDS
  - _o_Records in subselection

Home

4D v17.4

4D Language Reference

Subrecords

_o_ORDER SUBRECORDS BY


_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.

See also

_o_QUERY SUBRECORDS