Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't get Tree to work as a dynamic menu (even on apex.oracle.com)

phillips_chrisSep 25 2008 — edited Sep 26 2008
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2008
Added on Sep 25 2008
6 comments
836 views