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.
Which version of Apex do you use? If you're not averse to using plugins, there's the Super LOV plugin from Skillbuilders
It can also return values to other columns and it sounds like that's what you're looking for.