Condition based oracle apex column URL (Report Page)

Please find the below code for your reference and modify it.

select (case when order_status =’COMPLETED’ then
‘<a title=”Click here to generate the report” class=”t-Button t-Button–simple t-Button–small t-Button–hot t-Button–stretch” href=”‘||
apex_page.get_url(
p_page        => 12,
p_clear_cache => 12,
p_items       => ‘P12_ORDER_ID,P12_STATUS’,
p_values      => ORDER_ID||’,’||STATUS)||'”>GENERATE REPORT</a>’
else
NULL
end)  “REPORT”
from order
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s