Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dynamic action - show/hide region based on LOV which returns ID

TomeoDec 4 2011 — edited Dec 4 2011
Hi folks,

this should be simple, so someone who works with dynamic actions.

I have a LOV which is based on below query:
select OBJECT_ID, KOD 
  from x_data x;

retuns:
   ID          KOD
----------------------------
    492961 BMW
    492964 VOLVO
    492960 MERCEDES
    492963 VOLKSWAGEN
    492959 SKODA
Item :P200_KOD is based on LOV which displays KOD and returns ID.

On my page I have also 1 region called TEST_REGION.

I would like to set up a dynamic action shich will SHOW/HIDE a TEST_REGION based on selected value in item :P200_KOD (LOV). Region should be showed if displayed (KOD) value of selected ID starts with 'V%'
By other words, if below query returns any record, then SHOW, else HIDE:
   select *
    from x_data x
  where x.kod like 'V%'
     and x.object_id = :P200_KOD;
How should I define a triggering condition for dynamic action, for item :P200_KOD?

Thanks,
Tomas
This post has been answered by jariola on Dec 4 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 1 2012
Added on Dec 4 2011
3 comments
195 views