Hello all,
Application Express 4.2.1.00.08
I have an Interactive Report with Apex Items.
select b.*
,APEX_ITEM.TEXTAREA(1,p.FIELD_COMMENT,1,60)||APEX_ITEM.HIDDEN(5,m.compare_id)||APEX_ITEM.HIDDEN(3,b.DIFFS) as Commnt
,APEX_ITEM.SELECT_LIST_FROM_LOV
(
p_idx => 2,
p_value => p.SELECT_LIST_FIELD,
p_lov => 'APEX_ITEM',
p_show_null => 'YES',
p_null_value => NULL,
p_null_text => '-Select-',
p_item_id => 'f02_' || m.compare_id
) Verification
from (
select a.*
......
Whenever the user submits the text area or select list, it populates the table TEST_TAB
The rest of the code is an unpivot statement that gives me two columns of data to compare.
I have a page validation where if the text area (apex_application.g_f01(i)) has a value, the select list (g_f02) must have a value. Everything works fine except when the validation fails, the text area on that row gets reset back to the original value. The user should be able to see the comment they put in so they don't have to re-enter it. I have searched the forums and I believe the only way for the data to be temporarily saved is through APEX_COLLECTIONS. However, I am a little confused on how to set up an apex collection for what I want. My goal is to store apex_application.g_f01(i) in a collection and repopulate the text area with what the user had before the submit button was pressed.
Any help is much appreciated!
Thanks,
Brett