How to use

getOrderBy

method

in

org.camunda.bpm.engine.impl.db.ListQueryParameterObject

@Statement
public List<JobEntity> selectNextJobsToExecute(OPersistenceSession session, ListQueryParameterObject query) {
  Map<String, Object> params = (Map<String, Object>) query.getParameter();
  Date now=(Date) params.get("now");
  int maxResults=query.getMaxResults();
  String orderBy = query.getOrderBy();
  return queryList(session, "select from "+getSchemaClass()+
            " where retries > 0"
            + " and (duedate is null or duedate <= ?)"
            + " and (lockOwner is null or lockExpirationTime < ?)"
            + " and suspensionState = 1"
            + (Strings.isEmpty(orderBy)?" order by "+orderBy:"")
            + " LIMIT ?", now, now, maxResults);
}