ASCENDING Function (RecordRef)
Changes or checks the order in which a search through the table that is referred to by RecordRef will be performed.
Syntax
[IsAscending :=] RecordRef.ASCENDING([SetAscending])
Parameters
RecordRef
Type: RecordRef
SetAscending
Type: Boolean
Determines the order of the search.
If this parameter is true, it will search in ascending order. If this parameter is false, it will search in descending order. If you do not specify this parameter, it will check the search order.
Property Value/Return Value
Type: Boolean
Specifies the order in which a search will be performed.
Remarks
This function works just like the ASCENDING Function (Record).
Example 1
The following example opens table 18 (Customer) as a RecordRef variable that is named CustomerRecref. The SETVIEW Function (RecordRef) sets a filter that includes sorting the data in ascending order. The ASCENDING function then checks whether the sort order is ascending, stores the return value in the IsAscending variable and displays Yes in a message box. This example requires that you create the following variables and text constant in the C/AL Globals window.
| Variable name | DataType |
|---|---|
| CustomerRecref | RecordRef |
| IsAscending | Boolean |
| Text constant name | DataType | ENU value |
|---|---|---|
| Text000 | Text | Is the sort order ascending? %1 |
CustomerRecref.OPEN(18);
CustomerRecref.SETVIEW('SORTING(Name) ORDER(Ascending) WHERE(No.=CONST(10000..20000))');
IsAscending := CustomerRecref.ASCENDING;
MESSAGE(Text000, IsAscending);
Example 2
The following example opens table 18 (Customer) as a RecordRef variable that is named CustomerRecref. The SETVIEW Function (RecordRef) sets a filter that includes sorting the data in descending order. The ASCENDING function then checks whether the sort order is ascending, stores the return value in the IsAscending variable and displays No in a message box because the sort order is descending. The ASCENDING function changes the sort order to ascending by setting the SetAscending parameter to true. The ASCENDING function checks the sort order again. This time Yes is displayed.
CustomerRecref.OPEN(18);
CustomerRecref.SETVIEW('SORTING(Name) ORDER(Descending) WHERE(No.=CONST(10000..20000))');
IsAscending := CustomerRecref.ASCENDING;
MESSAGE(Text000, IsAscending);
IsAscending := CustomerRecref.ASCENDING(TRUE);
MESSAGE(Text000, IsAscending);