This discussion is archived
5 Replies Latest reply: Apr 8, 2013 2:21 PM by Timo Hahn RSS

OrderBy Clause

911401 Newbie
Currently Being Moderated
I have a VO with Query statement:
SELECT ......
FROM URRSHIS
WHERE ...........
ORDER BY URRSHIS_ACTION_DATE DESC, URRSHIS_SCAT_CODE

when I try to get OrderBy clause by following code ,I get null:

oracle.adf.model.BindingContext bctx = oracle.adf.model.BindingContext.getCurrent();
oracle.binding.BindingContainer bindings = bctx.getCurrentBindingsEntry();
DCBindingContainer bindingImpl = (DCBindingContainer)bindings;
DCIteratorBinding iter = bindingImpl.findIteratorBinding("URRSHISIterator");
ViewObject vo = iter.getViewObject();
String O = (String) vo.getOrderByClause();

why? I am using Jdev 11.1.2

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points