Hi, in my IR I have a conditional link which works well, either shows 'none' when no invoices found, or redirects to page 205 otherwise.
case
when nvl(finv.inv_count,0) = 0 then 'none'
else '<a href="f?p='||:APP_ID||':205:'||:APP_SESSION || ':::::' || '">View Invoices</a>'
end as inv_max
My question is, how can I pass parameters to a page called in this link.
My current unconditional link column assigns 2 parameters from currently selected IR row to called page - 205:
P205_CLIENT_OID = #CLIENT_OID#
P205_CLIENT_NAME = #CLIENT_NAME#
Many thanks in advance, thanks. Jack.