Paging oracle Apex without updating query

Asked

Viewed 8 times

0

Hello I’m with a problem, my company has a screen where we have a classic report which contains people’s permissions for screens and system functions, but we have a problem, we have a query that uses a parameter to bring only people with access or all people from the company, if it is marked to bring only people from the company, when we use paging, it repeats the query and it ends up creating a problem for us.

For example we have 2 pages, and the last person on the first page is FULANO and the first of the second is CICLANO, if I remove the permissions of FULANO and I go to the next page the first will not be CICLANO because as updated the query CICLANO went to the last of the first, and this causes difficulties to see who was touched or can not pass beaten, and I need to make sure that these page changes do not update always, only when I reopen the page.

inserir a descrição da imagem aqui

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.