working at apex.oracle.com
had a page with IR with query below, it is opening Normal page but can't open a Modal Dialog page, how it can be done, please help.
SELECT the_level, empno, ename, mgr,
case when the_level > 20 then
'<a href='||apex_page.get_url(p_page => '7', p_items => 'p7_empno', p_values => empno)||'>'||ename||'</a>'
else
ename
end edits
from (
select (level*20)-20 the_level,
empno,ename,mgr
from emp
connect by prior empno = mgr
start with mgr is null
)
in continuation of topic below:
IR: link column showing html text instead of Link (0 Bytes)regards
EDIT: i tried this code but not working:
'<a href='||APEX_UTIL.PREPARE_URL(p_url => 'f?p'||:APP_ID||':7:'||'&SESSION.'||'::::P7_EMPNO:'||EMPNO)||'>'||ENAME||'</a>'