To reproduce it in EmployeesView for departmentId I added LOV that also return ManagerId.
It work fine for Forms (TestForm) and for tables(TestTable), but not for af:query with bind variables:
I created 2 view criteria with departmentId and ManagerId, 1 with bind variables and 1 with no bind variables. And 2 pages 1 for each
TestQuery1 with af:query with bind variables
TestQuery with af:query with no bind variables
When trying to select department in TestQuery1 we get:
Caused by: java.lang.NullPointerException
at oracle.adfinternal.view.faces.model.binding.FacesCtrlSearchBinding$AdfCriterionValues.
at oracle.adfinternal.view.faces.model.binding.FacesCtrlSearchBinding$AdfAttributeCriterion.
at oracle.adfinternal.view.faces.model.binding.FacesCtrlSearchBinding$AdfConjunctionCriterion._loadCriterionList(FacesCtrlSearchBinding.java:2775)
at oracle.adfinternal.view.faces.model.binding.FacesCtrlSearchBinding$AdfConjunctionCriterion._loadCriterionList(FacesCtrlSearchBinding.java:2725)
at oracle.adfinternal.view.faces.model.binding.FacesCtrlSearchBinding$AdfConjunctionCriterion.getCriterionList(FacesCtrlSearchBinding.java:2633)
at sun.reflect.GeneratedMethodAccessor840.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
Yet TestQuery return correctly departmentId and ManagerId.
So I guess the workaround is not to use bind variables in view criteria.
Test Case
http://adfbugs.googlecode.com/files/LOVReturn.zip
I believe the multiple return values for an LOV do work in some build of 11g now.
ReplyDeleteBUT here's the paradox:
In the query panel's advanced mode, when you apply operator 'Not Equal To' to Department name, 'Equal To' (default operator specified in your view criteria) continues to get applied to DeptID
Fixed in Jdeveloper 11.1.1.2.0
ReplyDelete