This content has been marked as final. Show 2 replies
I have an Interactive Report with two apex_items:
select ETT_ID, APEX_ITEM.HIDDEN(1, ETT_ID) ETT_ID_Hide, APEX_ITEM.TEXT(2, Score), ...
In the text-item I want to fill in numbers and one button should upadate all rows.
I created a pl/sql process:
BEGIN FOR i in 1 .. APEX_APPLICATION.G_F02.COUNT LOOP UPDATE Table_A SET ETT_SCORE = to_number(APEX_APPLICATION.G_F02(i)) WHERE ETT_ID = APEX_APPLICATION.G_F01(i); END LOOP; END; END;
Works great if I do not hide the APEX_ITEM.HIDDEN item (means: show it in the Interactive Report as a Standard Report Column).
But if I hide this item, it will not work anymore.
Does anybody have a solution/workaround?
Or is it possible in the pl/sql process to access ETT_ID itself? something like this: APEX_APPLICATION.ColumneOne(i);