Cascading dynamic select list's dynamic action gets triggered when the list values changes ,not only when user select a value from the list

Question

I am developing an application on Oracle APEX 5.1.Here I have a dynamic select list whose value depends on a page item value on the same page. So I have added this page item in the: 'Cascading LOV Paret item' field of the select list and referred to this item in the pl/sql code of the select list. And I have defined an 'onChange' dynamic action' for the select list which submits the page.

The problem is: This dynamic action is getting executed whenever the dynamic select list gets refreshed by the change of cascading LOV parent item value. But I need the dynamic action to execute only when the user select a value in the list.

Please help me to find out where I am going wrong!! Thanks in advance.

After the the child LOV gets refreshed, its value should be null. Can you add a condition on the onChange dynamic action so it only does its thing if the child item is not null? — Jeffrey Kemp
@JeffreyKemp Thanks for your response. But I need the dynamic action to occur when the user select 'null value'(displayed as -Current-) from the select list too. The page content needs to be changed even for a null selection in the select list. — Madona

Zachary Wilson zwils0 Zachary Wilson zwils0 · Accepted Answer · 2018-05-23T17:41:22

Have you tried change the dynamic action to fire on select instead of on change?

According to the APEX documentation here. An onChange action fires when the LOV has been modified in some way whereas a select action fires when a user selects something in the field.

Alternatively another possible solution is in the select list properties. There is a setting called "Page Action on Selection" which can be used to submit the page when a value is selected.

Cascading dynamic select list's dynamic action gets triggered when the list values changes ,not only when user select a value from the list

1 Answers