Hello,
I think I am missing something really obvious...
My page has 2 regions:
Region 1 is a PL/SQL (Anonymous Block) region that displays a series of icons that, when clicked, set the value of page item P5_TREE_ROOT. ('f?p='||:app_id||':5:'||:app_session||'::::P5_TREE_ROOT:'||id)
Region 2 is a Tree Region, whose ROOT value depends on whatever the user clicked on in Region 1. My tree region includes checkboxes (apex_item.checkbox) that a user can select to add items to a collection:
select "ID" id,
"ID_PARENT" pid,
libelle||decode(nvl(IND_ES_CALCULE,0),0,'','
<img src="#WORKSPACE_IMAGES#calcul.PNG" alt="Calculé">') name,
null link,
decode(nvl(ind_can_select,0),0,'',apex_item.checkbox(1,nom_bd,null,:P5_COLLECTION,':')) a1,
null a2
from "#OWNER#"."LIBELLES",
(select c001 from apex_collections where collection_name='CRITERES') b
where nom_bd=c001(+)
order by id
After a user has made selections, he/she cicks on a button to submit the page and add the selected items to the collection. The user can then click on another category in Region 1 (changing the P5_TREE_ROOT), and make additional selections in the new tree.
I would like to do away with button clicking to submit page. I would like to be able to simply click on the item in Region 1, and have the 2 actions occur simultaneously: submit the page (thus updating the collection), AND reset the value of P5_TREE_ROOT. At the moment, the redirect happens, but the page does not get submitted before the redirect.
Any help is much appreciated! I am sure there is an easy solution...
Regards,
Michelle