We have three tables EMP, EMP_ROLES, ROLES. EMP_ROLES table is the bridge table and contains only the EMP_ID and its linked ROLE_ID's. On our page we have created two tabs through Show detail item, on one tab we can create new users and update existing ones. On the second tab we can search and select users through an ADF output text table and then come back to the first tab and edit them. On the first tab we have a form layout which displays the users details and a SelectManyShuttle to display the selected roles. Now, the application works fine when we open it initially, after searching for a user on the second tab we come back to the first tab and the users details and roles are updated.
However, once we have saved or deleted some roles for any user i.e. in the EMP_ROLES table, the role shuttle does not update when we navigate from the search tab to the modify tab. If we navigate through the users on the first tab the shuttle works fine, but only when we come back from the search page the shuttle does not get updated and keeps showing the roles of the previous user.
I am using JDev version 18.104.22.168.0.
Can anyone please provide me with any ideas on how to get this resolved?
Please let me know if any more information is required.
Thanks in advance!
sorry but this seems to be an implementation specific problem. Can you create a test case for us to look at? If so, please create it based on the Oracle HR schema and send it to my mail profile which you see when clicking on my name in this answer (see left)
Looks like shuttle component iterator is not getting refreshed or upadted with model when navigate between tabs.
can you try iterator refresh property?
or else execute the shuttle component iterator programmatically.
one quick question ,does it show updated roles if you access a page in new browser window ?
Thanks for the response and apologies for the delayed reply.
I am new to ADF development, as a matter of fact this is the first time I'm working on it. Could you please explain a bit further how I can set the iterator refresh property or execute it programmatically?
Yes the shuttle component does show updated roles and works as required when opened in a new browser.
I placed a button below the shuttle and created a particalTrigger of the shuttle to button id. However, the roles did not get updated even after clicking the button.
I have tried setting a partialTrigger of the shuttle to the save button as well, but to no avail.
Please let me know if I need to bind this button or any other such step which I may have missed.
Drop the Execute action of the VO (from DC palette) controlling your shuttle as a button to force VO's iterator refresh, also refer http://oracleadfhowto.blogspot.in/2012/03/calling-adf-action-binding.html.
PS: You may be interested in checking out ADF learning references http://oracleadfhowto.blogspot.in/2012/05/steps-to-learn-oracle-adf.html.
That was just a trouble shooting step to confirm if re-query solves your issue or not, and so was partial trigger suggestion. As mentioned earlier a test case would be useful for others to pin point the cause.