03 February 2011

Descending order in Form Task 5

To show the record in Descending order Task 5
IN the form-> DS-> init()
1 write the following code:
this.query().dataSourceNo(1).addSortField(fieldnum(DatasourceTable , field), SortOrder::Descending);
Example:
this.query().dataSourceNo(1).addSortField(fieldnum(CustTable,AccountNum) ,SortOrder::Descending);

2 In DS-> ExecuteQuery()
while select CustTable order by AccountNum desc
{
}

1 comment:

Give me the commetns and solutions

Merge Dimensions (MainAccountId and LedgerDimensions) defaultDimension in D365 F&O and X++

 public DimensionDynamicAccount getLedgerDimension(container _conData, TransDate _transDate = today()) {     int                            ...