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