How to sort results from PVOs in Order Management Extensions
Summary:
We are using PVOs to retrieve data in Order Management Extensions, but we are unable to sort the results.
Content (please ensure you mask any confidential information):
We are following the guidelines as described here
A dummy case: Let 's say we want to retrieve all users from UserNoDetailPVO and sort the results by user name:
…
def PVO = context.getViewObject("oracle.apps.hcm.users.publicView.UserNoDetailPVO");
def vc = PVO.createViewCriteria();
def vcRow = vc.createViewCriteriaRow();
def rowSet = PVO.findByViewCriteria(vc, -1);
while (rowSet.hasNext()) {
def row = rowSet.next()
if (row) {
…. something
}
}
We are unable to find a way to sort the results. We've tried