Hey guys, good evening.
I'm building a page that have several regions, like this:
And this last region called HiSTÓRICO, is a just log, but should have a lot of rows for the entire page, so I decided to paginate, 5 row per view, but when I click on next I receive this:
I've tried a lot of things, since using a dynamic action to when this classic report update I fire a javascript that run an apex.region('historico').refresh(), but the data just gone and the report just return empty, until run a apex.submit() just to load entire screen, but before the update the mensage shows and this bothers me a lot. Any of you know how to solve this?
I'll let the query here, and reference from fields and I'm using Apex 24.1.5:
select ID_HISTORICO,
MENSAGEM,
dbms_lob.getlength(UPLOAD_ARTIGO) as UPLOAD_ARTIGO,
ID_ARTIGO,
TO_CHAR(DATA_REGISTRO, 'DD/MM/YYYY HH24:MI:SS') AS DATA_FORMATADA,
ADMINISTRADOR,
CODIGO
from DAE_HISTORICO_GESTAO_ARTIGO
where :P81_ID_ARTIGO = :P81_ID_GESTAO
order by DATA_FORMATADA desc
