Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Refresh APEX_ITEM.TEXT Value when Interactive Report Page Changes

yetiSep 18 2012
I use an APEX_ITEM.TEXT column in an IR where the user can enter some number date.
to make this data persistent while paginating the ir, i use some DA . Via ajaxthis DA call an onDemandProcess to save the entered data in a collection.
works great; the input is stored in the collection.
To show the already entered data, the ir sql statement joins the collection.
select  APEX_ITEM.hidden(2,artikelnr)||
        APEX_ITEM.TEXT(1 
          ,COL_artikel.preis
          ,3
          ,3 
          ,'autocomplete="off" onfocus="javascript:f_set_last_val(this);" onchange="javascript:f_validate_integer(this);"'
          ,'INPUTBESTELLEN'
         ) Inputbestellen,
article.*
from article 
left outer join COL_artikel on COL_artikel.nummer = artikelnr
where col_artikel is a view for better access on the collection

Now the issue:
On the first Page i add some data, then i go head to page 2 and 3 of the ir. The collection is filled withe the entered data.
But when i navigate back to page 1 the entered data is not shown in the input field unless i relload the whole page . I guess because the query is not re-executed when paginating foreward/backward.

ist there any way to overcome this tiny small issue?

regards
peter
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 16 2012
Added on Sep 18 2012
0 comments
313 views