I have a VO with Query statement:
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
OK, I would say that this is a bug. I tested this under 220.127.116.11.0 and also got 'null' as result. It doesn't matter if the vo is based on a vo or not.
However, as long as you don't log a bug with support and it's not confirmed by support it not a bug.
As a workaround you can use the
String sql = vo.getQuery();
to get the whole sql statement. Then you can use normal string methods to extract the 'order by' clause.