QueryBuildDataSource.addOrderByField Method [AX 2012]

Finance and Operations/AX Developer Forum
1

i am trying to use this method

to sort the results .

for example

 QueryBuildDataSource qbds       = qr.query().addDataSource(tableNum(CustTable));

    qbds.addGroupByField(fieldnum(CustTable,Country));

is good.

Problem
------------
  i have a reference column in CustTable   refers to another table   lets say County
  and i County Table recid is in CustTable. 

i need to sort the results on actual value of CountyTable not on  the reference column inside CustTable ie.  County

----- answer could be add County Table as data source .  

without adding County Table to the query.

is that possible?
2

your not mentioned Descending or Ascending for sorting

queryBuildDataSource.addSortField(fieldNum(custTable,AccountNum),SortOrder::Descending); //Add sorting

i think its help full