Forum Stats

  • 3,782,041 Users
  • 2,254,585 Discussions
  • 7,879,899 Comments

Discussions

Select List Based on another Select List

mmmelanie
mmmelanie Member Posts: 12
edited Sep 27, 2016 11:44AM in APEX Discussions

I'm fairly new to developing with Oracle Apex 5 and using PL/SQL.

I've been trying to add a cascading LOV to my application so when the select list item of Review Focus is changed, it will change the child Review sub-focus LOV based on that selection. I've tried a mix of dynamic actions and shared components but nothing seems to work.

This is my current attempt where this code is inputted in the PL/SQL function returning a query section. I have the cascading parent LOV set to the Review Focus item. I have not activated any processes or dynamic actions.

CASE upper(:P4_REVIEW_FOCUS)

    WHEN 'WILDLIFE' THEN :P4_REVIEW_SUBF := 'marine birds';

    WHEN 'CLIMATE' THEN :P4_REVIEW_SUBF := 'meterorology';

    ELSE :P4_REVIEW_SUBF := null;

END CASE;

I will then try to add more assignments to the child LOV assignment once I get it fixed!

Tagged:
mmmelanie

Best Answer

  • joejetta
    joejetta Member Posts: 29 Blue Ribbon
    edited Sep 27, 2016 11:13AM Accepted Answer

    Looking at the screen shots you sent I would suggest that you create a dynamic action on that will fire when P4_REVIEW_FOCUS is changed.  In your true action run the PL\SQL statement your are trying to use in the P4_REVIEW_SUBF List of values section to set the its value.

    mmmelanie

Answers

This discussion has been closed.