Hi,
I am working with Oracle APEX 5.0.0.
On a given page, I have a query-tree report that have this code:
with boom as
(
select NULL klg_kla_id_ouder, nKla_id_stamouder klg_kla_id_kind, 0 niveau, 0 rij, 0 isblad
from dual
union
select klg_kla_id_ouder, klg_kla_id_kind, level niveau, rownum rij, connect_by_isleaf isblad
from klg_klant_groep klg
start with klg_kla_id_ouder = pkg_klant.ZoekStamOuder(pKLA_ID)
connect by prior klg_kla_id_kind = klg_kla_id_ouder
)
select
case
when isblad = 1 then 0
when niveau = 1 then 1
else -1
end "STATUS",
niveau + 1 "NIVO",
KLB_NAAM "TITLE",
TO_CHAR(NULL) "ICON", KLG_KLA_ID_KIND "VALUE", 'To do.....' "TOOLTIP",
'javascript:alert("Fout in PKG_KLANT.ZoekKlantGroepBoom, bel 12ICT");' "LINK"
./f?p=200:200:' || sessionId || '::NO:200:P200_KLA_ID:' || KLG_KLA_ID_KIND "LINK"
from
boom
inner join klb_klant_basis klb
on boom.klg_kla_id_kind = klb.klb_kla_id
order by
rij;
Th e fields "klg_kla_id_ouder" and "klg_kla_id_kind" corresponds to respectiverly the parent and child for a given level.
When I navigate through the tree, if I click on the above "LINK", I wish to have a page openend in a new tab, within the same browser, with the same structure/layout than the page the query-report is defined in.
Presumably, I also need have the same session state for both pages: the colling page and the page in the new tab.
Does someone knows how I could define the above "LINK" in order to achieve this result, as well as to propagate the value of "P200_KLA_ID" that corresponds to the child to the new page (here that page is page=200)?
Thanks by advance for any tip.
Kind Regards