I am building a tree where some of the leaves of the tree take a URL from a SQL query and use that as a link out to an external website.
Imagine that you have added a column to the EMP table called FAVORITE_SITE. Now you want a report that shows the organization tree with each employee's favorite website:
select case when connect_by_isleaf = 1 then 0
when level = 1 then 1
else -1
end as status,
level,
title,
null as icon,
value,
null as tooltip,
link
from
(SELECT ENAME||' '||FAVORITE_SITE TITLE, EMPNO VALUE, MGR, apex_util.prepare_url(FAVORITE_SITE) LINK FROM "#OWNER#"."EMP")
start with "MGR" is null
connect by prior VALUE = MGR
order siblings by TITLE
This works, but the link replaces the current page with the linked page, instead of opening in a new window or tab. Is there a way to manipulate the report to include target="_blank" without resorting to jquery or some other non-Apex solution? If not, this would be a nice new feature!
Thanks,
dmFoster
PS - I tried to change my display name so it is not a number, but the Profile screen did not offer me this option for some reason...