0 Replies Latest reply: Jul 26, 2013 4:01 AM by pt_user1 RSS

    Query for create manual tabular form using apex collection using item textfield with autocomplete

    pt_user1

      can we create a manual tabular form inside item textfield with autocomplete ?

      how it is possible?

      with Apex_item API used for this item.

      i used this code for creat  cascading select list

       

      select seq_id,

      APEX_ITEM.SELECT_LIST_FROM_QUERY(

              p_idx                       =>   1,

              p_value                     =>   c001,

              p_query                     =>   'SELECT C001 D

           , C002 R

        FROM APEX_COLLECTIONS

      WHERE COLLECTION_NAME = ''col1''',

              p_attributes                =>   'style="width:150px" onchange="f__name(this,parseInt(#ROWNUM#));"',

              p_show_null                 =>   'Yes',

              p_null_value                =>   null,

              p_null_text                 =>   '- Select name -',

              p_item_id                   =>   'f01_'|| LPAD (ROWNUM, 4, '0'),

              p_item_label                =>   'Label for f01_#ROWNUM#',

              p_show_extra                =>   'NO') name,

      APEX_ITEM.SELECT_LIST_FROM_QUERY(

              p_idx                       =>   2,

              p_value                     =>   c002,

              p_query              =>   ' SELECT null d, null r FROM dual WHERE 1 = 2

      ',

              p_attributes                =>   'style="width:150px"',

              p_show_null                 =>   'Yes',

              p_null_value                =>   null,

              p_null_text                 =>   '- Select name -',

              p_item_id                   =>   'f02_'|| LPAD (ROWNUM, 4, '0'),

              p_item_label                =>   'Label for f02_#ROWNUM#',

              p_show_extra                =>   'NO')name2,

       

      from apex_collections

      where

      collection_name = 'COLLECTION1'

      It is fine .

      but i want item in tabular form  textfield with autocomplete and remove select list. my requirement is using textfield with autocomplete select a employee name and second item textfield with autocomplete display dependent perticular employee related multiple task.

      how it is created.i have no idea related textfield with autocomplete.Please help me....