APEX

Hi,

You have to use the Anchor ID functionality of a browser - this allows you to add #id to the end of the url where id refers to the id attribute of the item that should receive the focus when the page is reloaded.

As an example: [http://apex.oracle.com/pls/otn/f?p=33642:200]

This, of course, requires a bit of setting up, but is easily doable.

For this example, my SQL statement for the tree is:

SELECT 1 ID, NULL PID, 'Top' NAME, NULL LINK, NULL A1, NULL A2 FROM DUAL
UNION ALL
select "EMPNO" id, 
       1 pid, 
       "ENAME" name, 
       'f?p=' || :APP_ID || ':200:' || :APP_SESSION || '::::P200_EMPNO:' || EMPNO || '#node' || EMPNO link, 
       'node' || EMPNO a1, 
       null a2 
from "#OWNER#"."EMP"

You will note that the URL contains *'#node' || EMPNO* at the end of the link - for an EMPNO of 1234, this would add *#node1234* to the end of the URL. You will also note that I've added *'node' || EMPNO* to the A1 column - whatever I add into this column becomes available for use in the output by referencing it as #A1# in the template. On the tree's template definition, wherever there is an A tag, I've included:

ID="#A1#"

as an attribute of the tag. For example, on the "Name Link Anchor Tag" setting, I have:

<a href="#LINK#" ID="#A1#">#NAME#</a>

and, wherever #A1# appeared outside of an A tag, I have removed it (otherwise, the "node1234" text would appear at that point in the page).

Andy

Hi, Thank you for the help thus far, I think we are getting close.

I'm having two problems with this solution. The node1234 is being appended to my ITEM_NAME at each node showing up on the page. I just want the item name to display without the node123 appended to it.

Secondly, my tree has multiple levels. As I drill down expanding each level below the top of the scroll area the anchor does not work because I'm not clicking the node itself, I'm clicking the + to expand it. It then goes right back to the top leaving my newly expanded leaf below the scroll again. So then I have to scroll down to expand my next node etc.

OK, I see what I did wrong as far as the node1234 being displayed and I've fixed that. but I still need an anchor related to expanding the node rather than clicking on the link. I in fact, do not need a link at all in this particluar case, I've only included it from another page where I have a tree to display a node in colored text when it is clicked based on the value of a hidden computed value elsewhere on the page.

Thanks

Hi,

The images on the tree do have their own links, but you can update these to include the #node1234 text.

On your tree's definition, in most of the template settings, you should see something like:

href="#DRILL_DOWN#" 

This is where the image link is placed. Update all of these to:

href="#DRILL_DOWN#::::##A1#" 

I've updated by example to do this: [http://apex.oracle.com/pls/otn/f?p=33642:200]

Andy

Thanks, that's exactly what I was tinkering with (the #DRILL_DOWN#) after your original post was not quite working for me, but I could not quite figure out how to make that anchor respond. Now it is working. Thanks again!

Also, based on your example, how do you get that tree to have its own scroll area within the page?! I did not realize you can do that and it would be perfect for my app.

Add

<!-- <div style="height:450px; overflow-y:scroll;"> -->

to a "Before tree" box

and

<!-- </div> -->

to a "After tree" box in a tree definition form.

Remove comments (Without comments this code would disappear from this page)

Edited by: ArtS on Dec 7, 2009 10:45 AM

Edited by: ArtS on Dec 7, 2009 10:45 AM