You can open another page in Oracle Apex using JavaScript by calling the apex.navigation.redirect function. Here's an example:
// Redirect to another page in Oracle Apex apex.navigation.redirect("f?p=&APP_ID.:2:&SESSION.::NO::P2_ITEM_ID:" + itemValue);
// Without Parameter but with JS if condition in Radio Group Item :
if ($v("P16_BASIC_CONFIGURATIONS")=='01') apex.navigation.redirect("f?p=&APP_ID.:14:&SESSION.");
javascript:window.open('f?p=&APP_ID.:2:&APP_SESSION.','_blank');
In this example, &APP_ID. is a substitution string that represents the current
application ID, and &SESSION. represents
the current session ID. The value of itemValue would be the ID of the
item that you want to pass as a parameter to the new page.
You can replace the value of 2 with the ID of the page you want to redirect to.
Note that you may need to modify this code to match your specific requirements,
but this should give you a good starting point.
Connect by prior SQL and url:
select case when connect_by_isleaf = 1 then 0
when level = 1 then 1
else -1
end as status,
level,
"ACNAME" as title,
null as icon,
"ACCODE" as value,
"ACNAME" as tooltip,
'f?p=&APP_ID.:83:'||:APP_SESSION||'::::P83_ACCODE,P83_PARENTACCODE,P83_ACNAME,P83_COMPANY:'||"ACCODE"||','||"PARENTACCODE"||','||"ACNAME"||','||"COMPANY" as link
from "#OWNER#"."CHART_OF_ACC"
WHERE COMPANY=F_COMPANY(:APP_USER)
start with "ACCODE" = 0
connect by prior "ACCODE" = "PARENTACCODE"
order siblings by "ACNAME"
Tags:
Oracle Apex