Can't get Tree to work as a dynamic menu (even on apex.oracle.com)
Hello,
I'm using a Tree for the first time and have followed the process given in the new 'Pro Oracle Application Express' book.
What I have is a Menus table structured as:
menu_id,
parent_menu_id,
description,
url
a typical entry is: menu_id = 2, parent_menu_id = 1, description = Link Number One, URL = f?&APP_ID.:2:&SESSION.
I've created a form and report on the menus table and I've created the Tree, based on a SQL query and it looks OK. When I created the Tree's Link Options, I chose the Form page, URL column.
The problem is that when I click on a Tree leaf it opens the 'Form on Menu' and sets the URL value to that of the menu_id for that record. Looking at the code below from the Tree component, which is created automatically, that is exactly what it would do! I would have expected it to follow the URL.
select "MENU_ID" id,
"PARENT_MENU_ID" pid,
"DESCRIPTION" name,
'f?p=&APP_ID.:10:&SESSION.::NO::P10_URL:'||"MENU_ID" link,
null a1,
null a2
from "#OWNER#"."MENUS"
Am I missing something, misunderstanding something or is this a bug?
I have recreated the situation on apex.oracle.com
You can log in with the following details:
Workspace: sarasa
Username: phillips_chris@hotmail.com
Password: apex_demo
Thanks,
Chris