I'm still having a problem with a column redirect in a report and would like help on the problem. We are Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
I'm using Session State Protection in my application and I need to add a checksum to the url. I can do this with APEX_UTIL.PREPARE_URL.
The problem I'm having is getting an image to appear on the report to allow me to move to another page.
SELECT CASE
WHEN CFS_AUTHORIZATION.IS_ACCT_SUPERVISOR_ACCESS = 'True'
OR CFS_AUTHORIZATION.IS_ADULT_SPECIAL_NEEDS_ACCESS = 'True'
THEN
NULL
WHEN CFS_GET_FUNCTIONS.IS_CASE_STATUS_CLOSED(:AI_CASE_ID) = 'Not Closed' THEN
'<a href ='
||APEX_UTIL.PREPARE_URL(' f?p=&APP_ID.:3011:&SESSION.::&DEBUG.:3011:AI_REFERRAL_ID:'||ID|| ' > ' )
||'<img src=#IMAGE_PREFIX#edit-white.gif border=0 alt=Edit>
||'</a>
ELSE NULL
END LINK,
ID,
CASE_ID,
REFERRED_FROM_ID,
REFERRED_TO_ID,
REMARKS,
CREATED_ON,
CREATED_BY
from #OWNER#.CFS_CASE_REFERRAL
WHERE CASE_ID = :AI_CASE_ID
ORDER BY CREATED_ON DESC
Has anybody come across this problem and knows how to allow the user to move to the LINK page?
Regards
Sue Brownrigg