This discussion is archived
0 Replies Latest reply: Nov 2, 2013 11:12 PM by 950275 RSS

How to enable FIND option in dynamic LOV

950275 Newbie
Currently Being Moderated


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);

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points