7 Replies Latest reply on Nov 25, 2013 4:23 PM by Kofi

    Use Drop-down list with auto-complete with Set and Redirect option

    1013715

      Hi all

       

      Can anyone has come across to implement a solution for the problem as below -

       

      In an Oracle APEX page we have a (Project) Dropdown select list makes typing difficult for the user. The Project field should be able to display <PROJECTID> : <LOCATION> where LOCATION would be like LOWADDRESS - HIGH ADDRESS STREETNAME. It should be returning PROJECT ID only.
             The challenge is to have an action triggered on selecting or typing and entering a project in this field - like Set and Redirect. The value of this field needs to get set upon entry, and we should be able to use it for further processing in the page fields before actually having to submit it. (like in case of a select field).   This trouble is what is marginalizing our ability to move the field to AUTOCOMPLETE.

             This is the SQL we have for the dropdown list -
             SELECT PROJECTID || ' : ' || HIGHADDRESS || ' - ' ||LOWADDRESS || ' ' || STREETNAME d, PROJECTID r from PROJECT where CODE LIKE :P571_CODE AND COMPLETIONDATE IS NULL ORDER BY PROJECTID

       

      Please let me know if any of you have a solution for this.

       

      Would really appreciate.

       

      Thanks.