Apex Dictionary Views: sitemap

Some time ago a customer asked me if it was possible to have a sitemap on a developed application. Of course one could make a static sitemap and update it each time pages are added/changed but having a generic solution would make life so much easier.

This was again an excellent opportunity to make use of the apex dictionary views, seeing I consistently made use of the breadcrumbs, it just was a matter of getting the right query for the correct info. Once I have this info I could use the ApEx Tree option to represent it.


After some trial & error I came up with this:
SELECT breadcrumb_entry_id id,
decode(parent_breadcrumb_id ,
NULL,1,parent_breadcrumb_id )parent_id,
entry_label name
FROM APEX_APPLICATION_BC_ENTRIES
WHERE application_id = v(‘APP_ID’)
UNION
SELECT 0,
NULL,
NULL
FROM DUAL

Now I made a view on this query: v_sitemap
When you make the tree base it on your view and make sure you choose as root value the option static assignment with value 0.

All done and now you have a nice sitemap for your application.

About these ads

7 thoughts on “Apex Dictionary Views: sitemap

  1. Hello Bob,For your Apex 2.2 installation, the view is located under the FLOWS_020200 user.For your 3.0 installation it is the FLOWS_030000 user.Kind reards,Olivier

  2. Hi, somewhat unrelated, would you happen to know the api to delete a menu_option the opposite of create_menu_option?Regards,thanks,using Apex 3x

  3. Managed to create the view OK and I get data in it, however my tree is always blank for some reason. Note sure why, I have used a static assignment for the root note of 0 so I can’t fathom out what I’m doing wrong.

  4. Hey Anonymous,Regarding the menu api, I do not immidialty know what it is but maybe you should have a look at the flows schema?Olivier

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s