You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!