i am trying to use this method
to sort the results .
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?