Select list returning URL redirect using custom SQL

Sending user to some url with trailing value

In some cases you want to send user to external or internal url with some value added with the link. You can do it in Oracle Application Express using select list returning URL redirect. In this example I will show a simple example to do this.

Create a page item and change the display as property to select list returning URL redirect. So basically it will redirect user to URL when select list item changed.

Create a custom LOV query for this select list. I have created this custom LOV sql query on demo_customers table

SELECT	 CUST_FIRST_NAME as display_value,
'http://www.url.com/test.aspx?id='¦¦customer_id as return_value
FROM	 "DEMO_CUSTOMERS";

The above query set display value with customer name and returning value with URL containing customer_id number.

This question has been answered in Oracle Application forum – Oracle Forum

Hope this helps