Hello
Initially I wanted to enable drag&drop in a widget-generated tree which is not working using the API and no samples found.
So I tried to find a less but still user-friendly work-around by creating a select list which the selected node in the tree can be moved to. The source of the select list is a SQL statement. When the user clicks an element in the tree the following happens:
The unique ID of the selected tree element is filled into a hidden field (page item)
A refresh is done on the select list in order to show the nodes to which the selected tree element can be moved.
Here comes the problem: the value of the hidden page item (used in the SQL of the select list) will be ignored! So the list looks the same after refreshing it. In between I found out that it works only if I submit the page after setting the hidden page item. So I assume the SQL does not use the value of the page item rather than the session value of the page item. There is imho no reason to be forced to do a submit in order the source SQL is able to see/use the page item.
Why this is probably a bug: If I add a PL/SQL call after filling up the hidden page item, the value of the page item will be sent (as parameter) to the DB, no problem here. Why does it not work on refreshing a select list?
If anyone knows why this is not working or there is a workaround in order to simply refresh the select list with no complete page submit I'm glad to hear.