0 Replies Latest reply: Nov 3, 2013 1:12 AM by 950275 RSS

    How to enable FIND option in dynamic LOV

    950275


      Hello,

       

      I have created Dynamic LOV and it is working absolutely fine. Now I want to facilitate the user to search the LOV while selecting the LOV. Can any one help me out in finding the FIND/SEARCH option in dynamically created the LOV.

       

      Your kind support will be appreciated a lot in advance.

       

      I have used the following code to create dynamic LOV.

      DECLARE

            rg_Prosp     RecordGroup;

            rg_Pname    VARCHAR2(100)  := 'PROSPECT';

            plist_ID    Item      := Find_Item('ENQUIRY_INFORMATION.PROSPECTNAME');

            nDummy      NUMBER;

      BEGIN

         rg_Prosp := Find_Group(rg_Pname);

         IF NOT Id_Null(rg_Prosp) THEN

                  Delete_Group(rg_Prosp);

            END IF;

            rg_Prosp := Create_Group_From_Query(rg_Pname,'SELECT PROSPECT_NAME, to_char(PROSPECT_NO) FROM XXTEST.XXSFF_PROSPECT');

                  Clear_List(plist_ID);

            nDummy        := Populate_Group(rg_Prosp);

            Populate_List('ENQUIRY_INFORMATION.PROSPECTNAME',rg_Prosp);