Hi,
I've a text field item. I'm using regular expression to validate text field input. When input starts with 2, then through dynamic action, even fires up and need to update select list of values on another select list item. This is done through SQL statement at the moment. An example of SQL statement is select SCENARIO as display_value, SCENARIO as return_value from TB_NBN_ROLLBACK_REF_SCENARIO WHERE ENABLED ='Y' and check_sales_order_start_with_2 = 'Y' order by 1. How can I update the select list of values? This will be all done through dynamic action when expression is true.
Appreciate your reply.