Hide/show page item base on specific values from selected list in apex

Question

I'm using Oracle Apex 19.1 version and i'm very new to apex. I m working on a product form. Where under product type item, it consist of total 5 products display in a selection list. When user select product a or b or d from the list, then accessories page item and plan page item will show in the form. When user select product c or e under product type, accessories page item and plan page item will be hide from the form.

I tried to achieve by setting dynamic action, 'event' set to change, 'selection type' set to items, 'item(s)' set to product_type

under client-side condition, 'Item' set to item=value, 'item' set to product_type, 'value' set to a,b,d. I realise value condition does not accept more than one value. Is there a way to over come this?

Answer 1

There are a number of declarative variations when it comes to testing some condition.

Where the values of item/expression 1 are respectively

• P1_ITEM
• A:B:C

I would try use one of these first over using a PL/SQL expression, because performance can be an issue depending on how prevalent these conditions become.

Some conditions simply need some nested/compound expression - I prefer the simple PL/SQL expession. If the expression evaluates true, then you'll see the component.

:P1_VALUE in ('a', 'b', 'd') and sec.check('blah') = 'Y'

Answer 2

I prefer functions that return Boolean (instead of "item = value" condition type).

In your case, that would be

return :P1_PRODUCT_TYPE in ('a', 'b', 'd');

used in accessories and plan page items' "Server side condition".

As of Select List item, change its "Page action on selection" to "Redirect and set value".