For example, if you have page items for Car Make and Model, Model would identify Car Make as the Cascading LOV Parent Item so that whenever Car Make is changed, the LOV for Model would be refreshed. (Copied from documentation :P)
So, the query in Car Model LOV is defined as
select car_model d, car_model r from car_models where car_make=:CAR_MAKE
And in the page, I define a page item CAR_MAKE and use it as the "Cascading LOV Parent Item(s)". So far so good.
I want to use this LOV in another pages. The problem is, APEX disallow me to create CAR_MAKE in another page, saying that "Item name is already used by another application or page item."
Besides creating the same LOV for each page (only using different bind variable name), is there any solution?
I thought of using a dynamic action set copy the Car Make to an Application Item, and reference the Application Item in the LOV. Is it guaranteed that the dynamic action complete before the LOV is refreshed?
Application Express 4.2.0.00.27
Oracle 11g XE
Please check this link:
where Steven Feuerstein share his views on
If the names of the parent item only differ in page number like in your example you could use:
select car_model d, car_model r from car_models where car_make=v('P'||:app_page_id||'_CAR_MAKE')
Beware do that you have to add the parent item to Cascading LOV Parent Item(s) because apex builder will not recognise it.
This way you don't have to change the standard LOV when it is used on a new page.