الأحد، 15 أغسطس 2021

How to change Region Serveer Side COndition on runtime in Oracle APEX

1: Make P6_REGION_ID

that will contain all Region available for your page 

use this code as source 

select 
PLUG_NAME,
ID
 from APEX_200200.wwv_flow_page_plugs
                    where FLOW_ID =:P6_FLOW_ID
                    and   PAGE_ID =:P6_STEP_ID

  and make process to update Region Server side condition 

 BEGIN

UPDATE APEX_200200.wwv_flow_page_plugs -- Region
SET PLUG_DISPLAY_CONDITION_TYPE = 'NOT_EXISTS' ,
    PLUG_DISPLAY_WHEN_CONDITION = 'SELECT 1 from dual where 1=2'
WHERE FLOW_ID = :P6_FLOW_ID -- APP ID
 and PAGE_ID = :P6_STEP_ID  -- PAGE ID
 and ID = :P6_REGION_ID -- REGION ID
end;

--
thanks

ليست هناك تعليقات:

إرسال تعليق

How to Solve Ords Issue : The request could not be mapped to any database.

 The request could not be mapped to any database.  Check the request URL is correct, and that URL to database mappings have been correctly c...