1 Reply Latest reply on Jun 14, 2019 4:15 PM by InoL

    Help with managing a lot of LOV's

    4022212

      I am creating a form that will have over 200 LOV's.  They are all very simple and I will be adding/removing fields to the form and changing the lookup values as requirements change, which I expect to be frequently.  I am looking for a way to make this as painless as possible.

       

      My current plan is to have a table that contains all of the LOV's; this way when there are changes to lookups or new lookups to be added it will be relatively easy to make the changes.  Each lookup will be based on the field_name so, my plan is for each field with a LOV I would make it a select list and add a select statement querying the LOV table where current  field_name = LOV field_name.

       

      This is a very cumbersome approach.  Is there a way I could create a shared LOV that could scrutinize the current field name? 

       

      I am relatively new to APEX, any suggestions would be greatly appreciated.

       

      Jane

        • 1. Re: Help with managing a lot of LOV's
          InoL

          An LOV can be based on a "Function returning a query". As a simple example, this function can be:

           

          function lov (i_item)

          return varchar2

          is

          begin

            if i_item = ... then return 'select ....';

            elsif i_item = ... then return 'select ....';

            end if;

          end;

           

           

          Each item than has an LOV like this:

          lov('P1_ITEM1');

          lov('P1_ITEM2');

          etc.