Oracle apex prevent initial load

-- 1. Put a HIDDEN field P1_IS_LOADED in the region

-- 2. Requesting datas in region becomes:
SELECT /* your columns */
  FROM /* your tables */
WHERE 1 = 1 
  AND nvl(:P1_IS_LOADED, 'N') = 'Y'
   
-- 3. At page level:
>> Post-Rendering > After Regions > Computation > add one computation with: 
	Computation: Static Value: Y

Source: askmax.blog

Similar codes

0 vote209 views1 answer
Oracle flush Shared Pool
SQL
2 votes239 views1 answer
Datetrunc
SQL
0 vote232 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
11 votes204 views3 answers
How to get last row of table in sql
SQL
2 votes210 views1 answer
Oracle drop sequence if exists
SQL
0 vote251 views1 answer
Sqlite3 pragma foreign keys
SQL
1 vote295 views1 answer
Oracle see column type
SQL
11 votes227 views2 answers
Import sql file laravel cmd
SQL
0 vote192 views1 answer
Number(10 2) in sql means
SQL
1 vote267 views1 answer
Sql oracle update multiple rows
SQL