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