taskflowViewable vs userInRole

This is a short post about how one can use ADF security to hide/show links to the taskflows depending upon the user role. We can either use userInRole or taskflowViewable EL expressions on the visible or rendered property of the af:command link. But, choosing one over the other has repercussions on maintainability and also causes replication of security configuration in the source code   The preferred way, i think is to use taskflowViewable expression as it avoids the aforementioned problems. This can be seen by the sample usage of the...

Read More

ADF ViewCriteria performance impact

There is a caveat i wanted to highlight with respect to view criteria that has a performance impact. if you use a view criteria it is applied after the query block as shown below. This example is based on the scott schema. select * from (select empno from emp)QRSLT where empno=2; Now the query execution plan will be the same to the output of the following query where you filter the records inside rather than using a viewcriteria. select empno from emp where empno=:bvar;The plan is shown below :- PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------- Plan...

Read More